explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gdQW

Settings
# exclusive inclusive rows x rows loops node
1. 0.285 1,844.883 ↓ 3.7 455 1

Sort (cost=15,580.91..15,581.22 rows=124 width=1,169) (actual time=1,844.860..1,844.883 rows=455 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, p1.settings_unum, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.ts_lastchange, l0.ts_creation, ((SubPlan 1)), p1.lobj_id, p1.lobj_name, p1.creationuser_code, p1.lastchangeuser_code, ((SubPlan 2))
  • Sort Key: l0.ts_creation DESC
  • Sort Method: quicksort Memory: 259kB
  • Buffers: shared hit=19,334 read=1,776
  • I/O Timings: read=1,809.189
2. 1.411 1,844.598 ↓ 3.7 455 1

HashAggregate (cost=11,261.39..15,575.36 rows=124 width=73) (actual time=1,844.392..1,844.598 rows=455 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, p1.settings_unum, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.ts_lastchange, l0.ts_creation, ((SubPlan 1)), p1.lobj_id, p1.lobj_name, p1.creationuser_code, p1.lastchangeuser_code, ((SubPlan 2))
  • Group Key: l0.lobj_id, l0.lobj_name, p1.settings_unum, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.ts_lastchange, l0.ts_creation, (SubPlan 1), p1.lobj_id, p1.lobj_name, p1.creationuser_code, p1.lastchangeuser_code, (SubPlan 2)
  • Buffers: shared hit=19,331 read=1,776
  • I/O Timings: read=1,809.189
3. 2.202 1,843.187 ↓ 3.7 455 1

Nested Loop (cost=1.68..11,255.50 rows=124 width=73) (actual time=3.085..1,843.187 rows=455 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, p1.settings_unum, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.lobj_id, l0.ts_lastchange, l0.ts_creation, (SubPlan 1), p1.lobj_id, p1.lobj_name, p1.creationuser_code, p1.lastchangeuser_code, (SubPlan 2)
  • Buffers: shared hit=19,331 read=1,776
  • I/O Timings: read=1,809.189
4. 1.054 818.621 ↓ 2.5 2,289 1

Nested Loop (cost=1.12..5,945.93 rows=902 width=49) (actual time=1.799..818.621 rows=2,289 loops=1)

  • Output: ln1.childlobj_id, p1.settings_unum, p1.lobj_id, p1.lobj_name, p1.creationuser_code, p1.lastchangeuser_code
  • Buffers: shared hit=4,405 read=641
  • I/O Timings: read=805.552
5. 452.657 452.657 ↑ 1.0 455 1

Index Scan using ix_o_filebag_unum on dalimes.o_filebag p1 (cost=0.56..3,701.12 rows=455 width=41) (actual time=0.987..452.657 rows=455 loops=1)

  • Output: p1.lobj_version, p1.settings_releasenumber, p1.ts_creation, p1.settings_unum, p1.lobj_isroot, p1.commentulong, p1.settings_category, p1.parent_node_id, p1.settings_color, p1.settings_ctcount, p1.lobj_name, p1.lobj_id, p1.settings_realcolor, p1.settings_objecthierarchy, p1.ostt_value, p1.settings_wflname, p1.lastchangeuser_code, p1.creationuser_code, p1.ts_deletion, p1.settings_pagecount, p1.settings_pipeid, p1.ts_lastchange, p1.node_id, p1.commentushort, p1.ostt_list, p1.settings_ruleid, p1.settings_spreadnumber, p1.settings_lwcount, p1.syshierarchy, p1.archive_p5id
  • Index Cond: (((p1.settings_unum)::text = ANY ('{ES9140177,ES9140176,ES9140175,ES9140174,ES9140173,ES9140172,ES9140171,ES9140170,ES8908958,ES9140179,ES8908957,ES9140178,ES9140180,ES9140188,ES9140187,ES8717099,ES9140186,ES8717098,ES9140185,ES8717097,ES9140184,ES8717096,ES9140183,ES8717095,ES9140182,ES8717094,ES9140181,ES9140189,ES8879098,ES8879097,ES9140166,ES9140165,ES9140164,ES9140163,ES9140160,ES8874943,ES9030558,ES8874942,ES9030559,ES8874941,ES8874940,ES9140169,ES9030554,ES9140168,ES9140167,ES9130289,ES9030600,ES9030601,ES9030602,ES9030603,ES9030608,ES9030609,ES9030604,ES9030605,ES9030606,ES9030607,ES9113718,ES9113719,ES9113716,ES9113717,ES9113714,ES9113715,ES9030611,ES9030612,ES9030613,ES9030614,ES9030610,ES9030619,ES9030615,ES9030616,ES9154142,ES9030618,ES9140191,ES9140190,ES9140199,ES9140198,ES9140197,ES9140196,ES9140195,ES9113726,ES9140194,ES9113723,ES9140193,ES9113724,ES9140192,ES9113721,ES9030623,ES9113722,ES9030620,ES9030621,ES9130293,ES9130292,ES9130298,ES9042345,ES9042344,ES9138808,ES9138807,ES9113749,ES9138809,ES9138804,ES9138803,ES9138806,ES9138805,ES9113743,ES9138800,ES9138802,ES9138801,ES9042343,ES9042342,ES9042341,ES9042340,ES8908578,ES8908577,ES9113756,ES9113753,ES8717248,ES8717245,ES9179103,ES9179100,ES9179102,ES9179101,ES8717244,ES9138829,ES8717240,ES9138826,ES9138825,ES9138828,ES9138827,ES9138822,ES9138821,ES9138824,ES8717238,ES9138823,ES8717235,ES9138820,ES8717234,ES9138819,ES9138818,ES8717231,ES8717230,ES9138815,ES9138814,ES9138817,ES9138816,ES9138811,ES9138810,ES8717107,ES8717228,ES9138813,ES8717106,ES9138812,ES8717105,ES8717226,ES8717104,ES8717225,ES8717103,ES8717223,ES9088663,ES9088664,ES9088661,ES9088662,ES9030560,ES9030561,ES8874939,ES9030562,ES8874938,ES9138848,ES8874937,ES9138847,ES8874936,ES8874935,ES9138849,ES8874934,ES9138844,ES8874933,ES9030568,ES9138843,ES8874932,ES9138846,ES8874931,ES9138845,ES8874930,ES9030563,ES9138840,ES9030564,ES9030565,ES9138842,ES9138841,ES9030566,ES9088667,ES9088668,ES9088665,ES9088675,ES9088673,ES9088670,ES9030570,ES9030571,ES8874929,ES9030572,ES9030573,ES9138837,ES9138836,ES9138839,ES9138838,ES9030578,ES9138833,ES9030579,ES9138832,ES9138835,ES9138834,ES9030575,ES9030576,ES9138831,ES9030577,ES9138830,ES9088677,ES9042325,ES9042324,ES9042323,ES9042329,ES9042328,ES9042327,ES9042326,ES9030581,ES9030582,ES9030583,ES9030584,ES9054310,ES9054311,ES9030580,ES9135234,ES9054314,ES9030589,ES9054312,ES9054313,ES9135231,ES9030585,ES9138862,ES9030586,ES9030587,ES9030588,ES9138863,ES9042336,ES9042335,ES9042334,ES9042333,ES9042339,ES9042338,ES9042337,ES9030592,ES9030593,ES9030594,ES9030595,ES9138859,ES9138858,ES9030590,ES9030591,ES9138855,ES9138854,ES9138857,ES9030596,ES9054307,ES9138851,ES9030597,ES9054308,ES9138850,ES9030598,ES9054305,ES9030599,ES9054306,ES9138852,ES9054309,ES8953999,ES8953998,ES9042332,ES8953997,ES9042331,ES9042330,ES8873091,ES8873090,ES9140977,ES8873088,ES8873089,ES9140978,ES9147113,ES9147114,ES9147111,ES9147112,ES9147117,ES9147115,ES9147116,ES9147110,ES9138774,ES9138773,ES8857642,ES8857643,ES8857644,ES8857640,ES8857641,ES8717101,ES8717222,ES8717100,ES8717221,ES8717219,ES8717218,ES8857631,ES8857632,ES8857633,ES8857634,ES8957020,ES8957022,ES8857630,ES8957021,ES8857639,ES8857635,ES8857636,ES8857637,ES8857638,ES9138799,ES9138798,ES8957019,ES8908581,ES8908580,ES9002505,ES8908585,ES9002504,ES8908584,ES9002503,ES8908583,ES9002502,ES8908582,ES8908589,ES8908587,ES8908586,ES9179096,ES9179095,ES9179098,ES8908579,ES9179097,ES9002501,ES9002500,ES9179094,ES9179093,ES8957024,ES8957023,ES8957026,ES8957025,ES8957028,ES8957027,ES9179099,ES8908590,ES9175438,ES9175439,ES9175433,ES9175434,ES9175435,ES9175436,ES9140210,ES9140218,ES9140217,ES9140216,ES9140215,ES9140214,ES9140213,ES9140212,ES9140211,ES9175430,ES9175431,ES9175432,ES9140219,ES9175426,ES9175427,ES9151119,ES9175428,ES9175429,ES9175422,ES9175423,ES9175424,ES9175425,ES9140220,ES9140227,ES9140225,ES9140224,ES9140222,ES9175420,ES9175421,ES9175415,ES9175416,ES9175417,ES9175418,ES9175411,ES9175412,ES9175413,ES9175414,ES9175419,ES9175410,ES9175404,ES9175405,ES9175406,ES9175407,ES9175402,ES9175403,ES9175408,ES9175409,ES8954005,ES9140207,ES8954004,ES9140206,ES8954003,ES9140205,ES8954002,ES9140204,ES8954001,ES9140203,ES8954000,ES9140202,ES9140201,ES9140200,ES8954009,ES8954008,ES8954007,ES9140209,ES8954006,ES9140208,ES8954011,ES8954010,ES9140376,ES8954027,ES9184003,ES9184006,ES9002499,ES8954028,ES8607153,ES8607154,ES8607150,ES8607151,ES8607152,ES9184014,ES9184013,ES8607146,ES8607147,ES8607148,ES8607149,ES9175445,ES8607142,ES8607143,ES8607144,ES8607145,ES8607140,ES8607141,ES8607139,ES8607137,ES8607138,ES9175441,ES9175443}'::text[])) AND (p1.ts_deletion = 0))
  • Buffers: shared hit=1,959 read=296
  • I/O Timings: read=445.863
6. 364.910 364.910 ↓ 2.5 5 455

Index Only Scan using pk_objectlink on dalimes.objectlink ln1 (cost=0.56..4.91 rows=2 width=16) (actual time=0.349..0.802 rows=5 loops=455)

  • Output: ln1.parentotpl_id, ln1.parentlobj_id, ln1.ts_deletion, ln1.childotpl_id, ln1.childlobj_id, ln1.olnk_id
  • Index Cond: ((ln1.parentotpl_id = 61) AND (ln1.parentlobj_id = p1.lobj_id) AND (ln1.ts_deletion = 0) AND (ln1.childotpl_id = 21))
  • Heap Fetches: 2,286
  • Buffers: shared hit=2,446 read=345
  • I/O Timings: read=359.689
7. 517.314 517.314 ↓ 0.0 0 2,289

Index Scan using ixu_o_runlist_id on dalimes.o_runlist l0 (cost=0.56..1.10 rows=1 width=32) (actual time=0.223..0.226 rows=0 loops=2,289)

  • Output: l0.filespec_fileversion, l0.lobj_name, l0.filespec_resolution, l0.filespec_filealias, l0.parent_node_id, l0.creationuser_code, l0.commentushort, l0.commentulong, l0.ostt_value, l0.node_id, l0.ts_creation, l0.ostt_list, l0.syshierarchy, l0.filespec_filesize, l0.filespec_run, l0.lobj_version, l0.lastchangeuser_code, l0.ts_deletion, l0.filespec_userfilename, l0.filespec_mimetype, l0.filespec_filedate, l0.ts_lastchange, l0.filespec_pagenumber, l0.filespec_url, l0.lobj_isroot, l0.lobj_id, l0.filespec_mimetypeversion
  • Index Cond: ((l0.lobj_id = ln1.childlobj_id) AND (l0.ts_deletion = 0))
  • Filter: ((l0.lobj_name)::text = ANY ('{DataResource,Composite}'::text[]))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=10,850 read=640
  • I/O Timings: read=506.736
8.          

SubPlan (for Nested Loop)

9. 468.195 468.195 ↑ 6.0 1 455

Index Scan using ixu_mdt_filebag_lobjidkey on dalimes.mdt_filebag (cost=0.56..17.39 rows=6 width=36) (actual time=1.028..1.029 rows=1 loops=455)

  • Output: mdt_filebag.data_value
  • Index Cond: ((mdt_filebag.ts_deletion = 0) AND (mdt_filebag.lobj_id = p1.lobj_id) AND ((mdt_filebag.data_key)::text = 'MediaBox'::text) AND (mdt_filebag.ns_id = 0))
  • Buffers: shared hit=1,870 read=412
  • I/O Timings: read=463.064
10. 36.855 36.855 ↑ 6.0 1 455

Index Scan using ixu_mdt_filebag_lobjidkey on dalimes.mdt_filebag mdt_filebag_1 (cost=0.56..17.39 rows=6 width=36) (actual time=0.081..0.081 rows=1 loops=455)

  • Output: mdt_filebag_1.data_value
  • Index Cond: ((mdt_filebag_1.ts_deletion = 0) AND (mdt_filebag_1.lobj_id = p1.lobj_id) AND ((mdt_filebag_1.data_key)::text = 'TrimBox'::text) AND (mdt_filebag_1.ns_id = 0))
  • Buffers: shared hit=2,206 read=83
  • I/O Timings: read=33.837
Planning time : 43.377 ms
Execution time : 1,848.364 ms