explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gUIM

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 14,688.675 ↓ 0.0 0 1

Unique (cost=176.99..177.03 rows=2 width=8) (actual time=14,688.675..14,688.675 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=4772001 read=49897
  • I/O Timings: read=10085.485
2. 0.007 14,688.674 ↓ 0.0 0 1

Merge Semi Join (cost=176.99..177.03 rows=2 width=8) (actual time=14,688.674..14,688.674 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Merge Cond: (pageorderparent.object_id = pageorderparent_2.object_id)
  • Buffers: shared hit=4772001 read=49897
  • I/O Timings: read=10085.485
3. 47.070 14,688.614 ↑ 2.0 1 1

Sort (cost=75.67..75.67 rows=2 width=8) (actual time=14,688.614..14,688.614 rows=1 loops=1)

  • Output: pageorderparent.object_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 12967kB
  • Buffers: shared hit=4771996 read=49896
  • I/O Timings: read=10085.461
4. 15.285 14,641.544 ↓ 72,773.5 145,547 1

Append (cost=21.51..75.66 rows=2 width=8) (actual time=13,392.245..14,641.544 rows=145,547 loops=1)

  • Buffers: shared hit=4771996 read=49896
  • I/O Timings: read=10085.461
5. 94.378 12,537.968 ↓ 0.0 0 1

Nested Loop Semi Join (cost=21.51..53.46 rows=1 width=8) (actual time=12,537.968..12,537.968 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=1992762 read=48469
  • I/O Timings: read=9873.170
6. 90.460 12,298.043 ↓ 145,547.0 145,547 1

Nested Loop (cost=21.22..21.30 rows=1 width=16) (actual time=10,559.361..12,298.043 rows=145,547 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Buffers: shared hit=1701673 read=48464
  • I/O Timings: read=9862.411
7. 222.134 10,606.566 ↓ 145,547.0 145,547 1

HashAggregate (cost=20.79..20.80 rows=1 width=16) (actual time=10,544.982..10,606.566 rows=145,547 loops=1)

  • Output: l0.lobj_id, ln1.childlobj_id
  • Group Key: l0.lobj_id
  • Buffers: shared hit=1122522 read=44300
  • I/O Timings: read=8641.472
8. 179.260 10,384.432 ↓ 145,547.0 145,547 1

Nested Loop (cost=1.83..20.79 rows=1 width=16) (actual time=71.961..10,384.432 rows=145,547 loops=1)

  • Output: l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=1122522 read=44300
  • I/O Timings: read=8641.472
9. 178.852 9,622.984 ↓ 145,547.0 145,547 1

Nested Loop (cost=1.55..20.46 rows=1 width=32) (actual time=71.416..9,622.984 rows=145,547 loops=1)

  • Output: l0.lobj_id, ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=684733 read=44015
  • I/O Timings: read=8429.514
10. 46.819 5,514.363 ↓ 145,547.0 145,547 1

Nested Loop (cost=1.12..18.59 rows=1 width=24) (actual time=46.849..5,514.363 rows=145,547 loops=1)

  • Output: ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=118837 read=26581
  • I/O Timings: read=5200.742
11. 0.717 207.224 ↓ 1,405.0 1,405 1

Nested Loop (cost=0.56..10.00 rows=1 width=8) (actual time=28.658..207.224 rows=1,405 loops=1)

  • Output: ln2.childlobj_id
  • Buffers: shared hit=1112 read=252
  • I/O Timings: read=203.012
12. 0.039 0.039 ↑ 1.0 1 1

Seq Scan on dalimes.o_customer p2 (cost=0.00..1.41 rows=1 width=8) (actual time=0.023..0.039 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 = 'Under Armour'::text))
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1
13. 206.468 206.468 ↓ 1,405.0 1,405 1

Index Only Scan using pk_objectlink on dalimes.objectlink ln2 (cost=0.56..8.58 rows=1 width=16) (actual time=28.617..206.468 rows=1,405 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: 1405
  • Buffers: shared hit=1111 read=252
  • I/O Timings: read=203.012
14. 5,260.320 5,260.320 ↓ 104.0 104 1,405

Index Only Scan using pk_objectlink on dalimes.objectlink ln1 (cost=0.56..8.58 rows=1 width=16) (actual time=0.186..3.744 rows=104 loops=1,405)

  • 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: 145547
  • Buffers: shared hit=117725 read=26329
  • I/O Timings: read=4997.730
15. 3,929.769 3,929.769 ↑ 1.0 1 145,547

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0 (cost=0.43..1.85 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=145,547)

  • Output: l0.ts_deletion, l0.lobj_id
  • Index Cond: ((l0.ts_deletion = 0) AND (l0.lobj_id = ln1.childlobj_id))
  • Heap Fetches: 145547
  • Buffers: shared hit=565896 read=17434
  • I/O Timings: read=3228.772
16. 582.188 582.188 ↑ 1.0 1 145,547

Index Only Scan using ixu_o_job_id on dalimes.o_job p1 (cost=0.29..0.32 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=145,547)

  • 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: 145547
  • Buffers: shared hit=437789 read=285
  • I/O Timings: read=211.958
17. 1,601.017 1,601.017 ↑ 1.0 1 145,547

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent (cost=0.43..0.48 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=145,547)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = l0.lobj_id)
  • Heap Fetches: 145547
  • Buffers: shared hit=579151 read=4164
  • I/O Timings: read=1220.939
18. 145.547 145.547 ↓ 0.0 0 145,547

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

  • 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=291089 read=5
  • I/O Timings: read=10.759
19.          

SubPlan (forIndex Scan)

20. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=15.90..15.91 rows=1 width=8) (never executed)

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

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_2 (cost=0.42..15.90 rows=1 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,6406,4306,5483,3586,3596,5482,6587}'::bigint[]))
  • Heap Fetches: 0
22. 102.258 2,088.291 ↓ 145,547.0 145,547 1

Nested Loop Semi Join (cost=21.93..22.18 rows=1 width=8) (actual time=854.274..2,088.291 rows=145,547 loops=1)

  • Output: pageorderparent_1.object_id
  • Buffers: shared hit=2779234 read=1427
  • I/O Timings: read=212.291
23. 105.616 1,258.298 ↓ 145,547.0 145,547 1

Nested Loop (cost=21.22..21.30 rows=1 width=16) (actual time=804.421..1,258.298 rows=145,547 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Buffers: shared hit=1748911 read=1223
  • I/O Timings: read=6.432
24. 123.688 861.588 ↓ 145,547.0 145,547 1

HashAggregate (cost=20.79..20.80 rows=1 width=16) (actual time=804.403..861.588 rows=145,547 loops=1)

  • Output: l0_1.lobj_id, ln1_1.childlobj_id
  • Group Key: l0_1.lobj_id
  • Buffers: shared hit=1165596 read=1223
  • I/O Timings: read=6.432
25. 100.173 737.900 ↓ 145,547.0 145,547 1

Nested Loop (cost=1.83..20.79 rows=1 width=16) (actual time=0.105..737.900 rows=145,547 loops=1)

  • Output: l0_1.lobj_id, ln1_1.childlobj_id
  • Buffers: shared hit=1165596 read=1223
  • I/O Timings: read=6.432
26. 77.396 492.180 ↓ 145,547.0 145,547 1

Nested Loop (cost=1.55..20.46 rows=1 width=32) (actual time=0.096..492.180 rows=145,547 loops=1)

  • Output: l0_1.lobj_id, ln1_1.parentlobj_id, ln1_1.childlobj_id, ln2_1.childlobj_id
  • Buffers: shared hit=727523 read=1222
  • I/O Timings: read=6.424
27. 21.142 123.690 ↓ 145,547.0 145,547 1

Nested Loop (cost=1.12..18.59 rows=1 width=24) (actual time=0.084..123.690 rows=145,547 loops=1)

  • Output: ln1_1.parentlobj_id, ln1_1.childlobj_id, ln2_1.childlobj_id
  • Buffers: shared hit=144575 read=840
  • I/O Timings: read=4.396
28. 0.257 1.388 ↓ 1,405.0 1,405 1

Nested Loop (cost=0.56..10.00 rows=1 width=8) (actual time=0.064..1.388 rows=1,405 loops=1)

  • Output: ln2_1.childlobj_id
  • Buffers: shared hit=1351 read=10
  • I/O Timings: read=0.062
29. 0.022 0.022 ↑ 1.0 1 1

Seq Scan on dalimes.o_customer p2_1 (cost=0.00..1.41 rows=1 width=8) (actual time=0.015..0.022 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 = 'Under Armour'::text))
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1
30. 1.109 1.109 ↓ 1,405.0 1,405 1

Index Only Scan using pk_objectlink on dalimes.objectlink ln2_1 (cost=0.56..8.58 rows=1 width=16) (actual time=0.040..1.109 rows=1,405 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: 1405
  • Buffers: shared hit=1350 read=10
  • I/O Timings: read=0.062
31. 101.160 101.160 ↓ 104.0 104 1,405

Index Only Scan using pk_objectlink on dalimes.objectlink ln1_1 (cost=0.56..8.58 rows=1 width=16) (actual time=0.005..0.072 rows=104 loops=1,405)

  • 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: 145547
  • Buffers: shared hit=143224 read=830
  • I/O Timings: read=4.334
32. 291.094 291.094 ↑ 1.0 1 145,547

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

  • 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: 145547
  • Buffers: shared hit=582948 read=382
  • I/O Timings: read=2.028
33. 145.547 145.547 ↑ 1.0 1 145,547

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

  • 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: 145547
  • Buffers: shared hit=438073 read=1
  • I/O Timings: read=0.008
34. 291.094 291.094 ↑ 1.0 1 145,547

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_1 (cost=0.43..0.48 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=145,547)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = l0_1.lobj_id)
  • Heap Fetches: 145547
  • Buffers: shared hit=583315
35. 145.547 727.735 ↑ 1.0 1 145,547

Nested Loop Semi Join (cost=0.70..0.87 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=145,547)

  • Output: o_job.lobj_id, objectaccess.object_id
  • Join Filter: (o_job.lobj_id = objectaccess.object_id)
  • Buffers: shared hit=1030323 read=204
  • I/O Timings: read=205.859
36. 145.547 145.547 ↑ 1.0 1 145,547

Index Only Scan using ixu_o_job_id on dalimes.o_job (cost=0.29..0.31 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=145,547)

  • 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: 145547
  • Buffers: shared hit=437270
37. 436.641 436.641 ↑ 1.0 1 145,547

Index Only Scan using pk_objectaccess on dalimes.objectaccess (cost=0.42..0.56 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=145,547)

  • Output: objectaccess.object_id, objectaccess.entry_id, objectaccess.depth
  • Index Cond: (objectaccess.object_id = pageorderparent_1.parent_id)
  • Filter: (objectaccess.entry_id = ANY ('{-1,6406,4306,5483,3586,3596,5482,6587}'::bigint[]))
  • Rows Removed by Filter: 2
  • Heap Fetches: 436641
  • Buffers: shared hit=593053 read=204
  • I/O Timings: read=205.859
38. 0.011 0.053 ↓ 0.0 0 1

Sort (cost=101.32..101.33 rows=2 width=8) (actual time=0.053..0.053 rows=0 loops=1)

  • Output: pageorderparent_2.object_id
  • Sort Key: pageorderparent_2.object_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5 read=1
  • I/O Timings: read=0.024
39. 0.000 0.042 ↓ 0.0 0 1

Append (cost=2.27..101.31 rows=2 width=8) (actual time=0.042..0.042 rows=0 loops=1)

  • Buffers: shared hit=5 read=1
  • I/O Timings: read=0.024
40. 0.000 0.037 ↓ 0.0 0 1

Nested Loop Semi Join (cost=2.27..66.28 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1)

  • Output: pageorderparent_2.object_id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.024
41. 0.001 0.037 ↓ 0.0 0 1

Nested Loop (cost=1.99..34.13 rows=1 width=16) (actual time=0.037..0.037 rows=0 loops=1)

  • Output: pageorderparent_2.object_id, pageorderparent_2.parent_id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.024
42. 0.000 0.036 ↓ 0.0 0 1

Unique (cost=1.56..25.66 rows=1 width=8) (actual time=0.036..0.036 rows=0 loops=1)

  • Output: l0_2.lobj_id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.024
43. 0.001 0.036 ↓ 0.0 0 1

Nested Loop (cost=1.56..25.66 rows=1 width=8) (actual time=0.036..0.036 rows=0 loops=1)

  • Output: l0_2.lobj_id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.024
44. 0.001 0.035 ↓ 0.0 0 1

Nested Loop (cost=0.99..17.05 rows=1 width=16) (actual time=0.035..0.035 rows=0 loops=1)

  • Output: l0_2.lobj_id, mtd0.lobj_id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.024
45. 0.034 0.034 ↓ 0.0 0 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.034..0.034 rows=0 loops=1)

  • Output: l0_2.ts_deletion, l0_2.lobj_id
  • Index Cond: ((l0_2.ts_deletion = 0) AND (l0_2.lobj_id = '20963691'::bigint))
  • Heap Fetches: 0
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.024
46. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0 (cost=0.56..8.59 rows=1 width=8) (never executed)

  • 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 = '20963691'::bigint) AND ((mtd0.data_key)::text = 'assignee'::text) AND (mtd0.ns_id = 38))
  • Filter: ((mtd0.data_value)::text = 'Samantha Seddon'::text)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_1 (cost=0.56..8.59 rows=1 width=8) (never executed)

  • 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 = '20963691'::bigint) AND ((mtd0_1.data_key)::text = 'selection'::text) AND (mtd0_1.ns_id = 46))
  • Filter: ((mtd0_1.data_value)::text = '1'::text)
48. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using ixu_o_folder_id on dalimes.o_folder f_1 (cost=0.28..16.22 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))
50.          

SubPlan (forIndex Scan)

51. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=15.90..15.91 rows=1 width=8) (never executed)

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

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_3 (cost=0.42..15.90 rows=1 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,6406,4306,5483,3586,3596,5482,6587}'::bigint[]))
  • Heap Fetches: 0
53. 0.001 0.005 ↓ 0.0 0 1

Nested Loop Semi Join (cost=2.69..35.01 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: pageorderparent_3.object_id
  • Buffers: shared hit=3
54. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=1.99..34.13 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: pageorderparent_3.object_id, pageorderparent_3.parent_id
  • Buffers: shared hit=3
55. 0.000 0.004 ↓ 0.0 0 1

Unique (cost=1.56..25.66 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: l0_3.lobj_id
  • Buffers: shared hit=3
56. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=1.56..25.66 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: l0_3.lobj_id
  • Buffers: shared hit=3
57. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.99..17.05 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: l0_3.lobj_id, mtd0_2.lobj_id
  • Buffers: shared hit=3
58. 0.002 0.002 ↓ 0.0 0 1

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

  • Output: l0_3.ts_deletion, l0_3.lobj_id
  • Index Cond: ((l0_3.ts_deletion = 0) AND (l0_3.lobj_id = '20963691'::bigint))
  • Heap Fetches: 0
  • Buffers: shared hit=3
59. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_2 (cost=0.56..8.59 rows=1 width=8) (never executed)

  • 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 = '20963691'::bigint) AND ((mtd0_2.data_key)::text = 'assignee'::text) AND (mtd0_2.ns_id = 38))
  • Filter: ((mtd0_2.data_value)::text = 'Samantha Seddon'::text)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mtd0_3 (cost=0.56..8.59 rows=1 width=8) (never executed)

  • 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 = '20963691'::bigint) AND ((mtd0_3.data_key)::text = 'selection'::text) AND (mtd0_3.ns_id = 46))
  • Filter: ((mtd0_3.data_value)::text = '1'::text)
61. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop Semi Join (cost=0.70..0.87 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)
63. 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
64. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_1 (cost=0.42..0.56 rows=1 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,6406,4306,5483,3586,3596,5482,6587}'::bigint[]))
  • Heap Fetches: 0