explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IooV : SPL3 fcl=21

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2,111.983 ↓ 0.0 0 1

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

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

CTE pageorder_filter

3. 0.012 0.012 ↑ 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.011..0.012 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. 66.585 970.914 ↓ 37,002.0 37,002 1

Nested Loop (cost=1.41..6,524.54 rows=1 width=8) (actual time=664.751..970.914 rows=37,002 loops=1)

  • Output: appinf.lobj_id
  • Buffers: shared hit=840208
6. 23.380 243.087 ↓ 1,245.3 220,414 1

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

  • Output: ex.exestep_id
  • Buffers: shared hit=167799
7. 0.187 0.187 ↓ 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.022..0.187 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. 219.520 219.520 ↓ 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.009..1.960 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=672409
10. 0.028 2,111.982 ↓ 0.0 0 1

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

  • Output: pageorderparent.object_id
  • Merge Cond: (pageorderparent.object_id = pageorderparent_2.object_id)
  • Buffers: shared hit=2137252
11. 0.794 2,111.736 ↓ 114.5 229 1

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

  • Output: pageorderparent.object_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 209kB
  • Buffers: shared hit=2137221
12. 0.308 2,110.942 ↓ 1,196.5 2,393 1

Append (cost=13.12..76.81 rows=2 width=8) (actual time=2,089.101..2,110.942 rows=2,393 loops=1)

  • Buffers: shared hit=2137221
13. 1.832 1,569.983 ↓ 0.0 0 1

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

  • Output: pageorderparent.object_id
  • Buffers: shared hit=1482557
14. 0.057 1,565.758 ↓ 2,393.0 2,393 1

Nested Loop (cost=12.84..20.88 rows=1 width=16) (actual time=1,555.708..1,565.758 rows=2,393 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Buffers: shared hit=1477771
15. 5.708 1,556.129 ↓ 2,393.0 2,393 1

HashAggregate (cost=12.41..12.42 rows=1 width=8) (actual time=1,555.652..1,556.129 rows=2,393 loops=1)

  • Output: approval_filter.lobjid
  • Group Key: approval_filter.lobjid
  • Buffers: shared hit=1468174
16. 11.612 1,550.421 ↓ 19,663.0 19,663 1

Nested Loop (cost=1.84..12.40 rows=1 width=8) (actual time=664.922..1,550.421 rows=19,663 loops=1)

  • Output: approval_filter.lobjid
  • Buffers: shared hit=1468174
17. 15.870 1,358.244 ↓ 36,113.0 36,113 1

Nested Loop (cost=1.27..9.82 rows=1 width=24) (actual time=664.872..1,358.244 rows=36,113 loops=1)

  • Output: approval_filter.lobjid, l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=1287200
18. 0.000 1,268.370 ↓ 37,002.0 37,002 1

Nested Loop (cost=0.99..9.49 rows=1 width=32) (actual time=664.847..1,268.370 rows=37,002 loops=1)

  • Output: approval_filter.lobjid, l0.lobj_id, ln1.parentlobj_id, ln1.childlobj_id
  • Buffers: shared hit=1174077
19. 29.292 1,122.168 ↓ 37,002.0 37,002 1

Nested Loop (cost=0.43..8.48 rows=1 width=16) (actual time=664.809..1,122.168 rows=37,002 loops=1)

  • Output: approval_filter.lobjid, l0.lobj_id
  • Buffers: shared hit=988748
20. 981.870 981.870 ↓ 37,002.0 37,002 1

CTE Scan on approval_filter (cost=0.00..0.02 rows=1 width=8) (actual time=664.756..981.870 rows=37,002 loops=1)

  • Output: approval_filter.lobjid
  • Buffers: shared hit=840208
21. 111.006 111.006 ↑ 1.0 1 37,002

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=37,002)

  • Output: l0.ts_deletion, l0.lobj_id
  • Index Cond: ((l0.ts_deletion = 0) AND (l0.lobj_id = approval_filter.lobjid))
  • Heap Fetches: 37002
  • Buffers: shared hit=148540
22. 148.008 148.008 ↑ 1.0 1 37,002

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

  • 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=185329
23. 74.004 74.004 ↑ 1.0 1 37,002

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=37,002)

  • 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=113123
24. 180.565 180.565 ↑ 1.0 1 36,113

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=36,113)

  • 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=180974
25. 9.572 9.572 ↑ 1.0 1 2,393

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

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = approval_filter.lobjid)
  • Heap Fetches: 2393
  • Buffers: shared hit=9597
26. 2.393 2.393 ↓ 0.0 0 2,393

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,393)

  • 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=4786
27.          

SubPlan (forIndex 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.883 540.651 ↓ 2,393.0 2,393 1

Nested Loop Semi Join (cost=13.54..21.92 rows=1 width=8) (actual time=519.114..540.651 rows=2,393 loops=1)

  • Output: pageorderparent_1.object_id
  • Buffers: shared hit=654664
31. 1.119 527.803 ↓ 2,393.0 2,393 1

Nested Loop (cost=12.84..20.88 rows=1 width=16) (actual time=519.018..527.803 rows=2,393 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Buffers: shared hit=637563
32. 5.576 519.505 ↓ 2,393.0 2,393 1

HashAggregate (cost=12.41..12.42 rows=1 width=8) (actual time=518.997..519.505 rows=2,393 loops=1)

  • Output: approval_filter_1.lobjid
  • Group Key: approval_filter_1.lobjid
  • Buffers: shared hit=627966
33. 26.938 513.929 ↓ 19,663.0 19,663 1

Nested Loop (cost=1.84..12.40 rows=1 width=8) (actual time=0.074..513.929 rows=19,663 loops=1)

  • Output: approval_filter_1.lobjid
  • Buffers: shared hit=627966
34. 10.590 342.539 ↓ 36,113.0 36,113 1

Nested Loop (cost=1.27..9.82 rows=1 width=24) (actual time=0.050..342.539 rows=36,113 loops=1)

  • Output: approval_filter_1.lobjid, l0_1.lobj_id, ln1_1.childlobj_id
  • Buffers: shared hit=446992
35. 17.120 257.945 ↓ 37,002.0 37,002 1

Nested Loop (cost=0.99..9.49 rows=1 width=32) (actual time=0.037..257.945 rows=37,002 loops=1)

  • Output: approval_filter_1.lobjid, l0_1.lobj_id, ln1_1.parentlobj_id, ln1_1.childlobj_id
  • Buffers: shared hit=333869
36. 13.343 129.819 ↓ 37,002.0 37,002 1

Nested Loop (cost=0.43..8.48 rows=1 width=16) (actual time=0.022..129.819 rows=37,002 loops=1)

  • Output: approval_filter_1.lobjid, l0_1.lobj_id
  • Buffers: shared hit=148540
37. 5.470 5.470 ↓ 37,002.0 37,002 1

CTE Scan on approval_filter approval_filter_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..5.470 rows=37,002 loops=1)

  • Output: approval_filter_1.lobjid
38. 111.006 111.006 ↑ 1.0 1 37,002

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=37,002)

  • 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: 37002
  • Buffers: shared hit=148540
39. 111.006 111.006 ↑ 1.0 1 37,002

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=37,002)

  • 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=185329
40. 74.004 74.004 ↑ 1.0 1 37,002

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=37,002)

  • 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=113123
41. 144.452 144.452 ↑ 1.0 1 36,113

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.004 rows=1 loops=36,113)

  • 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=180974
42. 7.179 7.179 ↑ 1.0 1 2,393

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,393)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = approval_filter_1.lobjid)
  • Heap Fetches: 2393
  • Buffers: shared hit=9597
43. 0.000 11.965 ↑ 2.0 1 2,393

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

  • Output: objectaccess.object_id, o_job.lobj_id
  • Join Filter: (objectaccess.object_id = o_job.lobj_id)
  • Buffers: shared hit=17101
44. 4.786 4.786 ↑ 1.0 1 2,393

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,393)

  • 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: 2393
  • Buffers: shared hit=7214
45. 7.179 7.179 ↑ 3.0 1 2,393

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,393)

  • 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: 4838
  • Buffers: shared hit=9887
46. 0.022 0.218 ↑ 2.0 1 1

Sort (cost=69.26..69.26 rows=2 width=8) (actual time=0.218..0.218 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.003 0.196 ↑ 2.0 1 1

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

  • Buffers: shared hit=31
48. 0.015 0.121 ↓ 0.0 0 1

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

  • Output: pageorderparent_2.object_id
  • Buffers: shared hit=15
49. 0.006 0.096 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Output: pageorder_filter.lobjid
  • Buffers: shared hit=4
53. 0.030 0.030 ↑ 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.030..0.030 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.028 0.028 ↑ 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.028..0.028 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.010 0.010 ↓ 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.010..0.010 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 (forIndex 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.006 0.072 ↑ 1.0 1 1

Nested Loop Semi Join (cost=9.76..18.14 rows=1 width=8) (actual time=0.072..0.072 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.023 ↑ 1.0 1 1

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

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

Nested Loop (cost=0.56..8.62 rows=1 width=8) (actual time=0.016..0.017 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.008 0.008 ↑ 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.008..0.008 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.004 0.004 ↑ 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.004..0.004 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.014 0.032 ↑ 2.0 1 1

Nested Loop (cost=0.70..1.03 rows=2 width=16) (actual time=0.032..0.032 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.013 0.013 ↑ 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.013..0.013 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,113.378 ms