explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M1jC

Settings
# exclusive inclusive rows x rows loops node
1. 0.085 5,192.106 ↓ 347.0 347 1

Unique (cost=181,995.67..181,995.69 rows=1 width=58) (actual time=5,192.008..5,192.106 rows=347 loops=1)

  • Output: l0.lobj_name, (COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), p2.lobj_name, p1_1.commentushort, l0.lobj_id
  • Buffers: shared hit=212747 read=14410, temp read=22905 written=22990
  • I/O Timings: read=97.369
2. 1.802 5,192.021 ↓ 347.0 347 1

Sort (cost=181,995.67..181,995.67 rows=1 width=58) (actual time=5,192.008..5,192.021 rows=347 loops=1)

  • Output: l0.lobj_name, (COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), p2.lobj_name, p1_1.commentushort, l0.lobj_id
  • Sort Key: l0.lobj_name, (COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), p2.lobj_name, p1_1.commentushort, l0.lobj_id
  • Sort Method: quicksort Memory: 73kB
  • Buffers: shared hit=212747 read=14410, temp read=22905 written=22990
  • I/O Timings: read=97.369
3. 117.529 5,190.219 ↓ 347.0 347 1

Merge Semi Join (cost=74,069.61..181,995.66 rows=1 width=58) (actual time=5,165.019..5,190.219 rows=347 loops=1)

  • Output: l0.lobj_name, COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), p2.lobj_name, p1_1.commentushort, l0.lobj_id
  • Merge Cond: (l0.lobj_id = l0_1.lobj_id)
  • Buffers: shared hit=212744 read=14410, temp read=22905 written=22990
  • I/O Timings: read=97.369
4. 469.140 4,976.332 ↑ 1.0 1,910,089 1

Merge Left Join (cost=41,488.56..144,517.90 rows=1,919,335 width=58) (actual time=3,211.832..4,976.332 rows=1,910,089 loops=1)

  • Output: l0.lobj_name, l0.lobj_id, p2.lobj_name, p1_1.commentushort
  • Merge Cond: (l0.lobj_id = ln1_1.childlobj_id)
  • Buffers: shared hit=179391 read=14233, temp read=22905 written=22990
  • I/O Timings: read=88.734
5. 498.009 2,782.911 ↑ 1.0 1,910,089 1

Merge Left Join (cost=129.52..98,342.35 rows=1,919,335 width=40) (actual time=1,651.162..2,782.911 rows=1,910,089 loops=1)

  • Output: l0.lobj_name, l0.lobj_id, p2.lobj_name
  • Merge Cond: (l0.lobj_id = ln1.childlobj_id)
  • Buffers: shared hit=114136 read=14233, temp read=10769 written=10810
  • I/O Timings: read=88.734
6. 472.366 472.366 ↑ 1.0 1,910,089 1

Index Only Scan using ixu_o_pageorder_id on dalimes.o_pageorder l0 (cost=0.55..93,415.03 rows=1,919,335 width=27) (actual time=0.042..472.366 rows=1,910,089 loops=1)

  • Output: l0.lobj_id, l0.ts_deletion, l0.syshierarchy, l0.lobj_name
  • Index Cond: (l0.ts_deletion = 0)
  • Heap Fetches: 39455
  • Buffers: shared hit=30463 read=14233
  • I/O Timings: read=88.734
7. 1,316.322 1,812.536 ↓ 1,288,740.0 1,288,740 1

Sort (cost=128.97..128.97 rows=1 width=21) (actual time=1,651.096..1,812.536 rows=1,288,740 loops=1)

  • Output: ln1.childlobj_id, p2.lobj_name
  • Sort Key: ln1.childlobj_id
  • Sort Method: external sort Disk: 43240kB
  • Buffers: shared hit=83673, temp read=10769 written=10810
8. 137.093 496.214 ↓ 1,298,437.0 1,298,437 1

Nested Loop (cost=1.41..128.96 rows=1 width=21) (actual time=0.153..496.214 rows=1,298,437 loops=1)

  • Output: ln1.childlobj_id, p2.lobj_name
  • Buffers: shared hit=83673
9. 6.545 29.469 ↓ 9,157.0 9,157 1

Nested Loop (cost=0.85..124.50 rows=1 width=29) (actual time=0.111..29.469 rows=9,157 loops=1)

  • Output: p1.lobj_id, ln2.childlobj_id, p2.lobj_name
  • Buffers: shared hit=19222
10. 1.502 4.610 ↓ 9,157.0 9,157 1

Nested Loop (cost=0.56..120.19 rows=1 width=21) (actual time=0.083..4.610 rows=9,157 loops=1)

  • Output: ln2.childlobj_id, p2.lobj_name
  • Buffers: shared hit=328
11. 0.058 0.058 ↑ 1.0 25 1

Seq Scan on dalimes.o_customer p2 (cost=0.00..1.31 rows=25 width=21) (actual time=0.006..0.058 rows=25 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)
  • Buffers: shared hit=1
12. 3.050 3.050 ↓ 366.0 366 25

Index Only Scan using pk_objectlink on dalimes.objectlink ln2 (cost=0.56..4.74 rows=1 width=16) (actual time=0.011..0.122 rows=366 loops=25)

  • 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: 95
  • Buffers: shared hit=327
13. 18.314 18.314 ↑ 1.0 1 9,157

Index Only Scan using ixu_o_job_id on dalimes.o_job p1 (cost=0.29..4.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=9,157)

  • Output: p1.lobj_id, p1.ts_deletion, p1.syshierarchy, p1.lobj_name
  • Index Cond: ((p1.lobj_id = ln2.childlobj_id) AND (p1.ts_deletion = 0))
  • Heap Fetches: 462
  • Buffers: shared hit=18894
14. 329.652 329.652 ↓ 142.0 142 9,157

Index Only Scan using pk_objectlink on dalimes.objectlink ln1 (cost=0.56..4.45 rows=1 width=16) (actual time=0.007..0.036 rows=142 loops=9,157)

  • 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 = p1.lobj_id) AND (ln1.ts_deletion = 0) AND (ln1.childotpl_id = 53))
  • Heap Fetches: 17219
  • Buffers: shared hit=64451
15. 1,310.353 1,724.281 ↓ 460.6 1,288,740 1

Sort (cost=41,359.02..41,366.01 rows=2,798 width=26) (actual time=1,560.608..1,724.281 rows=1,288,740 loops=1)

  • Output: ln1_1.childlobj_id, p1_1.commentushort
  • Sort Key: ln1_1.childlobj_id
  • Sort Method: external sort Disk: 48720kB
  • Buffers: shared hit=65255, temp read=12136 written=12180
16. 135.765 413.928 ↓ 464.1 1,298,437 1

Nested Loop (cost=0.85..41,198.83 rows=2,798 width=26) (actual time=0.161..413.928 rows=1,298,437 loops=1)

  • Output: ln1_1.childlobj_id, p1_1.commentushort
  • Buffers: shared hit=65255
17. 3.423 3.423 ↓ 1.0 9,158 1

Index Only Scan using ix_o_job_shortcomment on dalimes.o_job p1_1 (cost=0.29..420.79 rows=9,153 width=26) (actual time=0.089..3.423 rows=9,158 loops=1)

  • Output: p1_1.commentushort, p1_1.ts_deletion, p1_1.lobj_id
  • Index Cond: (p1_1.ts_deletion = 0)
  • Heap Fetches: 462
  • Buffers: shared hit=400
18. 274.740 274.740 ↓ 142.0 142 9,158

Index Only Scan using pk_objectlink on dalimes.objectlink ln1_1 (cost=0.56..4.45 rows=1 width=16) (actual time=0.007..0.030 rows=142 loops=9,158)

  • 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 = p1_1.lobj_id) AND (ln1_1.ts_deletion = 0) AND (ln1_1.childotpl_id = 53))
  • Heap Fetches: 17219
  • Buffers: shared hit=64855
19. 0.193 78.509 ↓ 347.0 347 1

Sort (cost=32,581.05..32,581.06 rows=1 width=32) (actual time=78.457..78.509 rows=347 loops=1)

  • Output: pageorderparent.object_id, l0_1.lobj_id, ln1_2.childlobj_id, ln1_3.childlobj_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 52kB
  • Buffers: shared hit=26431 read=4
  • I/O Timings: read=1.024
20. 1.207 78.316 ↓ 347.0 347 1

Hash Join (cost=32,361.87..32,581.04 rows=1 width=32) (actual time=75.214..78.316 rows=347 loops=1)

  • Output: pageorderparent.object_id, l0_1.lobj_id, ln1_2.childlobj_id, ln1_3.childlobj_id
  • Hash Cond: (f.lobj_id = pageorderparent.parent_id)
  • Buffers: shared hit=26431 read=4
  • I/O Timings: read=1.024
21. 6.183 66.872 ↓ 1.7 15,376 1

HashAggregate (cost=32,342.56..32,434.84 rows=9,228 width=8) (actual time=64.868..66.872 rows=15,376 loops=1)

  • Output: f.lobj_id
  • Group Key: f.lobj_id
  • Buffers: shared hit=20046
22. 1.391 60.689 ↓ 1.7 15,376 1

Append (cost=184.09..32,319.49 rows=9,228 width=8) (actual time=0.780..60.689 rows=15,376 loops=1)

  • Buffers: shared hit=20046
23. 3.584 35.126 ↓ 199.3 6,177 1

Bitmap Heap Scan on dalimes.o_folder f (cost=184.09..29,723.09 rows=31 width=8) (actual time=0.774..35.126 rows=6,177 loops=1)

  • Output: f.lobj_id
  • Recheck Cond: (f.ts_deletion = 0)
  • Filter: (f.settings_depth = (SubPlan 17))
  • Rows Removed by Filter: 22
  • Heap Blocks: exact=222
  • Buffers: shared hit=19118
24. 0.547 0.547 ↓ 1.0 6,209 1

Bitmap Index Scan on ix_o_folder_objectid (cost=0.00..184.08 rows=6,200 width=0) (actual time=0.547..0.547 rows=6,209 loops=1)

  • Index Cond: (f.ts_deletion = 0)
  • Buffers: shared hit=33
25.          

SubPlan (forBitmap Heap Scan)

26. 12.398 30.995 ↑ 1.0 1 6,199

Aggregate (cost=4.70..4.71 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=6,199)

  • Output: count(DISTINCT objectaccess_1.depth)
  • Buffers: shared hit=18863
27. 18.597 18.597 ↓ 1.7 5 6,199

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_1 (cost=0.42..4.69 rows=3 width=8) (actual time=0.002..0.003 rows=5 loops=6,199)

  • Output: objectaccess_1.object_id, objectaccess_1.entry_id, objectaccess_1.depth
  • Index Cond: (objectaccess_1.object_id = f.lobj_id)
  • Filter: (objectaccess_1.entry_id = ANY ('{-1,6533,6212,6890,333,4583,6438,4310,4308,4306,5058,3590,3624,6441,4234,3561,4890,3586,3596,5482,444,3610,4706,3616,4820,5659,6254,4312,3620,4314}'::bigint[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 205
  • Buffers: shared hit=18863
28. 2.222 24.172 ↓ 1.0 9,199 1

Hash Join (cost=2,018.26..2,504.12 rows=9,197 width=8) (actual time=20.542..24.172 rows=9,199 loops=1)

  • Output: o_job.lobj_id
  • Hash Cond: (o_job.lobj_id = objectaccess.object_id)
  • Buffers: shared hit=928
29. 1.548 1.548 ↓ 1.0 9,202 1

Index Only Scan using ixu_o_job_id on dalimes.o_job (cost=0.29..398.24 rows=9,197 width=8) (actual time=0.020..1.548 rows=9,202 loops=1)

  • Output: o_job.lobj_id, o_job.ts_deletion, o_job.syshierarchy, o_job.lobj_name
  • Heap Fetches: 462
  • Buffers: shared hit=305
30. 2.223 20.402 ↓ 1.7 15,506 1

Hash (cost=1,905.29..1,905.29 rows=9,015 width=8) (actual time=20.402..20.402 rows=15,506 loops=1)

  • Output: objectaccess.object_id
  • Buckets: 16384 Batches: 1 Memory Usage: 734kB
  • Buffers: shared hit=623
31. 11.091 18.179 ↓ 1.7 15,506 1

HashAggregate (cost=1,815.14..1,905.29 rows=9,015 width=8) (actual time=16.213..18.179 rows=15,506 loops=1)

  • Output: objectaccess.object_id
  • Group Key: objectaccess.object_id
  • Buffers: shared hit=623
32. 7.088 7.088 ↓ 1.0 49,297 1

Index Only Scan using ixu_objectaccess_group on dalimes.objectaccess (cost=0.42..1,692.33 rows=49,125 width=8) (actual time=0.061..7.088 rows=49,297 loops=1)

  • Output: objectaccess.entry_id, objectaccess.object_id, objectaccess.depth
  • Index Cond: (objectaccess.entry_id = ANY ('{-1,6533,6212,6890,333,4583,6438,4310,4308,4306,5058,3590,3624,6441,4234,3561,4890,3586,3596,5482,444,3610,4706,3616,4820,5659,6254,4312,3620,4314}'::bigint[]))
  • Heap Fetches: 477
  • Buffers: shared hit=623
33. 0.098 10.237 ↓ 347.0 347 1

Hash (cost=19.29..19.29 rows=1 width=40) (actual time=10.237..10.237 rows=347 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id, l0_1.lobj_id, ln1_2.childlobj_id, ln1_3.childlobj_id
  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
  • Buffers: shared hit=6385 read=4
  • I/O Timings: read=1.024
34. 0.170 10.139 ↓ 347.0 347 1

Nested Loop (cost=19.24..19.29 rows=1 width=40) (actual time=7.961..10.139 rows=347 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id, l0_1.lobj_id, ln1_2.childlobj_id, ln1_3.childlobj_id
  • Buffers: shared hit=6385 read=4
  • I/O Timings: read=1.024
35. 0.251 7.887 ↓ 347.0 347 1

HashAggregate (cost=18.81..18.82 rows=1 width=24) (actual time=7.843..7.887 rows=347 loops=1)

  • Output: l0_1.lobj_id, ln1_2.childlobj_id, ln1_3.childlobj_id
  • Group Key: l0_1.lobj_id
  • Buffers: shared hit=5268 read=2
  • I/O Timings: read=1.005
36. 0.448 7.636 ↓ 347.0 347 1

Nested Loop (cost=2.68..18.81 rows=1 width=24) (actual time=0.588..7.636 rows=347 loops=1)

  • Output: l0_1.lobj_id, ln1_2.childlobj_id, ln1_3.childlobj_id
  • Join Filter: (ln2_1.parentlobj_id = p2_1.lobj_id)
  • Buffers: shared hit=5268 read=2
  • I/O Timings: read=1.005
37. 0.290 5.800 ↓ 347.0 347 1

Nested Loop (cost=2.68..17.42 rows=1 width=32) (actual time=0.526..5.800 rows=347 loops=1)

  • Output: l0_1.lobj_id, ln1_2.childlobj_id, ln2_1.parentlobj_id, ln1_3.childlobj_id
  • Buffers: shared hit=4921 read=2
  • I/O Timings: read=1.005
38. 0.143 5.163 ↓ 347.0 347 1

Nested Loop (cost=2.39..17.11 rows=1 width=48) (actual time=0.464..5.163 rows=347 loops=1)

  • Output: l0_1.lobj_id, ln1_2.parentlobj_id, ln1_2.childlobj_id, ln2_1.childlobj_id, ln2_1.parentlobj_id, ln1_3.childlobj_id
  • Buffers: shared hit=4226 read=2
  • I/O Timings: read=1.005
39. 0.229 3.979 ↓ 347.0 347 1

Nested Loop (cost=1.83..14.34 rows=1 width=32) (actual time=0.374..3.979 rows=347 loops=1)

  • Output: l0_1.lobj_id, ln1_2.parentlobj_id, ln1_2.childlobj_id, ln1_3.childlobj_id
  • Buffers: shared hit=2490 read=2
  • I/O Timings: read=1.005
40. 0.288 1.668 ↓ 347.0 347 1

Nested Loop (cost=1.27..13.53 rows=1 width=16) (actual time=0.295..1.668 rows=347 loops=1)

  • Output: l0_1.lobj_id, ln1_3.childlobj_id
  • Buffers: shared hit=1082
41. 0.074 0.339 ↓ 347.0 347 1

Nested Loop (cost=0.85..12.90 rows=1 width=8) (actual time=0.191..0.339 rows=347 loops=1)

  • Output: ln1_3.childlobj_id
  • Buffers: shared hit=28
42. 0.124 0.124 ↑ 1.0 1 1

Index Only Scan using ix_o_job_shortcomment on dalimes.o_job p1_3 (cost=0.29..4.30 rows=1 width=8) (actual time=0.123..0.124 rows=1 loops=1)

  • Output: p1_3.commentushort, p1_3.ts_deletion, p1_3.lobj_id
  • Index Cond: ((p1_3.commentushort = '20190306_DYEC_SLSet1'::text) AND (p1_3.ts_deletion = 0))
  • Heap Fetches: 0
  • Buffers: shared hit=3
43. 0.141 0.141 ↓ 347.0 347 1

Index Only Scan using pk_objectlink on dalimes.objectlink ln1_3 (cost=0.56..8.58 rows=1 width=16) (actual time=0.024..0.141 rows=347 loops=1)

  • 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: 14
  • Buffers: shared hit=25
44. 1.041 1.041 ↑ 1.0 1 347

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0_1 (cost=0.43..0.62 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=347)

  • Output: l0_1.ts_deletion, l0_1.lobj_id
  • Index Cond: ((l0_1.ts_deletion = 0) AND (l0_1.lobj_id = ln1_3.childlobj_id))
  • Heap Fetches: 11
  • Buffers: shared hit=1054
45. 2.082 2.082 ↑ 1.0 1 347

Index Only Scan using ix_objectlink_child_id on dalimes.objectlink ln1_2 (cost=0.56..0.80 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=347)

  • Output: ln1_2.childotpl_id, ln1_2.childlobj_id, ln1_2.ts_deletion, ln1_2.parentotpl_id, ln1_2.parentlobj_id
  • Index Cond: ((ln1_2.childotpl_id = 53) AND (ln1_2.childlobj_id = l0_1.lobj_id) AND (ln1_2.ts_deletion = 0) AND (ln1_2.parentotpl_id = 35))
  • Heap Fetches: 14
  • Buffers: shared hit=1408 read=2
  • I/O Timings: read=1.005
46. 1.041 1.041 ↑ 1.0 1 347

Index Only Scan using ix_objectlink_child_id on dalimes.objectlink ln2_1 (cost=0.56..2.75 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=347)

  • Output: ln2_1.childotpl_id, ln2_1.childlobj_id, ln2_1.ts_deletion, ln2_1.parentotpl_id, ln2_1.parentlobj_id
  • Index Cond: ((ln2_1.childotpl_id = 35) AND (ln2_1.childlobj_id = ln1_2.parentlobj_id) AND (ln2_1.ts_deletion = 0) AND (ln2_1.parentotpl_id = 8))
  • Heap Fetches: 347
  • Buffers: shared hit=1736
47. 0.347 0.347 ↑ 1.0 1 347

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

  • Output: p1_2.lobj_id, p1_2.ts_deletion, p1_2.syshierarchy, p1_2.lobj_name
  • Index Cond: ((p1_2.lobj_id = ln1_2.parentlobj_id) AND (p1_2.ts_deletion = 0))
  • Heap Fetches: 0
  • Buffers: shared hit=695
48. 1.388 1.388 ↑ 1.0 1 347

Seq Scan on dalimes.o_customer p2_1 (cost=0.00..1.38 rows=1 width=8) (actual time=0.002..0.004 rows=1 loops=347)

  • 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 = 'David Yurman'::text))
  • Rows Removed by Filter: 24
  • Buffers: shared hit=347
49. 2.082 2.082 ↑ 1.0 1 347

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent (cost=0.43..0.46 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=347)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = l0_1.lobj_id)
  • Heap Fetches: 76
  • Buffers: shared hit=1117 read=2
  • I/O Timings: read=0.019
50.          

SubPlan (forMerge Semi Join)

51. 4.434 4.511 ↑ 1.0 1 347

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder (cost=4.14..12.16 rows=1 width=17) (actual time=0.013..0.013 rows=1 loops=347)

  • Output: mdt_pageorder.data_value
  • Index Cond: ((mdt_pageorder.ts_deletion = 0) AND (mdt_pageorder.lobj_id = l0.lobj_id) AND ((mdt_pageorder.data_key)::text = 'selection'::text) AND (mdt_pageorder.ns_id = $0))
  • Buffers: shared hit=1685 read=54
  • I/O Timings: read=0.448
52.          

Initplan (forIndex Scan)

53. 0.077 0.077 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans (cost=0.00..3.58 rows=1 width=4) (actual time=0.055..0.077 rows=1 loops=1)

  • Output: metadatans.ns_id
  • Filter: (((metadatans.ns_label)::text = 'Selection Information'::text) AND (metadatans.ts_deletion = 0))
  • Rows Removed by Filter: 104
  • Buffers: shared hit=2
54. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_1 (cost=4.14..12.16 rows=1 width=8) (never executed)

  • Output: mdt_pageorder_1.data_extid
  • Index Cond: ((mdt_pageorder_1.ts_deletion = 0) AND (mdt_pageorder_1.lobj_id = l0.lobj_id) AND ((mdt_pageorder_1.data_key)::text = 'selection'::text) AND (mdt_pageorder_1.ns_id = $2))
55.          

Initplan (forIndex Scan)

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.metadatans metadatans_1 (cost=0.00..3.58 rows=1 width=4) (never executed)

  • Output: metadatans_1.ns_id
  • Filter: (((metadatans_1.ns_label)::text = 'Selection Information'::text) AND (metadatans_1.ts_deletion = 0))
57. 1.705 1.735 ↑ 1.0 1 347

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_2 (cost=4.14..12.16 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=347)

  • Output: mdt_pageorder_2.data_value
  • Index Cond: ((mdt_pageorder_2.ts_deletion = 0) AND (mdt_pageorder_2.lobj_id = l0.lobj_id) AND ((mdt_pageorder_2.data_key)::text = 'retouch'::text) AND (mdt_pageorder_2.ns_id = $4))
  • Buffers: shared hit=1728 read=8
  • I/O Timings: read=0.059
58.          

Initplan (forIndex Scan)

59. 0.030 0.030 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_2 (cost=0.00..3.58 rows=1 width=4) (actual time=0.020..0.030 rows=1 loops=1)

  • Output: metadatans_2.ns_id
  • Filter: (((metadatans_2.ns_label)::text = 'Selection Information'::text) AND (metadatans_2.ts_deletion = 0))
  • Rows Removed by Filter: 104
  • Buffers: shared hit=2
60. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_3 (cost=4.14..12.16 rows=1 width=8) (never executed)

  • Output: mdt_pageorder_3.data_extid
  • Index Cond: ((mdt_pageorder_3.ts_deletion = 0) AND (mdt_pageorder_3.lobj_id = l0.lobj_id) AND ((mdt_pageorder_3.data_key)::text = 'retouch'::text) AND (mdt_pageorder_3.ns_id = $6))
61.          

Initplan (forIndex Scan)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.metadatans metadatans_3 (cost=0.00..3.58 rows=1 width=4) (never executed)

  • Output: metadatans_3.ns_id
  • Filter: (((metadatans_3.ns_label)::text = 'Selection Information'::text) AND (metadatans_3.ts_deletion = 0))
63. 7.263 7.287 ↑ 1.0 1 347

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_4 (cost=4.14..12.16 rows=1 width=17) (actual time=0.021..0.021 rows=1 loops=347)

  • Output: mdt_pageorder_4.data_value
  • Index Cond: ((mdt_pageorder_4.ts_deletion = 0) AND (mdt_pageorder_4.lobj_id = l0.lobj_id) AND ((mdt_pageorder_4.data_key)::text = 'Rating'::text) AND (mdt_pageorder_4.ns_id = $8))
  • Buffers: shared hit=1638 read=106
  • I/O Timings: read=4.695
64.          

Initplan (forIndex Scan)

65. 0.024 0.024 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_4 (cost=0.00..3.58 rows=1 width=4) (actual time=0.022..0.024 rows=1 loops=1)

  • Output: metadatans_4.ns_id
  • Filter: (((metadatans_4.ns_label)::text = 'Application'::text) AND (metadatans_4.ts_deletion = 0))
  • Rows Removed by Filter: 104
  • Buffers: shared hit=2
66. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_5 (cost=4.14..12.16 rows=1 width=8) (never executed)

  • Output: mdt_pageorder_5.data_extid
  • Index Cond: ((mdt_pageorder_5.ts_deletion = 0) AND (mdt_pageorder_5.lobj_id = l0.lobj_id) AND ((mdt_pageorder_5.data_key)::text = 'Rating'::text) AND (mdt_pageorder_5.ns_id = $10))
67.          

Initplan (forIndex Scan)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.metadatans metadatans_5 (cost=0.00..3.58 rows=1 width=4) (never executed)

  • Output: metadatans_5.ns_id
  • Filter: (((metadatans_5.ns_label)::text = 'Application'::text) AND (metadatans_5.ts_deletion = 0))
69. 4.131 4.164 ↑ 1.0 1 347

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_6 (cost=4.14..12.16 rows=1 width=17) (actual time=0.012..0.012 rows=1 loops=347)

  • Output: mdt_pageorder_6.data_value
  • Index Cond: ((mdt_pageorder_6.ts_deletion = 0) AND (mdt_pageorder_6.lobj_id = l0.lobj_id) AND ((mdt_pageorder_6.data_key)::text = 'Label'::text) AND (mdt_pageorder_6.ns_id = $12))
  • Buffers: shared hit=1696 read=5
  • I/O Timings: read=2.409
70.          

Initplan (forIndex Scan)

71. 0.033 0.033 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_6 (cost=0.00..3.58 rows=1 width=4) (actual time=0.030..0.033 rows=1 loops=1)

  • Output: metadatans_6.ns_id
  • Filter: (((metadatans_6.ns_label)::text = 'Application'::text) AND (metadatans_6.ts_deletion = 0))
  • Rows Removed by Filter: 104
  • Buffers: shared hit=2
72. 0.133 0.152 ↓ 0.0 0 38

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_7 (cost=4.14..12.16 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=38)

  • Output: mdt_pageorder_7.data_extid
  • Index Cond: ((mdt_pageorder_7.ts_deletion = 0) AND (mdt_pageorder_7.lobj_id = l0.lobj_id) AND ((mdt_pageorder_7.data_key)::text = 'Label'::text) AND (mdt_pageorder_7.ns_id = $14))
  • Buffers: shared hit=153
73.          

Initplan (forIndex Scan)

74. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_7 (cost=0.00..3.58 rows=1 width=4) (actual time=0.017..0.019 rows=1 loops=1)

  • Output: metadatans_7.ns_id
  • Filter: (((metadatans_7.ns_label)::text = 'Application'::text) AND (metadatans_7.ts_deletion = 0))
  • Rows Removed by Filter: 104
  • Buffers: shared hit=2