explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mUdV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 46,836.557 ↓ 0.0 0 1

Unique (cost=71,030.37..71,030.39 rows=1 width=8) (actual time=46,836.557..46,836.557 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=8243646 read=456037
  • I/O Timings: read=32633.353
2. 0.008 46,836.556 ↓ 0.0 0 1

Merge Semi Join (cost=71,030.37..71,030.39 rows=1 width=8) (actual time=46,836.556..46,836.556 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Merge Cond: (l0.lobj_id = pageorderparent_1.object_id)
  • Buffers: shared hit=8243646 read=456037
  • I/O Timings: read=32633.353
3. 262.397 6,607.797 ↑ 1.0 1 1

Sort (cost=32,528.77..32,528.78 rows=1 width=24) (actual time=6,607.797..6,607.797 rows=1 loops=1)

  • Output: pageorderparent.object_id, l0.lobj_id, ln1.childlobj_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 9612kB
  • Buffers: shared hit=687721 read=4991
  • I/O Timings: read=3221.799
4. 29.743 6,345.400 ↓ 83,709.0 83,709 1

Hash Join (cost=32,279.52..32,528.76 rows=1 width=24) (actual time=6,310.028..6,345.400 rows=83,709 loops=1)

  • Output: pageorderparent.object_id, l0.lobj_id, ln1.childlobj_id
  • Hash Cond: (f.lobj_id = pageorderparent.parent_id)
  • Buffers: shared hit=687721 read=4991
  • I/O Timings: read=3221.799
5. 224.421 518.480 ↓ 1.6 16,756 1

HashAggregate (cost=32,267.49..32,372.43 rows=10,494 width=8) (actual time=512.741..518.480 rows=16,756 loops=1)

  • Output: f.lobj_id
  • Group Key: f.lobj_id
  • Buffers: shared hit=18905 read=882
  • I/O Timings: read=147.441
6. 2.812 294.059 ↓ 1.6 16,756 1

Append (cost=0.00..32,241.26 rows=10,494 width=8) (actual time=0.355..294.059 rows=16,756 loops=1)

  • Buffers: shared hit=18905 read=882
  • I/O Timings: read=147.441
7. 23.040 130.446 ↓ 196.7 6,295 1

Seq Scan on dalimes.o_folder f (cost=0.00..30,096.73 rows=32 width=8) (actual time=0.354..130.446 rows=6,295 loops=1)

  • Output: f.lobj_id
  • Filter: ((f.ts_deletion = 0) AND (f.settings_depth = (SubPlan 1)))
  • Rows Removed by Filter: 23
  • Buffers: shared hit=18777 read=587
  • I/O Timings: read=55.763
8.          

SubPlan (forSeq Scan)

9. 12.636 107.406 ↑ 1.0 1 6,318

Aggregate (cost=4.71..4.72 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=6,318)

  • Output: count(DISTINCT objectaccess_2.depth)
  • Buffers: shared hit=18776 read=407
  • I/O Timings: read=39.617
10. 94.770 94.770 ↓ 2.5 5 6,318

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_2 (cost=0.42..4.71 rows=2 width=8) (actual time=0.009..0.015 rows=5 loops=6,318)

  • 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 (ARRAY[$2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 0
  • Buffers: shared hit=18776 read=407
  • I/O Timings: read=39.617
11. 6.187 160.801 ↑ 1.0 10,461 1

Hash Join (cost=1,537.57..2,039.59 rows=10,462 width=8) (actual time=151.408..160.801 rows=10,461 loops=1)

  • Output: o_job.lobj_id
  • Hash Cond: (o_job.lobj_id = objectaccess.object_id)
  • Buffers: shared hit=128 read=295
  • I/O Timings: read=91.678
12. 3.412 3.412 ↑ 1.0 10,462 1

Index Only Scan using ixu_o_job_id on dalimes.o_job (cost=0.29..421.22 rows=10,462 width=8) (actual time=0.016..3.412 rows=10,462 loops=1)

  • Output: o_job.lobj_id, o_job.ts_deletion, o_job.syshierarchy, o_job.lobj_name
  • Heap Fetches: 0
  • Buffers: shared hit=41 read=25
  • I/O Timings: read=0.237
13. 11.953 151.202 ↓ 2.5 16,951 1

Hash (cost=1,452.44..1,452.44 rows=6,788 width=8) (actual time=151.202..151.202 rows=16,951 loops=1)

  • Output: objectaccess.object_id
  • Buckets: 32768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 919kB
  • Buffers: shared hit=87 read=270
  • I/O Timings: read=91.441
14. 34.524 139.249 ↓ 2.5 16,951 1

HashAggregate (cost=1,384.56..1,452.44 rows=6,788 width=8) (actual time=132.565..139.249 rows=16,951 loops=1)

  • Output: objectaccess.object_id
  • Group Key: objectaccess.object_id
  • Buffers: shared hit=87 read=270
  • I/O Timings: read=91.441
15. 104.725 104.725 ↓ 1.4 52,341 1

Index Only Scan using ixu_objectaccess_group on dalimes.objectaccess (cost=0.42..1,292.67 rows=36,755 width=8) (actual time=10.483..104.725 rows=52,341 loops=1)

  • Output: objectaccess.entry_id, objectaccess.object_id, objectaccess.depth
  • Index Cond: (objectaccess.entry_id = ANY (ARRAY[$34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65]))
  • Heap Fetches: 0
  • Buffers: shared hit=87 read=270
  • I/O Timings: read=91.441
16. 84.807 5,797.177 ↓ 83,709.0 83,709 1

Hash (cost=12.02..12.02 rows=1 width=32) (actual time=5,797.177..5,797.177 rows=83,709 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id, l0.lobj_id, ln1.childlobj_id
  • Buckets: 131072 (originally 1024) Batches: 1 (originally 1) Memory Usage: 6256kB
  • Buffers: shared hit=668816 read=4109
  • I/O Timings: read=3074.358
17. 43.378 5,712.370 ↓ 83,709.0 83,709 1

Nested Loop (cost=11.97..12.02 rows=1 width=32) (actual time=3,387.405..5,712.370 rows=83,709 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id, l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=668816 read=4109
  • I/O Timings: read=3074.358
18. 1,576.978 3,408.849 ↓ 83,709.0 83,709 1

HashAggregate (cost=11.54..11.55 rows=1 width=16) (actual time=3,368.839..3,408.849 rows=83,709 loops=1)

  • Output: l0.lobj_id, ln1.childlobj_id
  • Group Key: l0.lobj_id
  • Buffers: shared hit=418917 read=2262
  • I/O Timings: read=1040.613
19. 30.416 1,831.871 ↓ 83,709.0 83,709 1

Nested Loop (cost=1.83..11.53 rows=1 width=16) (actual time=92.732..1,831.871 rows=83,709 loops=1)

  • Output: l0.lobj_id, ln1.childlobj_id
  • Buffers: shared hit=418917 read=2262
  • I/O Timings: read=1040.613
20. 75.245 1,550.328 ↓ 83,709.0 83,709 1

Nested Loop (cost=1.55..11.22 rows=1 width=32) (actual time=92.689..1,550.328 rows=83,709 loops=1)

  • Output: l0.lobj_id, ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=251184 read=2225
  • I/O Timings: read=1039.966
21. 25.624 554.284 ↓ 83,709.0 83,709 1

Nested Loop (cost=1.12..10.59 rows=1 width=24) (actual time=58.835..554.284 rows=83,709 loops=1)

  • Output: ln1.parentlobj_id, ln1.childlobj_id, ln2.childlobj_id
  • Buffers: shared hit=872 read=788
  • I/O Timings: read=470.216
22. 0.278 47.970 ↓ 218.0 218 1

Nested Loop (cost=0.56..6.00 rows=1 width=8) (actual time=47.587..47.970 rows=218 loops=1)

  • Output: ln2.childlobj_id
  • Buffers: shared hit=8 read=5
  • I/O Timings: read=29.061
23. 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.017..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 = $1))
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1
24. 47.661 47.661 ↓ 218.0 218 1

Index Only Scan using pk_objectlink on dalimes.objectlink ln2 (cost=0.56..4.58 rows=1 width=16) (actual time=47.442..47.661 rows=218 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=7 read=5
  • I/O Timings: read=29.061
25. 480.690 480.690 ↓ 384.0 384 218

Index Only Scan using pk_objectlink on dalimes.objectlink ln1 (cost=0.56..4.58 rows=1 width=16) (actual time=1.440..2.205 rows=384 loops=218)

  • 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=864 read=783
  • I/O Timings: read=441.155
26. 920.799 920.799 ↑ 1.0 1 83,709

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0 (cost=0.43..0.61 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=83,709)

  • 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=250312 read=1437
  • I/O Timings: read=569.750
27. 251.127 251.127 ↑ 1.0 1 83,709

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

  • 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=167733 read=37
  • I/O Timings: read=0.647
28. 2,260.143 2,260.143 ↑ 1.0 1 83,709

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent (cost=0.43..0.46 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=83,709)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = l0.lobj_id)
  • Heap Fetches: 0
  • Buffers: shared hit=249899 read=1847
  • I/O Timings: read=2033.745
29. 0.014 40,228.751 ↓ 0.0 0 1

Sort (cost=38,501.59..38,501.60 rows=1 width=16) (actual time=40,228.751..40,228.751 rows=0 loops=1)

  • Output: pageorderparent_1.object_id, appinf.lobj_id
  • Sort Key: pageorderparent_1.object_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7555925 read=451046
  • I/O Timings: read=29411.554
30. 0.023 40,228.737 ↓ 0.0 0 1

Hash Join (cost=38,252.34..38,501.58 rows=1 width=16) (actual time=40,228.737..40,228.737 rows=0 loops=1)

  • Output: pageorderparent_1.object_id, appinf.lobj_id
  • Hash Cond: (f_1.lobj_id = pageorderparent_1.parent_id)
  • Buffers: shared hit=7555925 read=451046
  • I/O Timings: read=29411.554
31. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=32,267.49..32,372.43 rows=10,494 width=8) (never executed)

  • Output: f_1.lobj_id
  • Group Key: f_1.lobj_id
32. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..32,241.26 rows=10,494 width=8) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.o_folder f_1 (cost=0.00..30,096.73 rows=32 width=8) (never executed)

  • Output: f_1.lobj_id
  • Filter: ((f_1.ts_deletion = 0) AND (f_1.settings_depth = (SubPlan 3)))
34.          

SubPlan (forSeq Scan)

35. 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)
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_3 (cost=0.42..4.71 rows=2 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 (ARRAY[$103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134]))
  • Heap Fetches: 0
37. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,537.57..2,039.59 rows=10,462 width=8) (never executed)

  • Output: o_job_1.lobj_id
  • Hash Cond: (o_job_1.lobj_id = objectaccess_1.object_id)
38. 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..421.22 rows=10,462 width=8) (never executed)

  • Output: o_job_1.lobj_id, o_job_1.ts_deletion, o_job_1.syshierarchy, o_job_1.lobj_name
  • Heap Fetches: 0
39. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,452.44..1,452.44 rows=6,788 width=8) (never executed)

  • Output: objectaccess_1.object_id
40. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,384.56..1,452.44 rows=6,788 width=8) (never executed)

  • Output: objectaccess_1.object_id
  • Group Key: objectaccess_1.object_id
41. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixu_objectaccess_group on dalimes.objectaccess objectaccess_1 (cost=0.42..1,292.67 rows=36,755 width=8) (never executed)

  • Output: objectaccess_1.entry_id, objectaccess_1.object_id, objectaccess_1.depth
  • Index Cond: (objectaccess_1.entry_id = ANY (ARRAY[$135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166]))
  • Heap Fetches: 0
42. 0.001 40,228.714 ↓ 0.0 0 1

Hash (cost=5,984.84..5,984.84 rows=1 width=24) (actual time=40,228.714..40,228.714 rows=0 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id, appinf.lobj_id
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=7555925 read=451046
  • I/O Timings: read=29411.554
43. 0.000 40,228.713 ↓ 0.0 0 1

Nested Loop (cost=5,980.79..5,984.84 rows=1 width=24) (actual time=40,228.713..40,228.713 rows=0 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id, appinf.lobj_id
  • Buffers: shared hit=7555925 read=451046
  • I/O Timings: read=29411.554
44. 0.003 40,228.713 ↓ 0.0 0 1

HashAggregate (cost=5,980.36..5,980.37 rows=1 width=8) (actual time=40,228.713..40,228.713 rows=0 loops=1)

  • Output: appinf.lobj_id
  • Group Key: appinf.lobj_id
  • Buffers: shared hit=7555925 read=451046
  • I/O Timings: read=29411.554
45. 0.000 40,228.710 ↓ 0.0 0 1

Nested Loop (cost=2.25..5,980.36 rows=1 width=8) (actual time=40,228.710..40,228.710 rows=0 loops=1)

  • Output: appinf.lobj_id
  • Buffers: shared hit=7555925 read=451046
  • I/O Timings: read=29411.554
46. 538.698 40,228.710 ↓ 0.0 0 1

Nested Loop (cost=1.97..5,976.78 rows=1 width=16) (actual time=40,228.710..40,228.710 rows=0 loops=1)

  • Output: appinf.lobj_id, ln1_1.parentlobj_id
  • Buffers: shared hit=7555925 read=451046
  • I/O Timings: read=29411.554
47. 546.772 35,204.982 ↓ 747,505.0 747,505 1

Nested Loop (cost=1.55..5,951.96 rows=1 width=32) (actual time=82.899..35,204.982 rows=747,505 loops=1)

  • Output: l0_1.lobj_id, ln1_1.parentlobj_id, ln1_1.childlobj_id, mtd0.lobj_id
  • Buffers: shared hit=5284690 read=448658
  • I/O Timings: read=26908.102
48. 450.542 31,668.190 ↓ 747,505.0 747,505 1

Nested Loop (cost=1.12..5,949.77 rows=1 width=24) (actual time=82.844..31,668.190 rows=747,505 loops=1)

  • Output: ln1_1.parentlobj_id, ln1_1.childlobj_id, mtd0.lobj_id
  • Buffers: shared hit=3040035 read=445054
  • I/O Timings: read=26283.501
49. 23,742.538 23,742.538 ↓ 747,511.0 747,511 1

Index Scan using ix_mdt_pageorder_key on dalimes.mdt_pageorder mtd0 (cost=0.56..5,945.18 rows=1 width=8) (actual time=37.571..23,742.538 rows=747,511 loops=1)

  • 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.data_key)::text = $101) AND (mtd0.ns_id = $102))
  • Filter: ((mtd0.data_value)::text = $100)
  • Rows Removed by Filter: 599859
  • Buffers: shared hit=14098 read=436113
  • I/O Timings: read=21986.028
50. 7,475.110 7,475.110 ↑ 1.0 1 747,511

Index Only Scan using ix_objectlink_child_id on dalimes.objectlink ln1_1 (cost=0.56..4.58 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=747,511)

  • Output: ln1_1.childotpl_id, ln1_1.childlobj_id, ln1_1.ts_deletion, ln1_1.parentotpl_id, ln1_1.parentlobj_id
  • Index Cond: ((ln1_1.childotpl_id = 53) AND (ln1_1.childlobj_id = mtd0.lobj_id) AND (ln1_1.ts_deletion = 0) AND (ln1_1.parentotpl_id = 35))
  • Heap Fetches: 0
  • Buffers: shared hit=3025937 read=8941
  • I/O Timings: read=4297.473
51. 2,990.020 2,990.020 ↑ 1.0 1 747,505

Index Only Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0_1 (cost=0.43..2.17 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=747,505)

  • 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=2244655 read=3604
  • I/O Timings: read=624.601
52. 4,485.030 4,485.030 ↓ 0.0 0 747,505

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

  • 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_1.lobj_id) AND (appinf.approved = 0))
  • Filter: ((appinf.otpl_id = $66) AND ((appinf.app_info)::text = ANY ((ARRAY[($67)::character varying, ($68)::character varying, ($69)::character varying, ($70)::character varying, ($71)::character varying, ($72)::character varying, ($73)::character varying, ($74)::character varying, ($75)::character varying, ($76)::character varying, ($77)::character varying, ($78)::character varying, ($79)::character varying, ($80)::character varying, ($81)::character varying, ($82)::character varying, ($83)::character varying, ($84)::character varying, ($85)::character varying, ($86)::character varying, ($87)::character varying, ($88)::character varying, ($89)::character varying, ($90)::character varying, ($91)::character varying, ($92)::character varying, ($93)::character varying, ($94)::character varying, ($95)::character varying, ($96)::character varying, ($97)::character varying])::text[])) AND (NOT (SubPlan 2)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2271235 read=2388
  • I/O Timings: read=2503.452
53.          

SubPlan (forIndex Scan)

54. 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 = $98) AND (approvalinfo.otpl_id = $99))
  • Filter: (approvalinfo.exestep_id = appinf.exestep_id)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_o_job_topublish on dalimes.o_job p1_1 (cost=0.28..3.57 rows=1 width=8) (never executed)

  • Output: p1_1.outerpage_scalingvalue, p1_1.new_useissuescaling, p1_1.new_routingmargins, p1_1.lobj_isroot, p1_1.blocksize_back, p1_1.lobj_id, p1_1.new_defaultoffsety, p1_1.new_pageorderworkflow, p1_1.segmenttrim_overfold, p1_1.new_defaultrotation, p1_1.new_publicationdate, p1_1.new_defaultoffsetx, p1_1.new_collatingmarksposition, p1_1.new_simulation, p1_1.new_shrinkouterribon, p1_1.new_jobworkflow, p1_1.new_inhousepostprocessing, p1_1.syshierarchy, p1_1.printedtrim_footer, p1_1.parent_node_id, p1_1.outerpage_creepvalue, p1_1.segmenttrim_outer, p1_1.lobj_name, p1_1.segmenttrim_routingmargins, p1_1.new_folding, p1_1.new_lockshortname, p1_1.new_priority, p1_1.maximalscaling_use, p1_1.maximalscaling_value, p1_1.new_reversedview, p1_1.new_trimmedwidth, p1_1.new_safetylr, p1_1.ostt_list, p1_1.lobj_version, p1_1.new_exportasrss, p1_1.new_formworkflow, p1_1.new_rolemasks, p1_1.nw_denyupdateofpublicationda, p1_1.new_trimmedheight, p1_1.ts_deletion, p1_1.new_shiftmark, p1_1.new_site, p1_1.new_iccname, p1_1.maximalscaling_steps, p1_1.ts_creation, p1_1.printedtrim_head, p1_1.printedtrim_face, p1_1.new_skalingmethod, p1_1.outerpage_scalingstartvalue, p1_1.segmenttrim_gutter, p1_1.new_bleedleftandright, p1_1.new_usesectionscaling, p1_1.new_pagecuttoff, p1_1.ts_lastchange, p1_1.commentulong, p1_1.new_usenbpageforskaling, p1_1.creationuser_code, p1_1.new_safetytb, p1_1.new_creepingreference, p1_1.new_applycreeping, p1_1.new_compensatebracketeffect, p1_1.segmenttrim_millingdepth, p1_1.blocksize_front, p1_1.segmenttrim_footer, p1_1.new_bleedtopandbottom, p1_1.new_uselinearissuescaling, p1_1.innerpage_scalingvalue, p1_1.maximalscaling_stepsperform, p1_1.innerpage_creepvalue, p1_1.commentushort, p1_1.new_reelpostprocessing, p1_1.node_id, p1_1.new_uselinearsectionscaling, p1_1.new_mainpageorder, p1_1.ostt_value, p1_1.lastchangeuser_code, p1_1.segmenttrim_head
  • Index Cond: (p1_1.lobj_id = ln1_1.parentlobj_id)
56. 0.000 0.000 ↓ 0.0 0

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

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = appinf.lobj_id)
  • Heap Fetches: 0