explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ruva

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 3,237.853 ↑ 3.6 55 1

HashAggregate (cost=748,988.01..748,990.01 rows=200 width=8) (actual time=3,237.844..3,237.853 rows=55 loops=1)

  • Output: pageorderparent.object_id
  • Group Key: pageorderparent.object_id
  • Buffers: shared hit=115441
2. 5.786 3,237.808 ↑ 97.5 55 1

Nested Loop Semi Join (cost=4,469.46..748,974.60 rows=5,361 width=8) (actual time=1,706.173..3,237.808 rows=55 loops=1)

  • Output: pageorderparent.object_id
  • Join Filter: (pageorderparent.object_id = pageorderparent_2.object_id)
  • Rows Removed by Join Filter: 72101
  • Buffers: shared hit=115441
3. 0.008 3,172.457 ↑ 194.9 55 1

Append (cost=4,445.43..748,553.56 rows=10,722 width=8) (actual time=1,664.805..3,172.457 rows=55 loops=1)

  • Buffers: shared hit=40797
4. 0.236 3,039.421 ↑ 14.2 55 1

Nested Loop Semi Join (cost=4,445.43..732,830.77 rows=779 width=8) (actual time=1,664.805..3,039.421 rows=55 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=34590
5. 1,864.647 3,034.128 ↑ 73.7 389 1

Nested Loop Semi Join (cost=4,445.01..11,449.98 rows=28,652 width=16) (actual time=438.514..3,034.128 rows=389 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Join Filter: (pageorderparent.object_id = appinf.lobj_id)
  • Rows Removed by Join Filter: 22215401
  • Buffers: shared hit=27941
6. 23.401 23.401 ↑ 1.0 57,304 1

Index Only Scan using ix_pageorderparent_parent on dalimes.pageorderparent (cost=0.41..2,531.32 rows=57,304 width=16) (actual time=0.026..23.401 rows=57,304 loops=1)

  • Output: pageorderparent.parent_id, pageorderparent.object_id
  • Heap Fetches: 57304
  • Buffers: shared hit=26077
7. 1,121.300 1,146.080 ↓ 77.6 388 57,304

Materialize (cost=4,444.60..4,620.87 rows=5 width=8) (actual time=0.000..0.020 rows=388 loops=57,304)

  • Output: appinf.lobj_id
  • Buffers: shared hit=1864
8. 0.726 24.780 ↓ 77.8 389 1

Hash Join (cost=4,444.60..4,620.85 rows=5 width=8) (actual time=22.873..24.780 rows=389 loops=1)

  • Output: appinf.lobj_id
  • Hash Cond: (appinf.exestep_id = ex.exestep_id)
  • Buffers: shared hit=1864
9. 7.237 18.194 ↑ 1.0 7,327 1

HashAggregate (cost=1,409.38..1,483.57 rows=7,419 width=16) (actual time=16.989..18.194 rows=7,327 loops=1)

  • Output: appinf.lobj_id, appinf.exestep_id
  • Group Key: appinf.lobj_id, appinf.exestep_id
  • Buffers: shared hit=573
10. 10.957 10.957 ↑ 1.0 30,355 1

Seq Scan on dalimes.approvalinfo appinf (cost=0.00..1,257.60 rows=30,355 width=16) (actual time=0.015..10.957 rows=30,355 loops=1)

  • Output: appinf.lobj_id, appinf.exestep_id
  • Filter: ((appinf.approved = 0) AND (appinf.otpl_id = 52))
  • Rows Removed by Filter: 15285
  • Buffers: shared hit=573
11. 0.252 5.860 ↓ 3.2 1,313 1

Hash (cost=3,030.10..3,030.10 rows=410 width=8) (actual time=5.860..5.860 rows=1,313 loops=1)

  • Output: ex.exestep_id
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 68kB
  • Buffers: shared hit=1291
12. 0.240 5.608 ↓ 3.2 1,313 1

Nested Loop (cost=0.42..3,030.10 rows=410 width=8) (actual time=0.165..5.608 rows=1,313 loops=1)

  • Output: ex.exestep_id
  • Buffers: shared hit=1291
13. 0.160 0.160 ↓ 2.2 28 1

Seq Scan on dalimes.step st (cost=0.00..16.98 rows=13 width=4) (actual time=0.046..0.160 rows=28 loops=1)

  • Output: st.step_id, st.step_parent, st.step_name, st.step_classname, st.step_subclass, st.step_duplid, st.ts_deletion
  • Filter: ((st.ts_deletion = 0) AND ((st.step_subclass)::text = 'Milestone'::text) AND ((st.step_name)::text = ANY ('{"QC Studio","QC Creative","QC Packaging"}'::text[])))
  • Rows Removed by Filter: 504
  • Buffers: shared hit=7
14. 5.208 5.208 ↑ 1.4 47 28

Index Scan using ix_exestep_sysact on dalimes.exestep ex (cost=0.42..231.10 rows=68 width=16) (actual time=0.015..0.186 rows=47 loops=28)

  • 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.ts_deletion = 0) AND (ex.step_id = st.step_id))
  • Buffers: shared hit=1284
15. 1.556 5.057 ↓ 0.0 0 389

Index Scan using ixu_o_folder_id_depth on dalimes.o_folder f (cost=0.42..25.18 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=389)

  • 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)
  • Filter: (f.settings_depth = (SubPlan 1))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=6649
16.          

SubPlan (forIndex Scan)

17. 0.778 3.501 ↑ 1.0 1 389

Aggregate (cost=24.57..24.58 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=389)

  • Output: count(DISTINCT objectaccess_2.depth)
  • Buffers: shared hit=5092
18. 2.723 2.723 ↑ 2.0 1 389

Index Only Scan using ix_objectaccess_object_id on dalimes.objectaccess objectaccess_2 (cost=0.42..24.57 rows=2 width=8) (actual time=0.004..0.007 rows=1 loops=389)

  • Output: objectaccess_2.object_id, objectaccess_2.entry_id, objectaccess_2.depth
  • Index Cond: ((objectaccess_2.object_id = f.lobj_id) AND (objectaccess_2.entry_id = ANY ('{-1,6321,3944,4058}'::bigint[])))
  • Heap Fetches: 514
  • Buffers: shared hit=5089
19. 0.065 133.028 ↓ 0.0 0 1

Hash Semi Join (cost=15,398.79..15,615.57 rows=9,943 width=8) (actual time=133.028..133.028 rows=0 loops=1)

  • Output: pageorderparent_1.object_id
  • Hash Cond: (pageorderparent_1.parent_id = o_job.lobj_id)
  • Buffers: shared hit=6207
20. 0.125 17.351 ↑ 73.7 389 1

Nested Loop (cost=4,621.28..4,652.22 rows=28,652 width=16) (actual time=16.376..17.351 rows=389 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Buffers: shared hit=3421
21. 0.165 16.448 ↓ 77.8 389 1

HashAggregate (cost=4,620.86..4,620.91 rows=5 width=8) (actual time=16.368..16.448 rows=389 loops=1)

  • Output: appinf_1.lobj_id
  • Group Key: appinf_1.lobj_id
  • Buffers: shared hit=1861
22. 0.675 16.283 ↓ 77.8 389 1

Hash Join (cost=4,444.60..4,620.85 rows=5 width=8) (actual time=14.597..16.283 rows=389 loops=1)

  • Output: appinf_1.lobj_id
  • Hash Cond: (appinf_1.exestep_id = ex_1.exestep_id)
  • Buffers: shared hit=1861
23. 6.380 13.728 ↑ 1.0 7,327 1

HashAggregate (cost=1,409.38..1,483.57 rows=7,419 width=16) (actual time=12.695..13.728 rows=7,327 loops=1)

  • Output: appinf_1.lobj_id, appinf_1.exestep_id
  • Group Key: appinf_1.lobj_id, appinf_1.exestep_id
  • Buffers: shared hit=573
24. 7.348 7.348 ↑ 1.0 30,355 1

Seq Scan on dalimes.approvalinfo appinf_1 (cost=0.00..1,257.60 rows=30,355 width=16) (actual time=0.009..7.348 rows=30,355 loops=1)

  • Output: appinf_1.lobj_id, appinf_1.exestep_id
  • Filter: ((appinf_1.approved = 0) AND (appinf_1.otpl_id = 52))
  • Rows Removed by Filter: 15285
  • Buffers: shared hit=573
25. 0.215 1.880 ↓ 3.2 1,313 1

Hash (cost=3,030.10..3,030.10 rows=410 width=8) (actual time=1.880..1.880 rows=1,313 loops=1)

  • Output: ex_1.exestep_id
  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 68kB
  • Buffers: shared hit=1288
26. 0.215 1.665 ↓ 3.2 1,313 1

Nested Loop (cost=0.42..3,030.10 rows=410 width=8) (actual time=0.119..1.665 rows=1,313 loops=1)

  • Output: ex_1.exestep_id
  • Buffers: shared hit=1288
27. 0.134 0.134 ↓ 2.2 28 1

Seq Scan on dalimes.step st_1 (cost=0.00..16.98 rows=13 width=4) (actual time=0.030..0.134 rows=28 loops=1)

  • Output: st_1.step_id, st_1.step_parent, st_1.step_name, st_1.step_classname, st_1.step_subclass, st_1.step_duplid, st_1.ts_deletion
  • Filter: ((st_1.ts_deletion = 0) AND ((st_1.step_subclass)::text = 'Milestone'::text) AND ((st_1.step_name)::text = ANY ('{"QC Studio","QC Creative","QC Packaging"}'::text[])))
  • Rows Removed by Filter: 504
  • Buffers: shared hit=7
28. 1.316 1.316 ↑ 1.4 47 28

Index Scan using ix_exestep_sysact on dalimes.exestep ex_1 (cost=0.42..231.10 rows=68 width=16) (actual time=0.008..0.047 rows=47 loops=28)

  • Output: ex_1.exestep_id, ex_1.wflinst_id, ex_1.lobj_id, ex_1.step_id, ex_1.task_id, ex_1.resultref_id, ex_1.status, ex_1.virtualstatus, ex_1.ts_deletion, ex_1.queueentryid, ex_1.deviceid, ex_1.exestep_info, ex_1.vstatusaction, ex_1.ts_stepbegun, ex_1.ts_stepended, ex_1.ts_submit, ex_1.jdfdoc_id, ex_1.step_bypass
  • Index Cond: (((ex_1.status)::text = 'Held'::text) AND (ex_1.ts_deletion = 0) AND (ex_1.step_id = st_1.step_id))
  • Buffers: shared hit=1281
29. 0.778 0.778 ↑ 1.0 1 389

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_1 (cost=0.41..6.25 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=389)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = appinf_1.lobj_id)
  • Heap Fetches: 389
  • Buffers: shared hit=1560
30. 0.096 115.612 ↑ 23.3 190 1

Hash (cost=10,722.13..10,722.13 rows=4,431 width=16) (actual time=115.612..115.612 rows=190 loops=1)

  • Output: o_job.lobj_id, objectaccess.object_id
  • Buckets: 8192 Batches: 1 Memory Usage: 73kB
  • Buffers: shared hit=2786
31. 6.971 115.516 ↑ 23.3 190 1

Hash Join (cost=10,418.73..10,722.13 rows=4,431 width=16) (actual time=95.886..115.516 rows=190 loops=1)

  • Output: o_job.lobj_id, objectaccess.object_id
  • Hash Cond: (objectaccess.object_id = o_job.lobj_id)
  • Buffers: shared hit=2786
32. 57.205 104.717 ↓ 3.6 75,362 1

HashAggregate (cost=9,939.88..10,151.85 rows=21,197 width=8) (actual time=91.822..104.717 rows=75,362 loops=1)

  • Output: objectaccess.object_id
  • Group Key: objectaccess.object_id
  • Buffers: shared hit=2418
33. 26.125 47.512 ↑ 1.0 148,353 1

Bitmap Heap Scan on dalimes.objectaccess (cost=3,785.04..9,565.90 rows=149,591 width=8) (actual time=21.597..47.512 rows=148,353 loops=1)

  • Output: objectaccess.object_id, objectaccess.entry_id, objectaccess.depth
  • Recheck Cond: (objectaccess.entry_id = ANY ('{-1,6321,3944,4058}'::bigint[]))
  • Heap Blocks: exact=1675
  • Buffers: shared hit=2418
34. 21.387 21.387 ↑ 1.0 148,353 1

Bitmap Index Scan on ixu_objectaccess_group (cost=0.00..3,747.64 rows=149,591 width=0) (actual time=21.387..21.387 rows=148,353 loops=1)

  • Index Cond: (objectaccess.entry_id = ANY ('{-1,6321,3944,4058}'::bigint[]))
  • Buffers: shared hit=743
35. 0.731 3.828 ↑ 1.0 4,431 1

Hash (cost=423.46..423.46 rows=4,431 width=8) (actual time=3.828..3.828 rows=4,431 loops=1)

  • Output: o_job.lobj_id
  • Buckets: 8192 Batches: 1 Memory Usage: 238kB
  • Buffers: shared hit=368
36. 3.097 3.097 ↑ 1.0 4,431 1

Seq Scan on dalimes.o_job (cost=0.00..423.46 rows=4,431 width=8) (actual time=0.004..3.097 rows=4,431 loops=1)

  • Output: o_job.lobj_id
  • Filter: (o_job.ts_deletion = 0)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=368
37. 3.846 59.565 ↓ 656.0 1,312 55

Materialize (cost=24.03..99.39 rows=2 width=8) (actual time=0.389..1.083 rows=1,312 loops=55)

  • Output: pageorderparent_2.object_id
  • Buffers: shared hit=74644
38. 0.218 55.719 ↓ 1,178.0 2,356 1

Append (cost=24.03..99.38 rows=2 width=8) (actual time=21.377..55.719 rows=2,356 loops=1)

  • Buffers: shared hit=74644
39. 0.000 55.501 ↓ 2,356.0 2,356 1

Nested Loop Semi Join (cost=24.03..73.63 rows=1 width=8) (actual time=21.376..55.501 rows=2,356 loops=1)

  • Output: pageorderparent_2.object_id
  • Buffers: shared hit=74644
40. 1.556 28.814 ↓ 2,677.0 2,677 1

Nested Loop (cost=23.62..23.69 rows=1 width=16) (actual time=21.320..28.814 rows=2,677 loops=1)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Buffers: shared hit=32107
41. 1.429 21.904 ↓ 2,677.0 2,677 1

HashAggregate (cost=23.20..23.21 rows=1 width=16) (actual time=21.302..21.904 rows=2,677 loops=1)

  • Output: l0.lobj_id, ln1.childlobj_id
  • Group Key: l0.lobj_id
  • Buffers: shared hit=21378
42. 1.866 20.475 ↓ 2,682.0 2,682 1

Nested Loop (cost=1.80..23.20 rows=1 width=16) (actual time=0.163..20.475 rows=2,682 loops=1)

  • Output: l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=21378
43. 1.647 15.927 ↓ 2,682.0 2,682 1

Nested Loop (cost=1.52..22.77 rows=1 width=32) (actual time=0.145..15.927 rows=2,682 loops=1)

  • Output: l0.lobj_id, ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=13319
44. 0.320 6.234 ↓ 2,682.0 2,682 1

Nested Loop (cost=1.10..21.71 rows=1 width=24) (actual time=0.104..6.234 rows=2,682 loops=1)

  • Output: ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=2571
45. 0.031 0.594 ↓ 190.0 190 1

Nested Loop (cost=0.55..13.12 rows=1 width=8) (actual time=0.082..0.594 rows=190 loops=1)

  • Output: ln2.childlobj_id
  • Buffers: shared hit=190
46. 0.036 0.036 ↑ 1.0 1 1

Seq Scan on dalimes.o_customer p2 (cost=0.00..4.53 rows=1 width=8) (actual time=0.026..0.036 rows=1 loops=1)

  • Output: p2.lobj_id, p2.ts_creation, p2.lobj_isroot, p2.ostt_list, p2.syshierarchy, p2.lobj_name, p2.creationuser_code, p2.ts_deletion, p2.lobj_version, p2.commentulong, p2.defaultproduct_productid, p2.ostt_value, p2.node_id, p2.lastchangeuser_code, p2.ts_lastchange, p2.defaultsite_siteid, p2.parent_node_id, p2.commentushort
  • Filter: ((p2.ts_deletion = 0) AND ((p2.lobj_name)::text = 'ASICS'::text))
  • Rows Removed by Filter: 101
  • Buffers: shared hit=3
47. 0.527 0.527 ↓ 190.0 190 1

Index Only Scan using pk_objectlink on dalimes.objectlink ln2 (cost=0.55..8.58 rows=1 width=16) (actual time=0.053..0.527 rows=190 loops=1)

  • Output: ln2.parentotpl_id, ln2.parentlobj_id, ln2.ts_deletion, ln2.childotpl_id, ln2.childlobj_id, ln2.olnk_id
  • Index Cond: ((ln2.parentotpl_id = 7) AND (ln2.parentlobj_id = p2.lobj_id) AND (ln2.ts_deletion = 0) AND (ln2.childotpl_id = 34))
  • Heap Fetches: 190
  • Buffers: shared hit=187
48. 5.320 5.320 ↓ 14.0 14 190

Index Only Scan using pk_objectlink on dalimes.objectlink ln1 (cost=0.55..8.58 rows=1 width=16) (actual time=0.008..0.028 rows=14 loops=190)

  • Output: ln1.parentotpl_id, ln1.parentlobj_id, ln1.ts_deletion, ln1.childotpl_id, ln1.childlobj_id, ln1.olnk_id
  • Index Cond: ((ln1.parentotpl_id = 34) AND (ln1.parentlobj_id = ln2.childlobj_id) AND (ln1.ts_deletion = 0) AND (ln1.childotpl_id = 52))
  • Heap Fetches: 2682
  • Buffers: shared hit=2381
49. 8.046 8.046 ↑ 1.0 1 2,682

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0 (cost=0.41..1.05 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=2,682)

  • Output: l0.ts_deletion, l0.lobj_id
  • Index Cond: ((l0.ts_deletion = 0) AND (l0.lobj_id = ln1.childlobj_id))
  • Heap Fetches: 2682
  • Buffers: shared hit=10748
50. 2.682 2.682 ↑ 1.0 1 2,682

Index Only Scan using ixu_o_job_id on dalimes.o_job p1 (cost=0.28..0.42 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=2,682)

  • Output: p1.lobj_id, p1.ts_deletion, p1.syshierarchy, p1.lobj_name
  • Index Cond: ((p1.lobj_id = ln1.parentlobj_id) AND (p1.ts_deletion = 0))
  • Heap Fetches: 2682
  • Buffers: shared hit=8059
51. 5.354 5.354 ↑ 1.0 1 2,677

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_2 (cost=0.41..0.47 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=2,677)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Index Cond: (pageorderparent_2.object_id = l0.lobj_id)
  • Heap Fetches: 2677
  • Buffers: shared hit=10729
52. 7.922 26.770 ↑ 1.0 1 2,677

Index Scan using ixu_o_folder_id_depth on dalimes.o_folder f_1 (cost=0.42..25.18 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=2,677)

  • 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)
  • Filter: (f_1.settings_depth = (SubPlan 2))
  • Buffers: shared hit=42537
53.          

SubPlan (forIndex Scan)

54. 4.712 18.848 ↑ 1.0 1 2,356

Aggregate (cost=24.57..24.58 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=2,356)

  • Output: count(DISTINCT objectaccess_3.depth)
  • Buffers: shared hit=32146
55. 14.136 14.136 ↓ 2.0 4 2,356

Index Only Scan using ix_objectaccess_object_id on dalimes.objectaccess objectaccess_3 (cost=0.42..24.57 rows=2 width=8) (actual time=0.002..0.006 rows=4 loops=2,356)

  • Output: objectaccess_3.object_id, objectaccess_3.entry_id, objectaccess_3.depth
  • Index Cond: ((objectaccess_3.object_id = f_1.lobj_id) AND (objectaccess_3.entry_id = ANY ('{-1,6321,3944,4058}'::bigint[])))
  • Heap Fetches: 8400
  • Buffers: shared hit=32146
56. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=24.32..25.73 rows=1 width=8) (never executed)

  • Output: pageorderparent_3.object_id
57. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=23.62..23.69 rows=1 width=16) (never executed)

  • Output: pageorderparent_3.object_id, pageorderparent_3.parent_id
58. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=23.20..23.21 rows=1 width=16) (never executed)

  • Output: l0_1.lobj_id, ln1_1.childlobj_id
  • Group Key: l0_1.lobj_id
59. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.80..23.20 rows=1 width=16) (never executed)

  • Output: l0_1.lobj_id, ln1_1.childlobj_id
60. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.52..22.77 rows=1 width=32) (never executed)

  • Output: l0_1.lobj_id, ln1_1.parentlobj_id, ln1_1.childlobj_id, ln2_1.childlobj_id
61. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.10..21.71 rows=1 width=24) (never executed)

  • Output: ln1_1.parentlobj_id, ln1_1.childlobj_id, ln2_1.childlobj_id
62. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.55..13.12 rows=1 width=8) (never executed)

  • Output: ln2_1.childlobj_id
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.o_customer p2_1 (cost=0.00..4.53 rows=1 width=8) (never executed)

  • Output: p2_1.lobj_id, p2_1.ts_creation, p2_1.lobj_isroot, p2_1.ostt_list, p2_1.syshierarchy, p2_1.lobj_name, p2_1.creationuser_code, p2_1.ts_deletion, p2_1.lobj_version, p2_1.commentulong, p2_1.defaultproduct_productid, p2_1.ostt_value, p2_1.node_id, p2_1.lastchangeuser_code, p2_1.ts_lastchange, p2_1.defaultsite_siteid, p2_1.parent_node_id, p2_1.commentushort
  • Filter: ((p2_1.ts_deletion = 0) AND ((p2_1.lobj_name)::text = 'ASICS'::text))
64. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectlink on dalimes.objectlink ln2_1 (cost=0.55..8.58 rows=1 width=16) (never executed)

  • Output: ln2_1.parentotpl_id, ln2_1.parentlobj_id, ln2_1.ts_deletion, ln2_1.childotpl_id, ln2_1.childlobj_id, ln2_1.olnk_id
  • Index Cond: ((ln2_1.parentotpl_id = 7) AND (ln2_1.parentlobj_id = p2_1.lobj_id) AND (ln2_1.ts_deletion = 0) AND (ln2_1.childotpl_id = 34))
  • Heap Fetches: 0
65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectlink on dalimes.objectlink ln1_1 (cost=0.55..8.58 rows=1 width=16) (never executed)

  • Output: ln1_1.parentotpl_id, ln1_1.parentlobj_id, ln1_1.ts_deletion, ln1_1.childotpl_id, ln1_1.childlobj_id, ln1_1.olnk_id
  • Index Cond: ((ln1_1.parentotpl_id = 34) AND (ln1_1.parentlobj_id = ln2_1.childlobj_id) AND (ln1_1.ts_deletion = 0) AND (ln1_1.childotpl_id = 52))
  • Heap Fetches: 0
66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0_1 (cost=0.41..1.05 rows=1 width=8) (never executed)

  • Output: l0_1.ts_deletion, l0_1.lobj_id
  • Index Cond: ((l0_1.ts_deletion = 0) AND (l0_1.lobj_id = ln1_1.childlobj_id))
  • Heap Fetches: 0
67. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixu_o_job_id on dalimes.o_job p1_1 (cost=0.28..0.42 rows=1 width=8) (never executed)

  • Output: p1_1.lobj_id, p1_1.ts_deletion, p1_1.syshierarchy, p1_1.lobj_name
  • Index Cond: ((p1_1.lobj_id = ln1_1.parentlobj_id) AND (p1_1.ts_deletion = 0))
  • Heap Fetches: 0
68. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_3 (cost=0.41..0.47 rows=1 width=16) (never executed)

  • Output: pageorderparent_3.object_id, pageorderparent_3.parent_id
  • Index Cond: (pageorderparent_3.object_id = l0_1.lobj_id)
  • Heap Fetches: 0
69. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.71..1.37 rows=1 width=16) (never executed)

  • Output: o_job_1.lobj_id, objectaccess_1.object_id
  • Join Filter: (o_job_1.lobj_id = objectaccess_1.object_id)
70. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixu_o_job_id on dalimes.o_job o_job_1 (cost=0.28..0.33 rows=1 width=8) (never executed)

  • 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: 0
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix_objectaccess_object_id on dalimes.objectaccess objectaccess_1 (cost=0.42..1.02 rows=2 width=8) (never executed)

  • 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,6321,3944,4058}'::bigint[]))
  • Heap Fetches: 0