explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WeMM

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 185,184.360 ↓ 0.0 0 1

Unique (cost=29,015.66..29,015.70 rows=2 width=8) (actual time=185,184.360..185,184.360 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=10147213 read=682530
  • I/O Timings: read=161445.781
2. 0.003 185,184.358 ↓ 0.0 0 1

Merge Semi Join (cost=29,015.66..29,015.70 rows=2 width=8) (actual time=185,184.358..185,184.358 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Merge Cond: (pageorderparent.object_id = pageorderparent_2.object_id)
  • Buffers: shared hit=10147213 read=682530
  • I/O Timings: read=161445.781
3. 0.938 2,201.507 ↑ 2.0 1 1

Sort (cost=62.24..62.25 rows=2 width=8) (actual time=2,201.507..2,201.507 rows=1 loops=1)

  • Output: pageorderparent.object_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 116kB
  • Buffers: shared hit=131629 read=3784
  • I/O Timings: read=1944.279
4. 0.348 2,200.569 ↓ 725.0 1,450 1

Append (cost=21.92..62.23 rows=2 width=8) (actual time=1,979.465..2,200.569 rows=1,450 loops=1)

  • Buffers: shared hit=131629 read=3784
  • I/O Timings: read=1944.279
5. 0.871 2,108.150 ↓ 796.0 796 1

Nested Loop Semi Join (cost=21.92..35.46 rows=1 width=8) (actual time=1,979.464..2,108.150 rows=796 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=64537 read=3780
  • I/O Timings: read=1916.138
6. 1.605 2,066.679 ↓ 1,450.0 1,450 1

Nested Loop (cost=21.64..25.69 rows=1 width=16) (actual time=1,918.778..2,066.679 rows=1,450 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Buffers: shared hit=58458 read=3774
  • I/O Timings: read=1886.269
7. 3.697 1,901.224 ↓ 1,450.0 1,450 1

HashAggregate (cost=21.21..21.22 rows=1 width=8) (actual time=1,900.560..1,901.224 rows=1,450 loops=1)

  • Output: l0.lobj_id
  • Group Key: l0.lobj_id
  • Buffers: shared hit=54194 read=3679
  • I/O Timings: read=1726.618
8. 7.613 1,897.527 ↓ 1,450.0 1,450 1

Nested Loop (cost=2.40..21.21 rows=1 width=8) (actual time=125.137..1,897.527 rows=1,450 loops=1)

  • Output: l0.lobj_id
  • Buffers: shared hit=54194 read=3679
  • I/O Timings: read=1726.618
9. 6.372 275.714 ↓ 5,765.0 5,765 1

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

  • Output: l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=28848 read=125
  • I/O Timings: read=192.767
10. 9.035 228.987 ↓ 5,765.0 5,765 1

Nested Loop (cost=1.55..13.10 rows=1 width=32) (actual time=93.024..228.987 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=175.944
11. 2.796 133.477 ↓ 5,765.0 5,765 1

Nested Loop (cost=1.12..10.59 rows=1 width=24) (actual time=83.720..133.477 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=125.976
12. 0.020 39.697 ↓ 12.0 12 1

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

  • Output: ln2.childlobj_id
  • Buffers: shared hit=4 read=4
  • I/O Timings: read=39.548
13. 0.031 0.031 ↑ 1.0 1 1

Seq Scan on dalimes.o_customer p2 (cost=0.00..1.41 rows=1 width=8) (actual time=0.012..0.031 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
14. 39.646 39.646 ↓ 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=39.618..39.646 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=39.548
15. 90.984 90.984 ↓ 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=6.064..7.582 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=86.428
16. 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=49.968
17. 40.355 40.355 ↑ 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.007..0.007 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=16.823
18. 1,614.200 1,614.200 ↓ 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.280..0.280 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=1533.851
19. 163.850 163.850 ↑ 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.113..0.113 rows=1 loops=1,450)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = l0.lobj_id)
  • Heap Fetches: 0
  • Buffers: shared hit=4264 read=95
  • I/O Timings: read=159.651
20. 23.088 40.600 ↑ 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.028..0.028 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 1))
  • Buffers: shared hit=6079 read=6
  • I/O Timings: read=29.869
21.          

SubPlan (forIndex Scan)

22. 2.388 17.512 ↑ 1.0 1 796

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

  • Output: count(DISTINCT objectaccess_2.depth)
  • Buffers: shared hit=2387 read=2
  • I/O Timings: read=11.278
23. 15.124 15.124 ↑ 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.016..0.019 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.278
24. 1.509 92.071 ↓ 654.0 654 1

Nested Loop Semi Join (cost=22.34..26.75 rows=1 width=8) (actual time=57.466..92.071 rows=654 loops=1)

  • Output: pageorderparent_1.object_id
  • Buffers: shared hit=67092 read=4
  • I/O Timings: read=28.141
25. 0.836 55.762 ↓ 1,450.0 1,450 1

Nested Loop (cost=21.64..25.69 rows=1 width=16) (actual time=48.491..55.762 rows=1,450 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Buffers: shared hit=62232
26. 1.159 49.126 ↓ 1,450.0 1,450 1

HashAggregate (cost=21.21..21.22 rows=1 width=8) (actual time=48.482..49.126 rows=1,450 loops=1)

  • Output: l0_1.lobj_id
  • Group Key: l0_1.lobj_id
  • Buffers: shared hit=57873
27. 2.437 47.967 ↓ 1,450.0 1,450 1

Nested Loop (cost=2.40..21.21 rows=1 width=8) (actual time=0.122..47.967 rows=1,450 loops=1)

  • Output: l0_1.lobj_id
  • Buffers: shared hit=57873
28. 2.711 22.470 ↓ 5,765.0 5,765 1

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

  • Output: l0_1.lobj_id, ln1_1.childlobj_id
  • Buffers: shared hit=28973
29. 0.361 13.994 ↓ 5,765.0 5,765 1

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

  • Output: l0_1.lobj_id, ln1_1.parentlobj_id, ln1_1.childlobj_id, ln2_1.childlobj_id
  • Buffers: shared hit=17442
30. 0.812 2.103 ↓ 5,765.0 5,765 1

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

  • Output: ln1_1.parentlobj_id, ln1_1.childlobj_id, ln2_1.childlobj_id
  • Buffers: shared hit=106
31. 0.013 0.055 ↓ 12.0 12 1

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

  • Output: ln2_1.childlobj_id
  • Buffers: shared hit=8
32. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on dalimes.o_customer p2_1 (cost=0.00..1.41 rows=1 width=8) (actual time=0.014..0.021 rows=1 loops=1)

  • 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 = 'Lana Jewelry'::text))
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1
33. 0.021 0.021 ↓ 12.0 12 1

Index Only Scan using pk_objectlink on dalimes.objectlink ln2_1 (cost=0.56..4.58 rows=1 width=16) (actual time=0.014..0.021 rows=12 loops=1)

  • 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 = 8) AND (ln2_1.parentlobj_id = p2_1.lobj_id) AND (ln2_1.ts_deletion = 0) AND (ln2_1.childotpl_id = 35))
  • Heap Fetches: 0
  • Buffers: shared hit=7
34. 1.236 1.236 ↓ 480.0 480 12

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

  • 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 = 35) AND (ln1_1.parentlobj_id = ln2_1.childlobj_id) AND (ln1_1.ts_deletion = 0) AND (ln1_1.childotpl_id = 53))
  • Heap Fetches: 0
  • Buffers: shared hit=98
35. 11.530 11.530 ↑ 1.0 1 5,765

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

  • 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
  • Buffers: shared hit=17336
36. 5.765 5.765 ↑ 1.0 1 5,765

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

  • 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
  • Buffers: shared hit=11531
37. 23.060 23.060 ↓ 0.0 0 5,765

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

  • 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 = 'Comp_Layer'::text) AND (mtd0_1.ns_id = 101))
  • Filter: ((mtd0_1.data_value)::text = '0'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=28900
38. 5.800 5.800 ↑ 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.004 rows=1 loops=1,450)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = l0_1.lobj_id)
  • Heap Fetches: 0
  • Buffers: shared hit=4359
39. 0.366 34.800 ↓ 0.0 0 1,450

Nested Loop (cost=0.70..1.05 rows=2 width=16) (actual time=0.024..0.024 rows=0 loops=1,450)

  • Output: objectaccess.object_id, o_job.lobj_id
  • Join Filter: (objectaccess.object_id = o_job.lobj_id)
  • Buffers: shared hit=4860 read=4
  • I/O Timings: read=28.141
40. 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
41. 30.084 30.084 ↑ 3.0 1 654

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

  • Output: objectaccess.object_id, objectaccess.entry_id, objectaccess.depth
  • Index Cond: (objectaccess.object_id = pageorderparent_1.parent_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=1959 read=4
  • I/O Timings: read=28.141
42. 0.024 182,982.848 ↓ 0.0 0 1

Sort (cost=28,953.42..28,953.42 rows=2 width=8) (actual time=182,982.848..182,982.848 rows=0 loops=1)

  • Output: pageorderparent_2.object_id
  • Sort Key: pageorderparent_2.object_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10015584 read=678746
  • I/O Timings: read=159501.502
43. 0.002 182,982.824 ↓ 0.0 0 1

Append (cost=14,467.51..28,953.41 rows=2 width=8) (actual time=182,982.824..182,982.824 rows=0 loops=1)

  • Buffers: shared hit=10015584 read=678746
  • I/O Timings: read=159501.502
44. 0.001 99,087.912 ↓ 0.0 0 1

Nested Loop Semi Join (cost=14,467.51..14,481.05 rows=1 width=8) (actual time=99,087.912..99,087.912 rows=0 loops=1)

  • Output: pageorderparent_2.object_id
  • Buffers: shared hit=5008965 read=338200
  • I/O Timings: read=87231.051
45. 0.002 99,087.911 ↓ 0.0 0 1

Nested Loop (cost=14,467.23..14,471.28 rows=1 width=16) (actual time=99,087.911..99,087.911 rows=0 loops=1)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Buffers: shared hit=5008965 read=338200
  • I/O Timings: read=87231.051
46. 0.003 99,087.909 ↓ 0.0 0 1

HashAggregate (cost=14,466.80..14,466.81 rows=1 width=8) (actual time=99,087.909..99,087.909 rows=0 loops=1)

  • Output: appinf.lobj_id
  • Group Key: appinf.lobj_id
  • Buffers: shared hit=5008965 read=338200
  • I/O Timings: read=87231.051
47. 288.486 99,087.906 ↓ 0.0 0 1

Nested Loop (cost=57.23..14,466.80 rows=1 width=8) (actual time=99,087.906..99,087.906 rows=0 loops=1)

  • Output: appinf.lobj_id
  • Buffers: shared hit=5008965 read=338200
  • I/O Timings: read=87231.051
48. 606.955 97,162.603 ↓ 233,831.0 233,831 1

Nested Loop (cost=56.81..14,441.97 rows=1 width=24) (actual time=26.117..97,162.603 rows=233,831 loops=1)

  • Output: l0_2.lobj_id, ln1_2.childlobj_id, mtd0_2.lobj_id
  • Buffers: shared hit=4286400 read=336279
  • I/O Timings: read=86809.594
49. 374.582 5,196.474 ↓ 26,117.5 574,586 1

Nested Loop (cost=56.24..14,321.59 rows=22 width=16) (actual time=14.046..5,196.474 rows=574,586 loops=1)

  • Output: l0_2.lobj_id, ln1_2.childlobj_id
  • Buffers: shared hit=1738908 read=8360
  • I/O Timings: read=1394.430
50. 209.935 1,374.376 ↓ 3,440.6 574,586 1

Nested Loop (cost=55.81..13,956.84 rows=167 width=8) (actual time=3.707..1,374.376 rows=574,586 loops=1)

  • Output: ln1_2.childlobj_id
  • Buffers: shared hit=13388 read=5673
  • I/O Timings: read=813.596
51. 58.142 60.717 ↑ 1.0 2,852 1

Bitmap Heap Scan on dalimes.o_job p1_2 (cost=55.25..963.90 rows=2,852 width=8) (actual time=3.641..60.717 rows=2,852 loops=1)

  • Output: p1_2.outerpage_scalingvalue, p1_2.new_useissuescaling, p1_2.new_routingmargins, p1_2.lobj_isroot, p1_2.blocksize_back, p1_2.lobj_id, p1_2.new_defaultoffsety, p1_2.new_pageorderworkflow, p1_2.segmenttrim_overfold, p1_2.new_defaultrotation, p1_2.new_publicationdate, p1_2.new_defaultoffsetx, p1_2.new_collatingmarksposition, p1_2.new_simulation, p1_2.new_shrinkouterribon, p1_2.new_jobworkflow, p1_2.new_inhousepostprocessing, p1_2.syshierarchy, p1_2.printedtrim_footer, p1_2.parent_node_id, p1_2.outerpage_creepvalue, p1_2.segmenttrim_outer, p1_2.lobj_name, p1_2.segmenttrim_routingmargins, p1_2.new_folding, p1_2.new_lockshortname, p1_2.new_priority, p1_2.maximalscaling_use, p1_2.maximalscaling_value, p1_2.new_reversedview, p1_2.new_trimmedwidth, p1_2.new_safetylr, p1_2.ostt_list, p1_2.lobj_version, p1_2.new_exportasrss, p1_2.new_formworkflow, p1_2.new_rolemasks, p1_2.nw_denyupdateofpublicationda, p1_2.new_trimmedheight, p1_2.ts_deletion, p1_2.new_shiftmark, p1_2.new_site, p1_2.new_iccname, p1_2.maximalscaling_steps, p1_2.ts_creation, p1_2.printedtrim_head, p1_2.printedtrim_face, p1_2.new_skalingmethod, p1_2.outerpage_scalingstartvalue, p1_2.segmenttrim_gutter, p1_2.new_bleedleftandright, p1_2.new_usesectionscaling, p1_2.new_pagecuttoff, p1_2.ts_lastchange, p1_2.commentulong, p1_2.new_usenbpageforskaling, p1_2.creationuser_code, p1_2.new_safetytb, p1_2.new_creepingreference, p1_2.new_applycreeping, p1_2.new_compensatebracketeffect, p1_2.segmenttrim_millingdepth, p1_2.blocksize_front, p1_2.segmenttrim_footer, p1_2.new_bleedtopandbottom, p1_2.new_uselinearissuescaling, p1_2.innerpage_scalingvalue, p1_2.maximalscaling_stepsperform, p1_2.innerpage_creepvalue, p1_2.commentushort, p1_2.new_reelpostprocessing, p1_2.node_id, p1_2.new_uselinearsectionscaling, p1_2.new_mainpageorder, p1_2.ostt_value, p1_2.lastchangeuser_code, p1_2.segmenttrim_head
  • Recheck Cond: ((p1_2.ts_deletion = 0) AND (p1_2.new_publicationdate IS NULL))
  • Heap Blocks: exact=514
  • Buffers: shared hit=1 read=522
  • I/O Timings: read=37.407
52. 2.575 2.575 ↑ 1.0 2,852 1

Bitmap Index Scan on ix_o_job_topublish (cost=0.00..54.54 rows=2,852 width=0) (actual time=2.575..2.575 rows=2,852 loops=1)

  • Buffers: shared read=9
  • I/O Timings: read=1.896
53. 1,103.724 1,103.724 ↓ 201.0 201 2,852

Index Only Scan using pk_objectlink on dalimes.objectlink ln1_2 (cost=0.56..4.55 rows=1 width=16) (actual time=0.138..0.387 rows=201 loops=2,852)

  • Output: ln1_2.parentotpl_id, ln1_2.parentlobj_id, ln1_2.ts_deletion, ln1_2.childotpl_id, ln1_2.childlobj_id, ln1_2.olnk_id
  • Index Cond: ((ln1_2.parentotpl_id = 35) AND (ln1_2.parentlobj_id = p1_2.lobj_id) AND (ln1_2.ts_deletion = 0) AND (ln1_2.childotpl_id = 53))
  • Heap Fetches: 0
  • Buffers: shared hit=13387 read=5151
  • I/O Timings: read=776.189
54. 3,447.516 3,447.516 ↑ 1.0 1 574,586

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0_2 (cost=0.43..2.17 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=574,586)

  • Output: l0_2.ts_deletion, l0_2.lobj_id
  • Index Cond: ((l0_2.ts_deletion = 0) AND (l0_2.lobj_id = ln1_2.childlobj_id))
  • Heap Fetches: 0
  • Buffers: shared hit=1725520 read=2687
  • I/O Timings: read=580.834
55. 91,359.174 91,359.174 ↓ 0.0 0 574,586

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_2 (cost=0.56..5.46 rows=1 width=8) (actual time=0.159..0.159 rows=0 loops=574,586)

  • 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 = l0_2.lobj_id) AND ((mtd0_2.data_key)::text = 'selection'::text) AND (mtd0_2.ns_id = 46))
  • Filter: ((mtd0_2.data_value)::text = '1'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2547492 read=327919
  • I/O Timings: read=85415.164
56. 1,636.817 1,636.817 ↓ 0.0 0 233,831

Index Scan using ix_approvalinfo_appinfo on dalimes.approvalinfo appinf (cost=0.42..24.81 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=233,831)

  • 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 = l0_2.lobj_id) 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 3)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=722565 read=1921
  • I/O Timings: read=421.457
57.          

SubPlan (forIndex Scan)

58. 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)
59. 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
60. 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 2))
61.          

SubPlan (forIndex Scan)

62. 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)
63. 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
64. 0.002 83,894.910 ↓ 0.0 0 1

Nested Loop Semi Join (cost=14,467.93..14,472.34 rows=1 width=8) (actual time=83,894.910..83,894.910 rows=0 loops=1)

  • Output: pageorderparent_3.object_id
  • Buffers: shared hit=5006619 read=340546
  • I/O Timings: read=72270.451
65. 0.000 83,894.908 ↓ 0.0 0 1

Nested Loop (cost=14,467.23..14,471.28 rows=1 width=16) (actual time=83,894.908..83,894.908 rows=0 loops=1)

  • Output: pageorderparent_3.object_id, pageorderparent_3.parent_id
  • Buffers: shared hit=5006619 read=340546
  • I/O Timings: read=72270.451
66. 0.005 83,894.908 ↓ 0.0 0 1

HashAggregate (cost=14,466.80..14,466.81 rows=1 width=8) (actual time=83,894.908..83,894.908 rows=0 loops=1)

  • Output: appinf_1.lobj_id
  • Group Key: appinf_1.lobj_id
  • Buffers: shared hit=5006619 read=340546
  • I/O Timings: read=72270.451
67. 113.028 83,894.903 ↓ 0.0 0 1

Nested Loop (cost=57.23..14,466.80 rows=1 width=8) (actual time=83,894.903..83,894.903 rows=0 loops=1)

  • Output: appinf_1.lobj_id
  • Buffers: shared hit=5006619 read=340546
  • I/O Timings: read=72270.451
68. 515.238 81,677.396 ↓ 233,831.0 233,831 1

Nested Loop (cost=56.81..14,441.97 rows=1 width=24) (actual time=137.541..81,677.396 rows=233,831 loops=1)

  • Output: l0_3.lobj_id, ln1_3.childlobj_id, mtd0_3.lobj_id
  • Buffers: shared hit=4284045 read=338634
  • I/O Timings: read=71505.652
69. 402.246 5,316.806 ↓ 26,117.5 574,586 1

Nested Loop (cost=56.24..14,321.59 rows=22 width=16) (actual time=101.289..5,316.806 rows=574,586 loops=1)

  • Output: l0_3.lobj_id, ln1_3.childlobj_id
  • Buffers: shared hit=1738810 read=8458
  • I/O Timings: read=1567.180
70. 204.112 1,467.044 ↓ 3,440.6 574,586 1

Nested Loop (cost=55.81..13,956.84 rows=167 width=8) (actual time=84.284..1,467.044 rows=574,586 loops=1)

  • Output: ln1_3.childlobj_id
  • Buffers: shared hit=13346 read=5715
  • I/O Timings: read=915.859
71. 86.200 93.612 ↑ 1.0 2,852 1

Bitmap Heap Scan on dalimes.o_job p1_3 (cost=55.25..963.90 rows=2,852 width=8) (actual time=15.276..93.612 rows=2,852 loops=1)

  • Output: p1_3.outerpage_scalingvalue, p1_3.new_useissuescaling, p1_3.new_routingmargins, p1_3.lobj_isroot, p1_3.blocksize_back, p1_3.lobj_id, p1_3.new_defaultoffsety, p1_3.new_pageorderworkflow, p1_3.segmenttrim_overfold, p1_3.new_defaultrotation, p1_3.new_publicationdate, p1_3.new_defaultoffsetx, p1_3.new_collatingmarksposition, p1_3.new_simulation, p1_3.new_shrinkouterribon, p1_3.new_jobworkflow, p1_3.new_inhousepostprocessing, p1_3.syshierarchy, p1_3.printedtrim_footer, p1_3.parent_node_id, p1_3.outerpage_creepvalue, p1_3.segmenttrim_outer, p1_3.lobj_name, p1_3.segmenttrim_routingmargins, p1_3.new_folding, p1_3.new_lockshortname, p1_3.new_priority, p1_3.maximalscaling_use, p1_3.maximalscaling_value, p1_3.new_reversedview, p1_3.new_trimmedwidth, p1_3.new_safetylr, p1_3.ostt_list, p1_3.lobj_version, p1_3.new_exportasrss, p1_3.new_formworkflow, p1_3.new_rolemasks, p1_3.nw_denyupdateofpublicationda, p1_3.new_trimmedheight, p1_3.ts_deletion, p1_3.new_shiftmark, p1_3.new_site, p1_3.new_iccname, p1_3.maximalscaling_steps, p1_3.ts_creation, p1_3.printedtrim_head, p1_3.printedtrim_face, p1_3.new_skalingmethod, p1_3.outerpage_scalingstartvalue, p1_3.segmenttrim_gutter, p1_3.new_bleedleftandright, p1_3.new_usesectionscaling, p1_3.new_pagecuttoff, p1_3.ts_lastchange, p1_3.commentulong, p1_3.new_usenbpageforskaling, p1_3.creationuser_code, p1_3.new_safetytb, p1_3.new_creepingreference, p1_3.new_applycreeping, p1_3.new_compensatebracketeffect, p1_3.segmenttrim_millingdepth, p1_3.blocksize_front, p1_3.segmenttrim_footer, p1_3.new_bleedtopandbottom, p1_3.new_uselinearissuescaling, p1_3.innerpage_scalingvalue, p1_3.maximalscaling_stepsperform, p1_3.innerpage_creepvalue, p1_3.commentushort, p1_3.new_reelpostprocessing, p1_3.node_id, p1_3.new_uselinearsectionscaling, p1_3.new_mainpageorder, p1_3.ostt_value, p1_3.lastchangeuser_code, p1_3.segmenttrim_head
  • Recheck Cond: ((p1_3.ts_deletion = 0) AND (p1_3.new_publicationdate IS NULL))
  • Heap Blocks: exact=514
  • Buffers: shared hit=1 read=522
  • I/O Timings: read=70.270
72. 7.412 7.412 ↑ 1.0 2,852 1

Bitmap Index Scan on ix_o_job_topublish (cost=0.00..54.54 rows=2,852 width=0) (actual time=7.412..7.412 rows=2,852 loops=1)

  • Buffers: shared read=9
  • I/O Timings: read=6.640
73. 1,169.320 1,169.320 ↓ 201.0 201 2,852

Index Only Scan using pk_objectlink on dalimes.objectlink ln1_3 (cost=0.56..4.55 rows=1 width=16) (actual time=0.205..0.410 rows=201 loops=2,852)

  • Output: ln1_3.parentotpl_id, ln1_3.parentlobj_id, ln1_3.ts_deletion, ln1_3.childotpl_id, ln1_3.childlobj_id, ln1_3.olnk_id
  • Index Cond: ((ln1_3.parentotpl_id = 35) AND (ln1_3.parentlobj_id = p1_3.lobj_id) AND (ln1_3.ts_deletion = 0) AND (ln1_3.childotpl_id = 53))
  • Heap Fetches: 0
  • Buffers: shared hit=13345 read=5193
  • I/O Timings: read=845.589
74. 3,447.516 3,447.516 ↑ 1.0 1 574,586

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0_3 (cost=0.43..2.17 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=574,586)

  • Output: l0_3.ts_deletion, l0_3.lobj_id
  • Index Cond: ((l0_3.ts_deletion = 0) AND (l0_3.lobj_id = ln1_3.childlobj_id))
  • Heap Fetches: 0
  • Buffers: shared hit=1725464 read=2743
  • I/O Timings: read=651.321
75. 75,845.352 75,845.352 ↓ 0.0 0 574,586

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_3 (cost=0.56..5.46 rows=1 width=8) (actual time=0.132..0.132 rows=0 loops=574,586)

  • 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 = l0_3.lobj_id) AND ((mtd0_3.data_key)::text = 'selection'::text) AND (mtd0_3.ns_id = 46))
  • Filter: ((mtd0_3.data_value)::text = '1'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2545235 read=330176
  • I/O Timings: read=69938.472
76. 2,104.479 2,104.479 ↓ 0.0 0 233,831

Index Scan using ix_approvalinfo_appinfo on dalimes.approvalinfo appinf_1 (cost=0.42..24.81 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=233,831)

  • 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 = l0_3.lobj_id) 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 4)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=722574 read=1912
  • I/O Timings: read=764.799
77.          

SubPlan (forIndex Scan)

78. 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)
79. 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
80. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..1.05 rows=2 width=16) (never executed)

  • Output: objectaccess_1.object_id, o_job_1.lobj_id
  • Join Filter: (objectaccess_1.object_id = o_job_1.lobj_id)
81. 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
82. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_1 (cost=0.42..0.71 rows=3 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,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