explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vTnN

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

Unique (cost=131.48..131.53 rows=2 width=8) (actual time=2,761.418..2,761.418 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=85292 read=3948
  • I/O Timings: read=2506.741
2.          

CTE mdt_filter

3. 3.798 2,268.348 ↓ 1,450.0 1,450 1

HashAggregate (cost=21.21..21.22 rows=1 width=8) (actual time=2,267.686..2,268.348 rows=1,450 loops=1)

  • Output: l0.lobj_id
  • Group Key: l0.lobj_id
  • Buffers: shared hit=54194 read=3679
  • I/O Timings: read=2087.623
4. 5.124 2,264.550 ↓ 1,450.0 1,450 1

Nested Loop (cost=2.40..21.21 rows=1 width=8) (actual time=105.796..2,264.550 rows=1,450 loops=1)

  • Output: l0.lobj_id
  • Buffers: shared hit=54194 read=3679
  • I/O Timings: read=2087.623
5. 5.684 258.971 ↓ 5,765.0 5,765 1

Nested Loop (cost=1.83..15.42 rows=1 width=16) (actual time=69.085..258.971 rows=5,765 loops=1)

  • Output: l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=28848 read=125
  • I/O Timings: read=173.440
6. 8.491 195.637 ↓ 5,765.0 5,765 1

Nested Loop (cost=1.55..13.10 rows=1 width=32) (actual time=68.626..195.637 rows=5,765 loops=1)

  • Output: l0.lobj_id, ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=17322 read=120
  • I/O Timings: read=140.707
7. 2.951 100.671 ↓ 5,765.0 5,765 1

Nested Loop (cost=1.12..10.59 rows=1 width=24) (actual time=55.750..100.671 rows=5,765 loops=1)

  • Output: ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=47 read=59
  • I/O Timings: read=92.969
8. 0.025 37.396 ↓ 12.0 12 1

Nested Loop (cost=0.56..6.00 rows=1 width=8) (actual time=37.331..37.396 rows=12 loops=1)

  • Output: ln2.childlobj_id
  • Buffers: shared hit=4 read=4
  • I/O Timings: read=37.224
9. 0.038 0.038 ↑ 1.0 1 1

Seq Scan on dalimes.o_customer p2 (cost=0.00..1.41 rows=1 width=8) (actual time=0.020..0.038 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 = 'Lana Jewelry'::text))
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1
10. 37.333 37.333 ↓ 12.0 12 1

Index Only Scan using pk_objectlink on dalimes.objectlink ln2 (cost=0.56..4.58 rows=1 width=16) (actual time=37.306..37.333 rows=12 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 = 8) AND (ln2.parentlobj_id = p2.lobj_id) AND (ln2.ts_deletion = 0) AND (ln2.childotpl_id = 35))
  • Heap Fetches: 0
  • Buffers: shared hit=3 read=4
  • I/O Timings: read=37.224
11. 60.324 60.324 ↓ 480.0 480 12

Index Only Scan using pk_objectlink on dalimes.objectlink ln1 (cost=0.56..4.58 rows=1 width=16) (actual time=3.438..5.027 rows=480 loops=12)

  • Output: ln1.parentotpl_id, ln1.parentlobj_id, ln1.ts_deletion, ln1.childotpl_id, ln1.childlobj_id, ln1.olnk_id
  • Index Cond: ((ln1.parentotpl_id = 35) AND (ln1.parentlobj_id = ln2.childlobj_id) AND (ln1.ts_deletion = 0) AND (ln1.childotpl_id = 53))
  • Heap Fetches: 0
  • Buffers: shared hit=43 read=55
  • I/O Timings: read=55.745
12. 86.475 86.475 ↑ 1.0 1 5,765

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0 (cost=0.43..2.50 rows=1 width=8) (actual time=0.014..0.015 rows=1 loops=5,765)

  • Output: l0.ts_deletion, l0.lobj_id
  • Index Cond: ((l0.ts_deletion = 0) AND (l0.lobj_id = ln1.childlobj_id))
  • Heap Fetches: 0
  • Buffers: shared hit=17275 read=61
  • I/O Timings: read=47.738
13. 57.650 57.650 ↑ 1.0 1 5,765

Index Only Scan using ixu_o_job_id on dalimes.o_job p1 (cost=0.29..2.31 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=5,765)

  • 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: 0
  • Buffers: shared hit=11526 read=5
  • I/O Timings: read=32.733
14. 2,000.455 2,000.455 ↓ 0.0 0 5,765

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0 (cost=0.56..5.78 rows=1 width=8) (actual time=0.347..0.347 rows=0 loops=5,765)

  • 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 = 'Comp_Layer'::text) AND (mtd0.ns_id = 101))
  • Filter: ((mtd0.data_value)::text = '0'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=25346 read=3554
  • I/O Timings: read=1914.183
15. 0.005 2,761.418 ↓ 0.0 0 1

Merge Semi Join (cost=110.26..110.30 rows=2 width=8) (actual time=2,761.418..2,761.418 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Merge Cond: (pageorderparent.object_id = pageorderparent_2.object_id)
  • Buffers: shared hit=85292 read=3948
  • I/O Timings: read=2506.741
16. 0.696 2,516.951 ↑ 2.0 1 1

Sort (cost=19.77..19.77 rows=2 width=8) (actual time=2,516.951..2,516.951 rows=1 loops=1)

  • Output: pageorderparent.object_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 116kB
  • Buffers: shared hit=73757 read=3783
  • I/O Timings: read=2295.926
17. 0.450 2,516.255 ↓ 725.0 1,450 1

Append (cost=0.73..19.76 rows=2 width=8) (actual time=2,351.448..2,516.255 rows=1,450 loops=1)

  • Buffers: shared hit=73757 read=3783
  • I/O Timings: read=2295.926
18. 0.806 2,475.092 ↓ 796.0 796 1

Nested Loop Semi Join (cost=0.73..14.26 rows=1 width=8) (actual time=2,351.447..2,475.092 rows=796 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=64537 read=3780
  • I/O Timings: read=2270.075
19. 1.848 2,430.786 ↓ 1,450.0 1,450 1

Nested Loop (cost=0.45..4.49 rows=1 width=16) (actual time=2,299.627..2,430.786 rows=1,450 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Buffers: shared hit=58458 read=3774
  • I/O Timings: read=2240.485
20. 1.544 2,270.888 ↓ 1,450.0 1,450 1

HashAggregate (cost=0.02..0.03 rows=1 width=8) (actual time=2,270.351..2,270.888 rows=1,450 loops=1)

  • Output: mdt_filter.lobjid
  • Group Key: mdt_filter.lobjid
  • Buffers: shared hit=54194 read=3679
  • I/O Timings: read=2087.623
21. 2,269.344 2,269.344 ↓ 1,450.0 1,450 1

CTE Scan on mdt_filter (cost=0.00..0.02 rows=1 width=8) (actual time=2,267.690..2,269.344 rows=1,450 loops=1)

  • Output: mdt_filter.lobjid
  • Buffers: shared hit=54194 read=3679
  • I/O Timings: read=2087.623
22. 158.050 158.050 ↑ 1.0 1 1,450

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent (cost=0.43..4.45 rows=1 width=16) (actual time=0.109..0.109 rows=1 loops=1,450)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = mdt_filter.lobjid)
  • Heap Fetches: 0
  • Buffers: shared hit=4264 read=95
  • I/O Timings: read=152.862
23. 24.396 43.500 ↑ 1.0 1 1,450

Index Scan using ixu_o_folder_id on dalimes.o_folder f (cost=0.28..5.03 rows=1 width=8) (actual time=0.030..0.030 rows=1 loops=1,450)

  • 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 2))
  • Buffers: shared hit=6079 read=6
  • I/O Timings: read=29.590
24.          

SubPlan (forIndex Scan)

25. 3.184 19.104 ↑ 1.0 1 796

Aggregate (cost=4.71..4.72 rows=1 width=8) (actual time=0.024..0.024 rows=1 loops=796)

  • Output: count(DISTINCT objectaccess_2.depth)
  • Buffers: shared hit=2387 read=2
  • I/O Timings: read=11.036
26. 15.920 15.920 ↑ 1.0 3 796

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_2 (cost=0.42..4.71 rows=3 width=8) (actual time=0.017..0.020 rows=3 loops=796)

  • 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,35,6212,7743,6890,333,4583,6438,4310,4308,4306,5058,3590,3624,6441,4234,7969,3561,4890,3586,3596,5482,444,3610,4706,3616,4820,5659,6254,4312,3620,4314}'::bigint[]))
  • Rows Removed by Filter: 2
  • Heap Fetches: 0
  • Buffers: shared hit=2387 read=2
  • I/O Timings: read=11.036
27. 0.269 40.713 ↓ 654.0 654 1

Nested Loop Semi Join (cost=1.16..5.47 rows=1 width=8) (actual time=0.527..40.713 rows=654 loops=1)

  • Output: pageorderparent_1.object_id
  • Buffers: shared hit=9220 read=3
  • I/O Timings: read=25.851
28. 1.752 7.094 ↓ 1,450.0 1,450 1

Nested Loop (cost=0.45..4.50 rows=1 width=16) (actual time=0.500..7.094 rows=1,450 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Buffers: shared hit=4359
29. 0.851 0.992 ↓ 1,450.0 1,450 1

HashAggregate (cost=0.02..0.03 rows=1 width=8) (actual time=0.495..0.992 rows=1,450 loops=1)

  • Output: mdt_filter_1.lobjid
  • Group Key: mdt_filter_1.lobjid
30. 0.141 0.141 ↓ 1,450.0 1,450 1

CTE Scan on mdt_filter mdt_filter_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.141 rows=1,450 loops=1)

  • Output: mdt_filter_1.lobjid
31. 4.350 4.350 ↑ 1.0 1 1,450

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

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = mdt_filter_1.lobjid)
  • Heap Fetches: 0
  • Buffers: shared hit=4359
32. 0.878 33.350 ↓ 0.0 0 1,450

Nested Loop Semi Join (cost=0.70..0.96 rows=1 width=16) (actual time=0.023..0.023 rows=0 loops=1,450)

  • Output: o_job.lobj_id, objectaccess.object_id
  • Buffers: shared hit=4861 read=3
  • I/O Timings: read=25.851
33. 4.350 4.350 ↓ 0.0 0 1,450

Index Only Scan using ixu_o_job_id on dalimes.o_job (cost=0.29..0.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1,450)

  • 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: 0
  • Buffers: shared hit=2901
34. 28.122 28.122 ↑ 3.0 1 654

Index Only Scan using pk_objectaccess on dalimes.objectaccess (cost=0.42..0.88 rows=3 width=8) (actual time=0.043..0.043 rows=1 loops=654)

  • Output: objectaccess.object_id, objectaccess.entry_id, objectaccess.depth
  • Index Cond: (objectaccess.object_id = o_job.lobj_id)
  • Filter: (objectaccess.entry_id = ANY ('{-1,35,6212,7743,6890,333,4583,6438,4310,4308,4306,5058,3590,3624,6441,4234,7969,3561,4890,3586,3596,5482,444,3610,4706,3616,4820,5659,6254,4312,3620,4314}'::bigint[]))
  • Heap Fetches: 0
  • Buffers: shared hit=1960 read=3
  • I/O Timings: read=25.851
35. 0.009 244.462 ↓ 0.0 0 1

Sort (cost=90.50..90.50 rows=2 width=8) (actual time=244.462..244.462 rows=0 loops=1)

  • Output: pageorderparent_2.object_id
  • Sort Key: pageorderparent_2.object_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=11535 read=165
  • I/O Timings: read=210.815
36. 0.003 244.453 ↓ 0.0 0 1

Append (cost=36.09..90.49 rows=2 width=8) (actual time=244.453..244.453 rows=0 loops=1)

  • Buffers: shared hit=11535 read=165
  • I/O Timings: read=210.815
37. 0.001 232.957 ↓ 0.0 0 1

Nested Loop Semi Join (cost=36.09..49.63 rows=1 width=8) (actual time=232.957..232.957 rows=0 loops=1)

  • Output: pageorderparent_2.object_id
  • Buffers: shared hit=5685 read=165
  • I/O Timings: read=210.815
38. 0.002 232.956 ↓ 0.0 0 1

Nested Loop (cost=35.81..39.86 rows=1 width=16) (actual time=232.956..232.956 rows=0 loops=1)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Buffers: shared hit=5685 read=165
  • I/O Timings: read=210.815
39. 0.002 232.954 ↓ 0.0 0 1

HashAggregate (cost=35.38..35.39 rows=1 width=8) (actual time=232.954..232.954 rows=0 loops=1)

  • Output: appinf.lobj_id
  • Group Key: appinf.lobj_id
  • Buffers: shared hit=5685 read=165
  • I/O Timings: read=210.815
40. 1.686 232.952 ↓ 0.0 0 1

Nested Loop (cost=0.42..35.38 rows=1 width=8) (actual time=232.952..232.952 rows=0 loops=1)

  • Output: appinf.lobj_id
  • Buffers: shared hit=5685 read=165
  • I/O Timings: read=210.815
41. 0.716 0.716 ↓ 1,450.0 1,450 1

CTE Scan on mdt_filter mdt_filter_2 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.716 rows=1,450 loops=1)

  • Output: mdt_filter_2.lobjid
42. 230.550 230.550 ↓ 0.0 0 1,450

Index Scan using ix_approvalinfo_appinfo on dalimes.approvalinfo appinf (cost=0.42..35.35 rows=1 width=8) (actual time=0.159..0.159 rows=0 loops=1,450)

  • Output: appinf.exestep_id, appinf.wflinst_id, appinf.lobj_id, appinf.otpl_id, appinf.prodgrp_id, appinf.approved, appinf.app_info
  • Index Cond: ((appinf.lobj_id = mdt_filter_2.lobjid) AND (appinf.approved = 0))
  • Filter: ((appinf.otpl_id = '53'::bigint) AND ((appinf.app_info)::text = ANY ('{U:admin,"G:Splashlight IT","G:PPI Apparel","G:CIS Marketing","G:Eileen Fisher","G:Splashlight Applications","G:Splashlight Retouching",G:Target,"G:Dia and Co","G:Splashlight Creative","G:Under Armour","G:My Customer","G:Splashlight Handbooks","G:Centric Brands","G:Main Organization","G:Globo Marketing",G:Macys,G:Bloomingdales,"G:El Palacio de Hierro","G:ALDO Marketing",G:Splashlight,"G:Production Lane","G:Avery Dennison",G:Amsale,"G:David Yurman",G:MCM,"G:Lana Jewelry",G:Giggle,"G:ALDO Group","G:J Crew","G:Ann Taylor"}'::text[])) AND (NOT (SubPlan 4)))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=5685 read=165
  • I/O Timings: read=210.815
43.          

SubPlan (forIndex Scan)

44. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_approvalinfo_approved_info on dalimes.approvalinfo (cost=0.42..6.20 rows=1 width=8) (never executed)

  • Output: approvalinfo.lobj_id
  • Index Cond: ((approvalinfo.approved = 1) AND ((approvalinfo.app_info)::text = 'U:admin'::text) AND (approvalinfo.otpl_id = '53'::bigint))
  • Filter: (approvalinfo.exestep_id = appinf.exestep_id)
45. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_2 (cost=0.43..4.45 rows=1 width=16) (never executed)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Index Cond: (pageorderparent_2.object_id = appinf.lobj_id)
  • Heap Fetches: 0
46. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_o_folder_id on dalimes.o_folder f_1 (cost=0.28..5.03 rows=1 width=8) (never executed)

  • 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 3))
47.          

SubPlan (forIndex Scan)

48. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=4.71..4.72 rows=1 width=8) (never executed)

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

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_3 (cost=0.42..4.71 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,35,6212,7743,6890,333,4583,6438,4310,4308,4306,5058,3590,3624,6441,4234,7969,3561,4890,3586,3596,5482,444,3610,4706,3616,4820,5659,6254,4312,3620,4314}'::bigint[]))
  • Heap Fetches: 0
50. 0.001 11.493 ↓ 0.0 0 1

Nested Loop Semi Join (cost=36.51..40.83 rows=1 width=8) (actual time=11.493..11.493 rows=0 loops=1)

  • Output: pageorderparent_3.object_id
  • Buffers: shared hit=5850
51. 0.000 11.492 ↓ 0.0 0 1

Nested Loop (cost=35.81..39.86 rows=1 width=16) (actual time=11.492..11.492 rows=0 loops=1)

  • Output: pageorderparent_3.object_id, pageorderparent_3.parent_id
  • Buffers: shared hit=5850
52. 0.003 11.492 ↓ 0.0 0 1

HashAggregate (cost=35.38..35.39 rows=1 width=8) (actual time=11.492..11.492 rows=0 loops=1)

  • Output: appinf_1.lobj_id
  • Group Key: appinf_1.lobj_id
  • Buffers: shared hit=5850
53. 0.958 11.489 ↓ 0.0 0 1

Nested Loop (cost=0.42..35.38 rows=1 width=8) (actual time=11.489..11.489 rows=0 loops=1)

  • Output: appinf_1.lobj_id
  • Buffers: shared hit=5850
54. 0.381 0.381 ↓ 1,450.0 1,450 1

CTE Scan on mdt_filter mdt_filter_3 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.381 rows=1,450 loops=1)

  • Output: mdt_filter_3.lobjid
55. 10.150 10.150 ↓ 0.0 0 1,450

Index Scan using ix_approvalinfo_appinfo on dalimes.approvalinfo appinf_1 (cost=0.42..35.35 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1,450)

  • Output: appinf_1.exestep_id, appinf_1.wflinst_id, appinf_1.lobj_id, appinf_1.otpl_id, appinf_1.prodgrp_id, appinf_1.approved, appinf_1.app_info
  • Index Cond: ((appinf_1.lobj_id = mdt_filter_3.lobjid) AND (appinf_1.approved = 0))
  • Filter: ((appinf_1.otpl_id = '53'::bigint) AND ((appinf_1.app_info)::text = ANY ('{U:admin,"G:Splashlight IT","G:PPI Apparel","G:CIS Marketing","G:Eileen Fisher","G:Splashlight Applications","G:Splashlight Retouching",G:Target,"G:Dia and Co","G:Splashlight Creative","G:Under Armour","G:My Customer","G:Splashlight Handbooks","G:Centric Brands","G:Main Organization","G:Globo Marketing",G:Macys,G:Bloomingdales,"G:El Palacio de Hierro","G:ALDO Marketing",G:Splashlight,"G:Production Lane","G:Avery Dennison",G:Amsale,"G:David Yurman",G:MCM,"G:Lana Jewelry",G:Giggle,"G:ALDO Group","G:J Crew","G:Ann Taylor"}'::text[])) AND (NOT (SubPlan 5)))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=5850
56.          

SubPlan (forIndex Scan)

57. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_approvalinfo_approved_info on dalimes.approvalinfo approvalinfo_1 (cost=0.42..6.20 rows=1 width=8) (never executed)

  • Output: approvalinfo_1.lobj_id
  • Index Cond: ((approvalinfo_1.approved = 1) AND ((approvalinfo_1.app_info)::text = 'U:admin'::text) AND (approvalinfo_1.otpl_id = '53'::bigint))
  • Filter: (approvalinfo_1.exestep_id = appinf_1.exestep_id)
58. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop Semi Join (cost=0.70..0.96 rows=1 width=16) (never executed)

  • Output: o_job_1.lobj_id, objectaccess_1.object_id
60. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixu_o_job_id on dalimes.o_job o_job_1 (cost=0.29..0.31 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
61. 0.000 0.000 ↓ 0.0 0

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

  • Output: objectaccess_1.object_id, objectaccess_1.entry_id, objectaccess_1.depth
  • Index Cond: (objectaccess_1.object_id = o_job_1.lobj_id)
  • Filter: (objectaccess_1.entry_id = ANY ('{-1,35,6212,7743,6890,333,4583,6438,4310,4308,4306,5058,3590,3624,6441,4234,7969,3561,4890,3586,3596,5482,444,3610,4706,3616,4820,5659,6254,4312,3620,4314}'::bigint[]))
  • Heap Fetches: 0