explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GcCj : SPL3 fcl=8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,229.384 ↓ 0.0 0 1

Unique (cost=6,679.06..6,679.10 rows=2 width=8) (actual time=2,229.384..2,229.384 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=2131712
2.          

CTE pageorder_filter

3. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0_2 (cost=0.43..8.45 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

  • Output: l0_2.lobj_id
  • Index Cond: ((l0_2.ts_deletion = 0) AND (l0_2.lobj_id = '25631960'::bigint))
  • Heap Fetches: 1
  • Buffers: shared hit=4
4.          

CTE approval_filter

5. 143.189 1,103.406 ↓ 36,841.0 36,841 1

Nested Loop (cost=1.41..6,524.53 rows=1 width=8) (actual time=720.373..1,103.406 rows=36,841 loops=1)

  • Output: appinf.lobj_id
  • Buffers: shared hit=840185
6. 23.795 298.975 ↓ 1,245.3 220,414 1

Nested Loop (cost=0.98..4,988.04 rows=177 width=8) (actual time=0.095..298.975 rows=220,414 loops=1)

  • Output: ex.exestep_id
  • Buffers: shared hit=167799
7. 1.116 1.116 ↓ 12.4 112 1

Index Only Scan using ix_step_subclass on dalimes.step st (cost=0.41..35.77 rows=9 width=4) (actual time=0.024..1.116 rows=112 loops=1)

  • Output: st.step_subclass, st.ts_deletion, st.step_name, st.step_id
  • Index Cond: ((st.step_subclass = 'Milestone'::text) AND (st.ts_deletion = 0) AND (st.step_name = 'SPL_RETOUCHING_InProduction'::text))
  • Heap Fetches: 112
  • Buffers: shared hit=100
8. 274.064 274.064 ↓ 13.9 1,968 112

Index Scan using ix_exestep_status on dalimes.exestep ex (cost=0.57..548.83 rows=142 width=16) (actual time=0.010..2.447 rows=1,968 loops=112)

  • Output: ex.exestep_id, ex.wflinst_id, ex.lobj_id, ex.step_id, ex.task_id, ex.resultref_id, ex.status, ex.virtualstatus, ex.ts_deletion, ex.queueentryid, ex.deviceid, ex.exestep_info, ex.vstatusaction, ex.ts_stepbegun, ex.ts_stepended, ex.ts_submit, ex.jdfdoc_id, ex.step_bypass
  • Index Cond: (((ex.status)::text = 'Held'::text) AND (ex.step_id = st.step_id))
  • Filter: (ex.ts_deletion = 0)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=167699
9. 661.242 661.242 ↓ 0.0 0 220,414

Index Scan using ix_approvalinfo_exestep on dalimes.approvalinfo appinf (cost=0.42..8.63 rows=5 width=16) (actual time=0.003..0.003 rows=0 loops=220,414)

  • Output: appinf.exestep_id, appinf.wflinst_id, appinf.lobj_id, appinf.otpl_id, appinf.prodgrp_id, appinf.approved, appinf.app_info
  • Index Cond: (appinf.exestep_id = ex.exestep_id)
  • Filter: ((appinf.approved = 0) AND (appinf.otpl_id = 53))
  • Buffers: shared hit=672386
10. 0.022 2,229.384 ↓ 0.0 0 1

Merge Semi Join (cost=146.08..146.12 rows=2 width=8) (actual time=2,229.384..2,229.384 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Merge Cond: (pageorderparent.object_id = pageorderparent_2.object_id)
  • Buffers: shared hit=2131712
11. 0.807 2,229.185 ↓ 114.5 229 1

Sort (cost=76.82..76.82 rows=2 width=8) (actual time=2,229.169..2,229.185 rows=229 loops=1)

  • Output: pageorderparent.object_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 209kB
  • Buffers: shared hit=2131681
12. 0.305 2,228.378 ↓ 1,196.0 2,392 1

Append (cost=13.12..76.81 rows=2 width=8) (actual time=2,204.943..2,228.378 rows=2,392 loops=1)

  • Buffers: shared hit=2131681
13. 1.299 1,671.531 ↓ 0.0 0 1

Nested Loop Semi Join (cost=13.12..54.87 rows=1 width=8) (actual time=1,671.531..1,671.531 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=1479778
14. 0.000 1,667.840 ↓ 2,392.0 2,392 1

Nested Loop (cost=12.84..20.88 rows=1 width=16) (actual time=1,660.256..1,667.840 rows=2,392 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Buffers: shared hit=1474994
15. 5.941 1,660.740 ↓ 2,392.0 2,392 1

HashAggregate (cost=12.41..12.42 rows=1 width=8) (actual time=1,660.244..1,660.740 rows=2,392 loops=1)

  • Output: approval_filter.lobjid
  • Group Key: approval_filter.lobjid
  • Buffers: shared hit=1465401
16. 1.168 1,654.799 ↓ 19,658.0 19,658 1

Nested Loop (cost=1.84..12.40 rows=1 width=8) (actual time=720.431..1,654.799 rows=19,658 loops=1)

  • Output: approval_filter.lobjid
  • Buffers: shared hit=1465401
17. 11.971 1,473.871 ↓ 35,952.0 35,952 1

Nested Loop (cost=1.27..9.82 rows=1 width=24) (actual time=720.411..1,473.871 rows=35,952 loops=1)

  • Output: approval_filter.lobjid, l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=1285232
18. 28.909 1,388.218 ↓ 36,841.0 36,841 1

Nested Loop (cost=0.99..9.49 rows=1 width=32) (actual time=720.403..1,388.218 rows=36,841 loops=1)

  • Output: approval_filter.lobjid, l0.lobj_id, ln1.parentlobj_id, ln1.childlobj_id
  • Buffers: shared hit=1172592
19. 23.810 1,248.786 ↓ 36,841.0 36,841 1

Nested Loop (cost=0.43..8.48 rows=1 width=16) (actual time=720.391..1,248.786 rows=36,841 loops=1)

  • Output: approval_filter.lobjid, l0.lobj_id
  • Buffers: shared hit=988068
20. 1,114.453 1,114.453 ↓ 36,841.0 36,841 1

CTE Scan on approval_filter (cost=0.00..0.02 rows=1 width=8) (actual time=720.376..1,114.453 rows=36,841 loops=1)

  • Output: approval_filter.lobjid
  • Buffers: shared hit=840185
21. 110.523 110.523 ↑ 1.0 1 36,841

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0 (cost=0.43..8.45 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=36,841)

  • Output: l0.ts_deletion, l0.lobj_id
  • Index Cond: ((l0.ts_deletion = 0) AND (l0.lobj_id = approval_filter.lobjid))
  • Heap Fetches: 36841
  • Buffers: shared hit=147883
22. 110.523 110.523 ↑ 1.0 1 36,841

Index Scan using ix_objectlink_ctctp on dalimes.objectlink ln1 (cost=0.56..1.00 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=36,841)

  • Output: ln1.olnk_id, ln1.parentotpl_id, ln1.parentlobj_id, ln1.childotpl_id, ln1.childlobj_id, ln1.ts_deletion
  • Index Cond: ((ln1.childlobj_id = l0.lobj_id) AND (ln1.childotpl_id = 53) AND (ln1.parentotpl_id = 35))
  • Buffers: shared hit=184524
23. 73.682 73.682 ↑ 1.0 1 36,841

Index Scan using ix_o_job_topublish on dalimes.o_job p1 (cost=0.28..0.32 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=36,841)

  • Output: p1.outerpage_scalingvalue, p1.new_useissuescaling, p1.new_routingmargins, p1.lobj_isroot, p1.blocksize_back, p1.lobj_id, p1.new_defaultoffsety, p1.new_pageorderworkflow, p1.segmenttrim_overfold, p1.new_defaultrotation, p1.new_publicationdate, p1.new_defaultoffsetx, p1.new_collatingmarksposition, p1.new_simulation, p1.new_shrinkouterribon, p1.new_jobworkflow, p1.new_inhousepostprocessing, p1.syshierarchy, p1.printedtrim_footer, p1.parent_node_id, p1.outerpage_creepvalue, p1.segmenttrim_outer, p1.lobj_name, p1.segmenttrim_routingmargins, p1.new_folding, p1.new_lockshortname, p1.new_priority, p1.maximalscaling_use, p1.maximalscaling_value, p1.new_reversedview, p1.new_trimmedwidth, p1.new_safetylr, p1.ostt_list, p1.lobj_version, p1.new_exportasrss, p1.new_formworkflow, p1.new_rolemasks, p1.nw_denyupdateofpublicationda, p1.new_trimmedheight, p1.ts_deletion, p1.new_shiftmark, p1.new_site, p1.new_iccname, p1.maximalscaling_steps, p1.ts_creation, p1.printedtrim_head, p1.printedtrim_face, p1.new_skalingmethod, p1.outerpage_scalingstartvalue, p1.segmenttrim_gutter, p1.new_bleedleftandright, p1.new_usesectionscaling, p1.new_pagecuttoff, p1.ts_lastchange, p1.commentulong, p1.new_usenbpageforskaling, p1.creationuser_code, p1.new_safetytb, p1.new_creepingreference, p1.new_applycreeping, p1.new_compensatebracketeffect, p1.segmenttrim_millingdepth, p1.blocksize_front, p1.segmenttrim_footer, p1.new_bleedtopandbottom, p1.new_uselinearissuescaling, p1.innerpage_scalingvalue, p1.maximalscaling_stepsperform, p1.innerpage_creepvalue, p1.commentushort, p1.new_reelpostprocessing, p1.node_id, p1.new_uselinearsectionscaling, p1.new_mainpageorder, p1.ostt_value, p1.lastchangeuser_code, p1.segmenttrim_head
  • Index Cond: (p1.lobj_id = ln1.parentlobj_id)
  • Buffers: shared hit=112640
24. 179.760 179.760 ↑ 1.0 1 35,952

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0 (cost=0.56..2.58 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=35,952)

  • Output: mtd0.val_id, mtd0.lobj_id, mtd0.ns_id, mtd0.data_key, mtd0.data_value, mtd0.data_extid, mtd0.data_type, mtd0.ts_deletion
  • Index Cond: ((mtd0.ts_deletion = 0) AND (mtd0.lobj_id = l0.lobj_id) AND ((mtd0.data_key)::text = 'assignee'::text) AND (mtd0.ns_id = '38'::bigint))
  • Filter: ((mtd0.data_value)::text = 'Creative Clipping Path'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=180169
25. 7.176 7.176 ↑ 1.0 1 2,392

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent (cost=0.43..8.45 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=2,392)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = approval_filter.lobjid)
  • Heap Fetches: 2392
  • Buffers: shared hit=9593
26. 2.392 2.392 ↓ 0.0 0 2,392

Index Scan using ixu_o_folder_id on dalimes.o_folder f (cost=0.28..17.13 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=2,392)

  • Output: f.ss_useversioningfolder, f.settings_template, f.node_id, f.ts_deletion, f.ts_lastchange, f.ts_creation, f.lobj_id, f.settings_uuid, f.settings_folderregexp, f.commentushort, f.settings_folderexclregexp, f.lobj_name, f.settings_volumeid, f.commentulong, f.ostt_list, f.settings_objectid, f.lastchangeuser_code, f.settings_category, f.settings_color, f.ostt_value, f.settings_productname, f.creationuser_code, f.settings_depth, f.settings_insertmetadata, f.settings_rgroupname, f.syshierarchy, f.settings_path, f.lobj_isroot, f.settings_fileexclregexp, f.settings_smartviewname, f.settings_fileregexp, f.lobj_version, f.parent_node_id, f.settings_wgroupname, f.settings_filepattern
  • Index Cond: ((f.lobj_id = pageorderparent.parent_id) AND (f.ts_deletion = 0))
  • Filter: (f.settings_depth = (SubPlan 3))
  • Buffers: shared hit=4784
27.          

SubPlan (for Index Scan)

28. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.82..16.83 rows=1 width=8) (never executed)

  • Output: count(DISTINCT objectaccess_2.depth)
29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_2 (cost=0.42..16.81 rows=3 width=8) (never executed)

  • Output: objectaccess_2.object_id, objectaccess_2.entry_id, objectaccess_2.depth
  • Index Cond: (objectaccess_2.object_id = f.lobj_id)
  • Filter: (objectaccess_2.entry_id = ANY ('{-1,3948,6212,7743,5483,4583,6438,4310,4308,4723,4306,5058,6441,4234,7969,3561,4890,3586,5482,3610,4706,3616,4843,4820,5659,6254,4312,4314}'::bigint[]))
  • Heap Fetches: 0
30. 0.000 556.542 ↓ 2,392.0 2,392 1

Nested Loop Semi Join (cost=13.54..21.92 rows=1 width=8) (actual time=533.411..556.542 rows=2,392 loops=1)

  • Output: pageorderparent_1.object_id
  • Buffers: shared hit=651903
31. 1.311 542.347 ↓ 2,392.0 2,392 1

Nested Loop (cost=12.84..20.88 rows=1 width=16) (actual time=533.361..542.347 rows=2,392 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Buffers: shared hit=634809
32. 6.041 533.860 ↓ 2,392.0 2,392 1

HashAggregate (cost=12.41..12.42 rows=1 width=8) (actual time=533.343..533.860 rows=2,392 loops=1)

  • Output: approval_filter_1.lobjid
  • Group Key: approval_filter_1.lobjid
  • Buffers: shared hit=625216
33. 0.000 527.819 ↓ 19,658.0 19,658 1

Nested Loop (cost=1.84..12.40 rows=1 width=8) (actual time=0.043..527.819 rows=19,658 loops=1)

  • Output: approval_filter_1.lobjid
  • Buffers: shared hit=625216
34. 11.896 353.325 ↓ 35,952.0 35,952 1

Nested Loop (cost=1.27..9.82 rows=1 width=24) (actual time=0.027..353.325 rows=35,952 loops=1)

  • Output: approval_filter_1.lobjid, l0_1.lobj_id, ln1_1.childlobj_id
  • Buffers: shared hit=445047
35. 19.813 267.747 ↓ 36,841.0 36,841 1

Nested Loop (cost=0.99..9.49 rows=1 width=32) (actual time=0.021..267.747 rows=36,841 loops=1)

  • Output: approval_filter_1.lobjid, l0_1.lobj_id, ln1_1.parentlobj_id, ln1_1.childlobj_id
  • Buffers: shared hit=332407
36. 20.813 137.411 ↓ 36,841.0 36,841 1

Nested Loop (cost=0.43..8.48 rows=1 width=16) (actual time=0.012..137.411 rows=36,841 loops=1)

  • Output: approval_filter_1.lobjid, l0_1.lobj_id
  • Buffers: shared hit=147883
37. 6.075 6.075 ↓ 36,841.0 36,841 1

CTE Scan on approval_filter approval_filter_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..6.075 rows=36,841 loops=1)

  • Output: approval_filter_1.lobjid
38. 110.523 110.523 ↑ 1.0 1 36,841

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0_1 (cost=0.43..8.45 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=36,841)

  • Output: l0_1.ts_deletion, l0_1.lobj_id
  • Index Cond: ((l0_1.ts_deletion = 0) AND (l0_1.lobj_id = approval_filter_1.lobjid))
  • Heap Fetches: 36841
  • Buffers: shared hit=147883
39. 110.523 110.523 ↑ 1.0 1 36,841

Index Scan using ix_objectlink_ctctp on dalimes.objectlink ln1_1 (cost=0.56..1.00 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=36,841)

  • Output: ln1_1.olnk_id, ln1_1.parentotpl_id, ln1_1.parentlobj_id, ln1_1.childotpl_id, ln1_1.childlobj_id, ln1_1.ts_deletion
  • Index Cond: ((ln1_1.childlobj_id = l0_1.lobj_id) AND (ln1_1.childotpl_id = 53) AND (ln1_1.parentotpl_id = 35))
  • Buffers: shared hit=184524
40. 73.682 73.682 ↑ 1.0 1 36,841

Index Scan using ix_o_job_topublish on dalimes.o_job p1_1 (cost=0.28..0.32 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=36,841)

  • Output: p1_1.outerpage_scalingvalue, p1_1.new_useissuescaling, p1_1.new_routingmargins, p1_1.lobj_isroot, p1_1.blocksize_back, p1_1.lobj_id, p1_1.new_defaultoffsety, p1_1.new_pageorderworkflow, p1_1.segmenttrim_overfold, p1_1.new_defaultrotation, p1_1.new_publicationdate, p1_1.new_defaultoffsetx, p1_1.new_collatingmarksposition, p1_1.new_simulation, p1_1.new_shrinkouterribon, p1_1.new_jobworkflow, p1_1.new_inhousepostprocessing, p1_1.syshierarchy, p1_1.printedtrim_footer, p1_1.parent_node_id, p1_1.outerpage_creepvalue, p1_1.segmenttrim_outer, p1_1.lobj_name, p1_1.segmenttrim_routingmargins, p1_1.new_folding, p1_1.new_lockshortname, p1_1.new_priority, p1_1.maximalscaling_use, p1_1.maximalscaling_value, p1_1.new_reversedview, p1_1.new_trimmedwidth, p1_1.new_safetylr, p1_1.ostt_list, p1_1.lobj_version, p1_1.new_exportasrss, p1_1.new_formworkflow, p1_1.new_rolemasks, p1_1.nw_denyupdateofpublicationda, p1_1.new_trimmedheight, p1_1.ts_deletion, p1_1.new_shiftmark, p1_1.new_site, p1_1.new_iccname, p1_1.maximalscaling_steps, p1_1.ts_creation, p1_1.printedtrim_head, p1_1.printedtrim_face, p1_1.new_skalingmethod, p1_1.outerpage_scalingstartvalue, p1_1.segmenttrim_gutter, p1_1.new_bleedleftandright, p1_1.new_usesectionscaling, p1_1.new_pagecuttoff, p1_1.ts_lastchange, p1_1.commentulong, p1_1.new_usenbpageforskaling, p1_1.creationuser_code, p1_1.new_safetytb, p1_1.new_creepingreference, p1_1.new_applycreeping, p1_1.new_compensatebracketeffect, p1_1.segmenttrim_millingdepth, p1_1.blocksize_front, p1_1.segmenttrim_footer, p1_1.new_bleedtopandbottom, p1_1.new_uselinearissuescaling, p1_1.innerpage_scalingvalue, p1_1.maximalscaling_stepsperform, p1_1.innerpage_creepvalue, p1_1.commentushort, p1_1.new_reelpostprocessing, p1_1.node_id, p1_1.new_uselinearsectionscaling, p1_1.new_mainpageorder, p1_1.ostt_value, p1_1.lastchangeuser_code, p1_1.segmenttrim_head
  • Index Cond: (p1_1.lobj_id = ln1_1.parentlobj_id)
  • Buffers: shared hit=112640
41. 179.760 179.760 ↑ 1.0 1 35,952

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_1 (cost=0.56..2.58 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=35,952)

  • Output: mtd0_1.val_id, mtd0_1.lobj_id, mtd0_1.ns_id, mtd0_1.data_key, mtd0_1.data_value, mtd0_1.data_extid, mtd0_1.data_type, mtd0_1.ts_deletion
  • Index Cond: ((mtd0_1.ts_deletion = 0) AND (mtd0_1.lobj_id = l0_1.lobj_id) AND ((mtd0_1.data_key)::text = 'assignee'::text) AND (mtd0_1.ns_id = '38'::bigint))
  • Filter: ((mtd0_1.data_value)::text = 'Creative Clipping Path'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=180169
42. 7.176 7.176 ↑ 1.0 1 2,392

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_1 (cost=0.43..8.45 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=2,392)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = approval_filter_1.lobjid)
  • Heap Fetches: 2392
  • Buffers: shared hit=9593
43. 2.392 14.352 ↑ 2.0 1 2,392

Nested Loop (cost=0.70..1.03 rows=2 width=16) (actual time=0.006..0.006 rows=1 loops=2,392)

  • Output: objectaccess.object_id, o_job.lobj_id
  • Join Filter: (objectaccess.object_id = o_job.lobj_id)
  • Buffers: shared hit=17094
44. 4.784 4.784 ↑ 1.0 1 2,392

Index Only Scan using ixu_o_job_id on dalimes.o_job (cost=0.29..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=2,392)

  • Output: o_job.lobj_id, o_job.ts_deletion, o_job.syshierarchy, o_job.lobj_name
  • Index Cond: ((o_job.lobj_id = pageorderparent_1.parent_id) AND (o_job.ts_deletion = 0))
  • Heap Fetches: 2392
  • Buffers: shared hit=7211
45. 7.176 7.176 ↑ 3.0 1 2,392

Index Only Scan using pk_objectaccess on dalimes.objectaccess (cost=0.42..0.68 rows=3 width=8) (actual time=0.003..0.003 rows=1 loops=2,392)

  • Output: objectaccess.object_id, objectaccess.entry_id, objectaccess.depth
  • Index Cond: (objectaccess.object_id = pageorderparent_1.parent_id)
  • Filter: (objectaccess.entry_id = ANY ('{-1,3948,6212,7743,5483,4583,6438,4310,4308,4723,4306,5058,6441,4234,7969,3561,4890,3586,5482,3610,4706,3616,4843,4820,5659,6254,4312,4314}'::bigint[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 4836
  • Buffers: shared hit=9883
46. 0.019 0.177 ↑ 2.0 1 1

Sort (cost=69.26..69.26 rows=2 width=8) (actual time=0.177..0.177 rows=1 loops=1)

  • Output: pageorderparent_2.object_id
  • Sort Key: pageorderparent_2.object_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=31
47. 0.002 0.158 ↑ 2.0 1 1

Append (cost=9.34..69.25 rows=2 width=8) (actual time=0.157..0.158 rows=1 loops=1)

  • Buffers: shared hit=31
48. 0.013 0.088 ↓ 0.0 0 1

Nested Loop Semi Join (cost=9.34..51.08 rows=1 width=8) (actual time=0.088..0.088 rows=0 loops=1)

  • Output: pageorderparent_2.object_id
  • Buffers: shared hit=15
49. 0.009 0.067 ↑ 1.0 1 1

Nested Loop (cost=9.05..17.10 rows=1 width=16) (actual time=0.066..0.067 rows=1 loops=1)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Buffers: shared hit=13
50. 0.008 0.052 ↑ 1.0 1 1

HashAggregate (cost=8.62..8.63 rows=1 width=8) (actual time=0.052..0.052 rows=1 loops=1)

  • Output: pageorder_filter.lobjid
  • Group Key: pageorder_filter.lobjid
  • Buffers: shared hit=9
51. 0.008 0.044 ↑ 1.0 1 1

Nested Loop (cost=0.56..8.62 rows=1 width=8) (actual time=0.043..0.044 rows=1 loops=1)

  • Output: pageorder_filter.lobjid
  • Buffers: shared hit=9
52. 0.017 0.017 ↑ 1.0 1 1

CTE Scan on pageorder_filter (cost=0.00..0.02 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=1)

  • Output: pageorder_filter.lobjid
  • Buffers: shared hit=4
53. 0.019 0.019 ↑ 1.0 1 1

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_2 (cost=0.56..8.59 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Output: mtd0_2.val_id, mtd0_2.lobj_id, mtd0_2.ns_id, mtd0_2.data_key, mtd0_2.data_value, mtd0_2.data_extid, mtd0_2.data_type, mtd0_2.ts_deletion
  • Index Cond: ((mtd0_2.ts_deletion = 0) AND (mtd0_2.lobj_id = pageorder_filter.lobjid) AND ((mtd0_2.data_key)::text = 'retouch'::text) AND (mtd0_2.ns_id = '46'::bigint))
  • Filter: ((mtd0_2.data_value)::text = '1'::text)
  • Buffers: shared hit=5
54. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_2 (cost=0.43..8.45 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Index Cond: (pageorderparent_2.object_id = pageorder_filter.lobjid)
  • Heap Fetches: 1
  • Buffers: shared hit=4
55. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ixu_o_folder_id on dalimes.o_folder f_1 (cost=0.28..17.13 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Output: f_1.ss_useversioningfolder, f_1.settings_template, f_1.node_id, f_1.ts_deletion, f_1.ts_lastchange, f_1.ts_creation, f_1.lobj_id, f_1.settings_uuid, f_1.settings_folderregexp, f_1.commentushort, f_1.settings_folderexclregexp, f_1.lobj_name, f_1.settings_volumeid, f_1.commentulong, f_1.ostt_list, f_1.settings_objectid, f_1.lastchangeuser_code, f_1.settings_category, f_1.settings_color, f_1.ostt_value, f_1.settings_productname, f_1.creationuser_code, f_1.settings_depth, f_1.settings_insertmetadata, f_1.settings_rgroupname, f_1.syshierarchy, f_1.settings_path, f_1.lobj_isroot, f_1.settings_fileexclregexp, f_1.settings_smartviewname, f_1.settings_fileregexp, f_1.lobj_version, f_1.parent_node_id, f_1.settings_wgroupname, f_1.settings_filepattern
  • Index Cond: ((f_1.lobj_id = pageorderparent_2.parent_id) AND (f_1.ts_deletion = 0))
  • Filter: (f_1.settings_depth = (SubPlan 4))
  • Buffers: shared hit=2
56.          

SubPlan (for Index Scan)

57. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.82..16.83 rows=1 width=8) (never executed)

  • Output: count(DISTINCT objectaccess_3.depth)
58. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_3 (cost=0.42..16.81 rows=3 width=8) (never executed)

  • Output: objectaccess_3.object_id, objectaccess_3.entry_id, objectaccess_3.depth
  • Index Cond: (objectaccess_3.object_id = f_1.lobj_id)
  • Filter: (objectaccess_3.entry_id = ANY ('{-1,3948,6212,7743,5483,4583,6438,4310,4308,4723,4306,5058,6441,4234,7969,3561,4890,3586,5482,3610,4706,3616,4843,4820,5659,6254,4312,4314}'::bigint[]))
  • Heap Fetches: 0
59. 0.005 0.068 ↑ 1.0 1 1

Nested Loop Semi Join (cost=9.76..18.14 rows=1 width=8) (actual time=0.068..0.068 rows=1 loops=1)

  • Output: pageorderparent_3.object_id
  • Buffers: shared hit=16
60. 0.007 0.034 ↑ 1.0 1 1

Nested Loop (cost=9.05..17.10 rows=1 width=16) (actual time=0.034..0.034 rows=1 loops=1)

  • Output: pageorderparent_3.object_id, pageorderparent_3.parent_id
  • Buffers: shared hit=9
61. 0.006 0.024 ↑ 1.0 1 1

HashAggregate (cost=8.62..8.63 rows=1 width=8) (actual time=0.024..0.024 rows=1 loops=1)

  • Output: pageorder_filter_1.lobjid
  • Group Key: pageorder_filter_1.lobjid
  • Buffers: shared hit=5
62. 0.007 0.018 ↑ 1.0 1 1

Nested Loop (cost=0.56..8.62 rows=1 width=8) (actual time=0.017..0.018 rows=1 loops=1)

  • Output: pageorder_filter_1.lobjid
  • Buffers: shared hit=5
63. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on pageorder_filter pageorder_filter_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

  • Output: pageorder_filter_1.lobjid
64. 0.010 0.010 ↑ 1.0 1 1

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_3 (cost=0.56..8.59 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=1)

  • Output: mtd0_3.val_id, mtd0_3.lobj_id, mtd0_3.ns_id, mtd0_3.data_key, mtd0_3.data_value, mtd0_3.data_extid, mtd0_3.data_type, mtd0_3.ts_deletion
  • Index Cond: ((mtd0_3.ts_deletion = 0) AND (mtd0_3.lobj_id = pageorder_filter_1.lobjid) AND ((mtd0_3.data_key)::text = 'retouch'::text) AND (mtd0_3.ns_id = '46'::bigint))
  • Filter: ((mtd0_3.data_value)::text = '1'::text)
  • Buffers: shared hit=5
65. 0.003 0.003 ↑ 1.0 1 1

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_3 (cost=0.43..8.45 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: pageorderparent_3.object_id, pageorderparent_3.parent_id
  • Index Cond: (pageorderparent_3.object_id = pageorder_filter_1.lobjid)
  • Heap Fetches: 1
  • Buffers: shared hit=4
66. 0.013 0.029 ↑ 2.0 1 1

Nested Loop (cost=0.70..1.03 rows=2 width=16) (actual time=0.029..0.029 rows=1 loops=1)

  • Output: objectaccess_1.object_id, o_job_1.lobj_id
  • Join Filter: (objectaccess_1.object_id = o_job_1.lobj_id)
  • Buffers: shared hit=7
67. 0.005 0.005 ↑ 1.0 1 1

Index Only Scan using ixu_o_job_id on dalimes.o_job o_job_1 (cost=0.29..0.31 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Output: o_job_1.lobj_id, o_job_1.ts_deletion, o_job_1.syshierarchy, o_job_1.lobj_name
  • Index Cond: ((o_job_1.lobj_id = pageorderparent_3.parent_id) AND (o_job_1.ts_deletion = 0))
  • Heap Fetches: 1
  • Buffers: shared hit=3
68. 0.011 0.011 ↑ 3.0 1 1

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_1 (cost=0.42..0.68 rows=3 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Output: objectaccess_1.object_id, objectaccess_1.entry_id, objectaccess_1.depth
  • Index Cond: (objectaccess_1.object_id = pageorderparent_3.parent_id)
  • Filter: (objectaccess_1.entry_id = ANY ('{-1,3948,6212,7743,5483,4583,6438,4310,4308,4723,4306,5058,6441,4234,7969,3561,4890,3586,5482,3610,4706,3616,4843,4820,5659,6254,4312,4314}'::bigint[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 2
  • Buffers: shared hit=4
Execution time : 2,230.336 ms