explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ydxf

Settings
# exclusive inclusive rows x rows loops node
1. 60.417 13,450.887 ↑ 1.4 99,669 1

Subquery Scan on q (cost=71,550.85..7,966,833.71 rows=138,859 width=820) (actual time=2,505.694..13,450.887 rows=99,669 loops=1)

2. 27.025 13,390.470 ↑ 1.4 99,669 1

Append (cost=71,550.85..7,965,445.12 rows=138,859 width=204) (actual time=2,505.691..13,390.470 rows=99,669 loops=1)

3.          

CTE previousmet

4. 1.211 798.509 ↑ 1.7 1,096 1

HashAggregate (cost=26,762.45..26,780.94 rows=1,849 width=4) (actual time=798.276..798.509 rows=1,096 loops=1)

  • Group Key: i_3.meteringid
5. 127.965 797.298 ↓ 1.2 2,132 1

Merge Anti Join (cost=24,926.04..26,757.83 rows=1,849 width=4) (actual time=644.833..797.298 rows=2,132 loops=1)

  • Merge Cond: ((j.pointid = contractdpjournal.pointid) AND (i_3.previousindexdate = index.indexdate) AND (i_3.previousindex = index.index) AND ((i_3.timeframe)::text = (index.timeframe)::text) AND ((i_3.unit)::text = (index.unit)::text) AND ((i_3.type)::text = (index.type)::text))
6. 82.347 381.172 ↓ 2.3 63,890 1

Sort (cost=9,514.67..9,584.81 rows=28,056 width=29) (actual time=369.833..381.172 rows=63,890 loops=1)

  • Sort Key: j.pointid, i_3.previousindexdate, i_3.previousindex, i_3.timeframe, i_3.unit, i_3.type
  • Sort Method: quicksort Memory: 6,528kB
7. 53.535 298.825 ↓ 2.3 63,890 1

Hash Join (cost=3,152.49..7,441.89 rows=28,056 width=29) (actual time=38.744..298.825 rows=63,890 loops=1)

  • Hash Cond: (m_2.contractdpid = j.contractdpid)
8. 84.654 238.346 ↓ 2.3 63,890 1

Hash Join (cost=2,605.57..6,368.91 rows=28,056 width=29) (actual time=31.784..238.346 rows=63,890 loops=1)

  • Hash Cond: (i_3.meteringid = m_2.meteringid)
9. 122.015 122.015 ↓ 2.3 63,890 1

Seq Scan on index i_3 (cost=0.00..3,132.09 rows=28,056 width=25) (actual time=0.054..122.015 rows=63,890 loops=1)

  • Filter: (previousindexdate < indexdate)
  • Rows Removed by Filter: 20,277
10. 15.207 31.677 ↑ 1.0 68,114 1

Hash (cost=1,754.14..1,754.14 rows=68,114 width=8) (actual time=31.677..31.677 rows=68,114 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,661kB
11. 16.470 16.470 ↑ 1.0 68,114 1

Seq Scan on metering m_2 (cost=0.00..1,754.14 rows=68,114 width=8) (actual time=0.010..16.470 rows=68,114 loops=1)

12. 3.495 6.944 ↑ 1.0 10,619 1

Hash (cost=414.19..414.19 rows=10,619 width=8) (actual time=6.944..6.944 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 415kB
13. 3.449 3.449 ↑ 1.0 10,619 1

Seq Scan on contractdpjournal j (cost=0.00..414.19 rows=10,619 width=8) (actual time=0.005..3.449 rows=10,619 loops=1)

14. 86.175 288.161 ↑ 1.0 76,473 1

Sort (cost=15,411.37..15,602.92 rows=76,617 width=25) (actual time=274.988..288.161 rows=76,473 loops=1)

  • Sort Key: contractdpjournal.pointid, index.indexdate, index.index, index.timeframe, index.unit, index.type
  • Sort Method: quicksort Memory: 9,045kB
15. 46.486 201.986 ↑ 1.0 76,481 1

Hash Join (cost=548.20..9,195.68 rows=76,617 width=25) (actual time=4.654..201.986 rows=76,481 loops=1)

  • Hash Cond: (metering.contractdpid = contractdpjournal.contractdpid)
16. 56.303 150.915 ↑ 1.0 76,481 1

Merge Join (cost=1.27..7,212.18 rows=76,617 width=25) (actual time=0.054..150.915 rows=76,481 loops=1)

  • Merge Cond: (metering.meteringid = index.meteringid)
17. 35.663 35.663 ↑ 1.0 68,114 1

Index Scan using idx_metering_contractdpid on metering (cost=0.29..2,284.00 rows=68,114 width=8) (actual time=0.021..35.663 rows=68,114 loops=1)

18. 58.949 58.949 ↑ 1.0 76,481 1

Index Scan using idx_index_meteringid on index (cost=0.29..3,800.22 rows=76,617 width=25) (actual time=0.017..58.949 rows=76,481 loops=1)

  • Filter: ((status)::text = 'A'::text)
  • Rows Removed by Filter: 7,686
19. 1.965 4.585 ↑ 1.0 10,619 1

Hash (cost=414.19..414.19 rows=10,619 width=8) (actual time=4.585..4.585 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 415kB
20. 2.620 2.620 ↑ 1.0 10,619 1

Seq Scan on contractdpjournal (cost=0.00..414.19 rows=10,619 width=8) (actual time=0.010..2.620 rows=10,619 loops=1)

21. 1,467.287 11,303.666 ↓ 1.0 84,173 1

Nested Loop Left Join (cost=44,769.91..6,780,758.28 rows=84,167 width=217) (actual time=2,505.691..11,303.666 rows=84,173 loops=1)

  • Join Filter: (i.previousindexdate = i.indexdate)
  • Rows Removed by Join Filter: 792
22. 3,301.139 8,553.313 ↑ 1.0 84,167 1

Nested Loop Left Join (cost=44,769.61..2,040,835.14 rows=84,167 width=221) (actual time=1,523.631..8,553.313 rows=84,167 loops=1)

  • Join Filter: (dpc.dpconfigjid IS NULL)
  • Rows Removed by Join Filter: 84,166
23. 3,011.361 4,999.673 ↑ 1.0 84,167 1

Nested Loop Left Join (cost=44,754.08..727,475.28 rows=84,167 width=223) (actual time=1,523.384..4,999.673 rows=84,167 loops=1)

24. 189.345 1,735.811 ↑ 1.0 84,167 1

Hash Join (cost=44,746.10..49,561.52 rows=84,167 width=217) (actual time=1,522.829..1,735.811 rows=84,167 loops=1)

  • Hash Cond: (i.meteringid = m.meteringid)
25. 23.881 23.881 ↑ 1.0 84,167 1

Seq Scan on index i (cost=0.00..2,921.67 rows=84,167 width=71) (actual time=0.202..23.881 rows=84,167 loops=1)

26. 57.667 1,522.585 ↑ 1.0 68,114 1

Hash (cost=43,894.67..43,894.67 rows=68,114 width=150) (actual time=1,522.585..1,522.585 rows=68,114 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 11,385kB
27. 70.902 1,464.918 ↑ 1.0 68,114 1

Hash Left Join (cost=13,837.82..43,894.67 rows=68,114 width=150) (actual time=413.653..1,464.918 rows=68,114 loops=1)

  • Hash Cond: (t.envid = msg.envid)
28. 74.854 1,133.069 ↑ 1.0 68,114 1

Hash Join (cost=4,657.67..33,353.26 rows=68,114 width=137) (actual time=152.638..1,133.069 rows=68,114 loops=1)

  • Hash Cond: (m.contractdpid = cdp.contractdpid)
29. 481.669 982.755 ↑ 1.0 68,114 1

Hash Right Join (cost=2,605.57..30,024.02 rows=68,114 width=57) (actual time=77.157..982.755 rows=68,114 loops=1)

  • Hash Cond: (t.msgid = m.txref)
30. 425.631 425.631 ↑ 1.0 564,873 1

Seq Scan on transaction t (cost=0.00..19,731.73 rows=564,873 width=47) (actual time=0.009..425.631 rows=564,873 loops=1)

31. 24.059 75.455 ↑ 1.0 68,114 1

Hash (cost=1,754.14..1,754.14 rows=68,114 width=18) (actual time=75.455..75.455 rows=68,114 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 3,438kB
32. 51.396 51.396 ↑ 1.0 68,114 1

Seq Scan on metering m (cost=0.00..1,754.14 rows=68,114 width=18) (actual time=0.010..51.396 rows=68,114 loops=1)

33. 6.991 75.460 ↑ 1.0 10,619 1

Hash (cost=1,919.37..1,919.37 rows=10,619 width=84) (actual time=75.460..75.460 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 1,036kB
34. 6.176 68.469 ↑ 1.0 10,619 1

Hash Left Join (cost=592.74..1,919.37 rows=10,619 width=84) (actual time=11.972..68.469 rows=10,619 loops=1)

  • Hash Cond: (contract.supplierid = s.supplierid)
35. 10.512 62.237 ↑ 1.0 10,619 1

Hash Join (cost=591.70..1,772.31 rows=10,619 width=56) (actual time=11.907..62.237 rows=10,619 loops=1)

  • Hash Cond: (cdp.contractid = contract.contractid)
36. 9.831 39.875 ↑ 1.0 10,619 1

Merge Join (cost=0.61..982.12 rows=10,619 width=52) (actual time=0.036..39.875 rows=10,619 loops=1)

  • Merge Cond: (dp.pointid = cdp.pointid)
37. 12.064 12.064 ↑ 1.0 8,487 1

Index Scan using deliverypoint_pkey on deliverypoint dp (cost=0.29..290.59 rows=8,487 width=27) (actual time=0.011..12.064 rows=8,487 loops=1)

38. 17.980 17.980 ↑ 1.0 10,619 1

Index Scan using idx_contractdpjournal_pointid_pk on contractdpjournal cdp (cost=0.29..537.57 rows=10,619 width=25) (actual time=0.005..17.980 rows=10,619 loops=1)

39. 2.180 11.850 ↑ 1.0 10,404 1

Hash (cost=461.04..461.04 rows=10,404 width=8) (actual time=11.850..11.850 rows=10,404 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 407kB
40. 9.670 9.670 ↑ 1.0 10,404 1

Seq Scan on contract (cost=0.00..461.04 rows=10,404 width=8) (actual time=0.339..9.670 rows=10,404 loops=1)

41. 0.003 0.056 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=36) (actual time=0.056..0.056 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
42. 0.053 0.053 ↑ 1.0 2 1

Seq Scan on supplier s (cost=0.00..1.02 rows=2 width=36) (actual time=0.052..0.053 rows=2 loops=1)

43. 71.643 260.947 ↑ 1.0 194,940 1

Hash (cost=6,743.40..6,743.40 rows=194,940 width=21) (actual time=260.947..260.947 rows=194,940 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 10,849kB
44. 189.304 189.304 ↑ 1.0 194,940 1

Seq Scan on msgenv msg (cost=0.00..6,743.40 rows=194,940 width=21) (actual time=0.047..189.304 rows=194,940 loops=1)

45. 0.000 252.501 ↑ 1.0 1 84,167

Index Scan using dpj_un on dpconfigjournal dpc (cost=7.98..8.04 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=84,167)

  • Index Cond: (dpconfigjid = (SubPlan 11))
46.          

SubPlan (for Index Scan)

47. 0.000 2,777.511 ↑ 1.0 1 84,167

Limit (cost=7.69..7.70 rows=1 width=26) (actual time=0.033..0.033 rows=1 loops=84,167)

48. 505.002 2,777.511 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.033..0.033 rows=1 loops=84,167)

  • Sort Key: ((tx_2.msgdate)::date), ((j_3.creationdate)::date), j_3.fromdate, j_3.powerlimiter, m_5.budgetmeter
  • Sort Method: quicksort Memory: 25kB
49. 237.084 2,272.509 ↓ 2.0 2 84,167

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.014..0.027 rows=2 loops=84,167)

50. 231.945 1,515.006 ↓ 2.0 2 84,167

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.010..0.018 rows=2 loops=84,167)

51. 589.169 589.169 ↓ 2.0 2 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_3 (cost=0.29..2.91 rows=1 width=25) (actual time=0.004..0.007 rows=2 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((fromdate <= i.indexdate) AND ((source)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
52. 693.892 693.892 ↑ 1.0 1 173,473

Index Scan using idx_transaction_msgid_pk on transaction tx_2 (cost=0.42..2.44 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=173,473)

  • Index Cond: (msgid = j_3.txref)
53. 520.419 520.419 ↑ 1.0 1 173,473

Index Scan using idx_meter_physicalconfigid_pk on meter m_5 (cost=0.29..2.30 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=173,473)

  • Index Cond: (j_3.physicalconfigid = physicalconfigid)
54. 0.000 2,777.511 ↑ 1.0 1 84,167

Limit (cost=7.69..7.70 rows=1 width=26) (actual time=0.033..0.033 rows=1 loops=84,167)

55. 505.002 2,777.511 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.033..0.033 rows=1 loops=84,167)

  • Sort Key: ((tx_2.msgdate)::date), ((j_3.creationdate)::date), j_3.fromdate, j_3.powerlimiter, m_5.budgetmeter
  • Sort Method: quicksort Memory: 25kB
56. 237.084 2,272.509 ↓ 2.0 2 84,167

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.014..0.027 rows=2 loops=84,167)

57. 231.945 1,515.006 ↓ 2.0 2 84,167

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.010..0.018 rows=2 loops=84,167)

58. 589.169 589.169 ↓ 2.0 2 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_3 (cost=0.29..2.91 rows=1 width=25) (actual time=0.004..0.007 rows=2 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((fromdate <= i.indexdate) AND ((source)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
59. 693.892 693.892 ↑ 1.0 1 173,473

Index Scan using idx_transaction_msgid_pk on transaction tx_2 (cost=0.42..2.44 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=173,473)

  • Index Cond: (msgid = j_3.txref)
60. 520.419 520.419 ↑ 1.0 1 173,473

Index Scan using idx_meter_physicalconfigid_pk on meter m_5 (cost=0.29..2.30 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=173,473)

  • Index Cond: (j_3.physicalconfigid = physicalconfigid)
61. 0.000 252.501 ↑ 1.0 1 84,167

Index Scan using dpj_un on dpconfigjournal dpc2 (cost=15.53..15.59 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=84,167)

  • Index Cond: (dpconfigjid = (SubPlan 13))
62.          

SubPlan (for Index Scan)

63. 0.000 3,114.179 ↑ 1.0 1 84,167

Limit (cost=15.24..15.25 rows=1 width=26) (actual time=0.037..0.037 rows=1 loops=84,167)

64.          

Initplan (for Limit)

65. 84.167 1,346.672 ↑ 1.0 1 84,167

Aggregate (cost=7.54..7.55 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=84,167)

66. 127.763 1,262.505 ↓ 1.5 3 84,167

Nested Loop Left Join (cost=0.57..7.53 rows=2 width=4) (actual time=0.006..0.015 rows=3 loops=84,167)

67. 420.835 420.835 ↓ 1.5 3 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j1_1 (cost=0.29..2.91 rows=2 width=12) (actual time=0.003..0.005 rows=3 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((source)::text = 'DGO'::text)
68. 713.907 713.907 ↑ 1.0 1 237,969

Index Only Scan using idx_meter_physicalconfigid_pk on meter m1_1 (cost=0.29..2.30 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=237,969)

  • Index Cond: (physicalconfigid = j1_1.physicalconfigid)
  • Heap Fetches: 265,022
69. 252.501 3,030.012 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.036..0.036 rows=1 loops=84,167)

  • Sort Key: ((tx_3.msgdate)::date), ((j_4.creationdate)::date), j_4.powerlimiter, m_6.budgetmeter
  • Sort Method: quicksort Memory: 25kB
70. 302.946 2,777.511 ↑ 1.0 1 84,167

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.028..0.033 rows=1 loops=84,167)

71. 117.751 2,272.509 ↑ 1.0 1 84,167

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.024..0.027 rows=1 loops=84,167)

72. 1,851.674 1,851.674 ↑ 1.0 1 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_4 (cost=0.29..2.91 rows=1 width=25) (actual time=0.020..0.022 rows=1 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: (((source)::text = 'DGO'::text) AND (fromdate = $36))
  • Rows Removed by Filter: 2
73. 303.084 303.084 ↑ 1.0 1 101,028

Index Scan using idx_transaction_msgid_pk on transaction tx_3 (cost=0.42..2.44 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=101,028)

  • Index Cond: (msgid = j_4.txref)
74. 202.056 202.056 ↑ 1.0 1 101,028

Index Scan using idx_meter_physicalconfigid_pk on meter m_6 (cost=0.29..2.30 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=101,028)

  • Index Cond: (j_4.physicalconfigid = physicalconfigid)
75. 0.000 3,114.179 ↑ 1.0 1 84,167

Limit (cost=15.24..15.25 rows=1 width=26) (actual time=0.037..0.037 rows=1 loops=84,167)

76.          

Initplan (for Limit)

77. 84.167 1,346.672 ↑ 1.0 1 84,167

Aggregate (cost=7.54..7.55 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=84,167)

78. 127.763 1,262.505 ↓ 1.5 3 84,167

Nested Loop Left Join (cost=0.57..7.53 rows=2 width=4) (actual time=0.006..0.015 rows=3 loops=84,167)

79. 420.835 420.835 ↓ 1.5 3 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j1_1 (cost=0.29..2.91 rows=2 width=12) (actual time=0.003..0.005 rows=3 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((source)::text = 'DGO'::text)
80. 713.907 713.907 ↑ 1.0 1 237,969

Index Only Scan using idx_meter_physicalconfigid_pk on meter m1_1 (cost=0.29..2.30 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=237,969)

  • Index Cond: (physicalconfigid = j1_1.physicalconfigid)
  • Heap Fetches: 265,022
81. 252.501 3,030.012 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.036..0.036 rows=1 loops=84,167)

  • Sort Key: ((tx_3.msgdate)::date), ((j_4.creationdate)::date), j_4.powerlimiter, m_6.budgetmeter
  • Sort Method: quicksort Memory: 25kB
82. 302.946 2,777.511 ↑ 1.0 1 84,167

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.028..0.033 rows=1 loops=84,167)

83. 117.751 2,272.509 ↑ 1.0 1 84,167

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.024..0.027 rows=1 loops=84,167)

84. 1,851.674 1,851.674 ↑ 1.0 1 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_4 (cost=0.29..2.91 rows=1 width=25) (actual time=0.020..0.022 rows=1 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: (((source)::text = 'DGO'::text) AND (fromdate = $36))
  • Rows Removed by Filter: 2
85. 303.084 303.084 ↑ 1.0 1 101,028

Index Scan using idx_transaction_msgid_pk on transaction tx_3 (cost=0.42..2.44 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=101,028)

  • Index Cond: (msgid = j_4.txref)
86. 202.056 202.056 ↑ 1.0 1 101,028

Index Scan using idx_meter_physicalconfigid_pk on meter m_6 (cost=0.29..2.30 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=101,028)

  • Index Cond: (j_4.physicalconfigid = physicalconfigid)
87. 336.668 336.668 ↓ 0.0 0 84,167

Index Scan using idx_index_meteringid on index i2 (cost=0.29..0.38 rows=1 width=19) (actual time=0.004..0.004 rows=0 loops=84,167)

  • Index Cond: (i.meteringid = meteringid)
  • Filter: ((i.meterid <> meterid) AND ((i.timeframe)::text = (timeframe)::text) AND ((i.unit)::text = (unit)::text) AND ((i.type)::text = (type)::text))
  • Rows Removed by Filter: 2
88.          

SubPlan (for Nested Loop Left Join)

89. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=50.07..53.70 rows=1 width=0) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=49.78..52.54 rows=3 width=8) (never executed)

  • Hash Cond: (previousmet_1.meteringid = m3.meteringid)
91. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=41.60..43.60 rows=200 width=4) (never executed)

  • Group Key: previousmet_1.meteringid
92. 0.000 0.000 ↓ 0.0 0

CTE Scan on previousmet previousmet_1 (cost=0.00..36.98 rows=1,849 width=4) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.10..8.10 rows=6 width=4) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..8.10 rows=6 width=4) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_contractdpjournal_pointid_pk on contractdpjournal j3 (cost=0.29..2.30 rows=1 width=4) (never executed)

  • Index Cond: (pointid = cdp.pointid)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_metering_contractdpid_2 on metering m3 (cost=0.29..5.73 rows=7 width=8) (never executed)

  • Index Cond: (contractdpid = j3.contractdpid)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_index_meteringid on index i3 (cost=0.29..0.38 rows=1 width=4) (never executed)

  • Index Cond: (meteringid = m3.meteringid)
  • Filter: ((previousindexdate = i.indexdate) AND ((status)::text = 'A'::text))
98. 1.136 850.523 ↑ 22.4 1,710 1

Hash Join (cost=3,194.39..5,015.67 rows=38,308 width=8) (actual time=840.447..850.523 rows=1,710 loops=1)

  • Hash Cond: (m3_1.contractdpid = j3_1.contractdpid)
99. 1.614 839.794 ↑ 22.4 1,710 1

Hash Join (cost=2,647.46..3,750.47 rows=38,308 width=8) (actual time=830.840..839.794 rows=1,710 loops=1)

  • Hash Cond: (i3_1.meteringid = m3_1.meteringid)
100. 0.523 806.627 ↑ 22.4 1,710 1

Nested Loop (cost=41.90..282.97 rows=38,308 width=12) (actual time=799.257..806.627 rows=1,710 loops=1)

101. 0.671 799.528 ↓ 5.5 1,096 1

HashAggregate (cost=41.60..43.60 rows=200 width=4) (actual time=799.216..799.528 rows=1,096 loops=1)

  • Group Key: previousmet_2.meteringid
102. 798.857 798.857 ↑ 1.7 1,096 1

CTE Scan on previousmet previousmet_2 (cost=0.00..36.98 rows=1,849 width=4) (actual time=798.286..798.857 rows=1,096 loops=1)

103. 6.576 6.576 ↑ 1.0 2 1,096

Index Scan using idx_index_meteringid on index i3_1 (cost=0.29..1.18 rows=2 width=8) (actual time=0.005..0.006 rows=2 loops=1,096)

  • Index Cond: (meteringid = previousmet_2.meteringid)
  • Filter: ((status)::text = 'A'::text)
  • Rows Removed by Filter: 1
104. 15.148 31.553 ↑ 1.0 68,114 1

Hash (cost=1,754.14..1,754.14 rows=68,114 width=8) (actual time=31.553..31.553 rows=68,114 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,661kB
105. 16.405 16.405 ↑ 1.0 68,114 1

Seq Scan on metering m3_1 (cost=0.00..1,754.14 rows=68,114 width=8) (actual time=0.006..16.405 rows=68,114 loops=1)

106. 3.174 9.593 ↑ 1.0 10,619 1

Hash (cost=414.19..414.19 rows=10,619 width=8) (actual time=9.593..9.593 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 415kB
107. 6.419 6.419 ↑ 1.0 10,619 1

Seq Scan on contractdpjournal j3_1 (cost=0.00..414.19 rows=10,619 width=8) (actual time=0.064..6.419 rows=10,619 loops=1)

108. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..8.64 rows=6 width=0) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_contractdpjournal_pointid_pk on contractdpjournal cdp_5 (cost=0.29..2.30 rows=1 width=4) (never executed)

  • Index Cond: (pointid = dp.pointid)
110. 0.000 0.000 ↓ 0.0 0

Index Only Scan using process_idx4test on process p_2 (cost=0.29..6.27 rows=7 width=4) (never executed)

  • Index Cond: (contractdpid = cdp_5.contractdpid)
  • Heap Fetches: 0
111. 55.242 95.875 ↑ 1.0 61,691 1

Hash Join (cost=546.93..3,359.54 rows=61,691 width=4) (actual time=5.345..95.875 rows=61,691 loops=1)

  • Hash Cond: (p_3.contractdpid = cdp_6.contractdpid)
112. 35.358 35.358 ↑ 1.0 61,691 1

Seq Scan on process p_3 (cost=0.00..1,655.91 rows=61,691 width=4) (actual time=0.052..35.358 rows=61,691 loops=1)

113. 2.357 5.275 ↑ 1.0 10,619 1

Hash (cost=414.19..414.19 rows=10,619 width=8) (actual time=5.275..5.275 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 415kB
114. 2.918 2.918 ↑ 1.0 10,619 1

Seq Scan on contractdpjournal cdp_6 (cost=0.00..414.19 rows=10,619 width=8) (actual time=0.006..2.918 rows=10,619 loops=1)

115. 1.763 1,925.525 ↑ 15.4 2,728 1

Subquery Scan on *SELECT* 2 (cost=44,816.01..1,153,362.49 rows=41,988 width=209) (actual time=1,385.498..1,925.525 rows=2,728 loops=1)

116. 66.289 1,923.762 ↑ 15.4 2,728 1

Nested Loop Left Join (cost=44,816.01..1,152,942.61 rows=41,988 width=209) (actual time=1,385.496..1,923.762 rows=2,728 loops=1)

  • Join Filter: (i_1.previousindexdate = i_1.indexdate)
  • Rows Removed by Join Filter: 44
117. 119.784 1,790.230 ↑ 15.4 2,728 1

Nested Loop Left Join (cost=44,815.72..1,043,298.12 rows=41,988 width=217) (actual time=1,385.380..1,790.230 rows=2,728 loops=1)

  • Join Filter: (dpc_1.dpconfigjid IS NULL)
  • Rows Removed by Join Filter: 2,728
118. 104.845 1,662.262 ↑ 15.4 2,728 1

Nested Loop Left Join (cost=44,800.18..388,108.39 rows=41,988 width=219) (actual time=1,385.298..1,662.262 rows=2,728 loops=1)

119. 17.150 1,549.233 ↑ 15.4 2,728 1

Hash Join (cost=44,792.20..49,920.71 rows=41,988 width=213) (actual time=1,385.198..1,549.233 rows=2,728 loops=1)

  • Hash Cond: (m_1.meteringid = previousmet.meteringid)
120. 116.657 1,531.182 ↓ 1.0 84,080 1

Hash Join (cost=44,746.10..49,557.22 rows=83,976 width=217) (actual time=1,384.277..1,531.182 rows=84,080 loops=1)

  • Hash Cond: (i_1.meteringid = m_1.meteringid)
121. 30.325 30.325 ↓ 1.0 84,080 1

Seq Scan on index i_1 (cost=0.00..2,921.67 rows=83,976 width=71) (actual time=0.034..30.325 rows=84,080 loops=1)

  • Filter: ((previousindexdate IS NOT NULL) AND (previousindex IS NOT NULL))
  • Rows Removed by Filter: 87
122. 59.571 1,384.200 ↑ 1.0 68,114 1

Hash (cost=43,894.67..43,894.67 rows=68,114 width=146) (actual time=1,384.200..1,384.200 rows=68,114 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 11,168kB
123. 68.408 1,324.629 ↑ 1.0 68,114 1

Hash Left Join (cost=13,837.82..43,894.67 rows=68,114 width=146) (actual time=341.406..1,324.629 rows=68,114 loops=1)

  • Hash Cond: (t_1.envid = msg_1.envid)
124. 79.037 1,020.234 ↑ 1.0 68,114 1

Hash Join (cost=4,657.67..33,353.26 rows=68,114 width=133) (actual time=105.344..1,020.234 rows=68,114 loops=1)

  • Hash Cond: (m_1.contractdpid = cdp_1.contractdpid)
125. 501.912 877.304 ↑ 1.0 68,114 1

Hash Right Join (cost=2,605.57..30,024.02 rows=68,114 width=57) (actual time=41.442..877.304 rows=68,114 loops=1)

  • Hash Cond: (t_1.msgid = m_1.txref)
126. 334.991 334.991 ↑ 1.0 564,873 1

Seq Scan on transaction t_1 (cost=0.00..19,731.73 rows=564,873 width=47) (actual time=0.004..334.991 rows=564,873 loops=1)

127. 18.242 40.401 ↑ 1.0 68,114 1

Hash (cost=1,754.14..1,754.14 rows=68,114 width=18) (actual time=40.401..40.401 rows=68,114 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 3,438kB
128. 22.159 22.159 ↑ 1.0 68,114 1

Seq Scan on metering m_1 (cost=0.00..1,754.14 rows=68,114 width=18) (actual time=0.006..22.159 rows=68,114 loops=1)

129. 6.159 63.893 ↑ 1.0 10,619 1

Hash (cost=1,919.37..1,919.37 rows=10,619 width=80) (actual time=63.893..63.893 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 995kB
130. 5.598 57.734 ↑ 1.0 10,619 1

Hash Left Join (cost=592.74..1,919.37 rows=10,619 width=80) (actual time=14.280..57.734 rows=10,619 loops=1)

  • Hash Cond: (contract_1.supplierid = s_1.supplierid)
131. 9.758 52.088 ↑ 1.0 10,619 1

Hash Join (cost=591.70..1,772.31 rows=10,619 width=52) (actual time=14.209..52.088 rows=10,619 loops=1)

  • Hash Cond: (cdp_1.contractid = contract_1.contractid)
132. 8.852 28.177 ↑ 1.0 10,619 1

Merge Join (cost=0.61..982.12 rows=10,619 width=48) (actual time=0.030..28.177 rows=10,619 loops=1)

  • Merge Cond: (dp_1.pointid = cdp_1.pointid)
133. 7.089 7.089 ↑ 1.0 8,487 1

Index Scan using deliverypoint_pkey on deliverypoint dp_1 (cost=0.29..290.59 rows=8,487 width=27) (actual time=0.013..7.089 rows=8,487 loops=1)

134. 12.236 12.236 ↑ 1.0 10,619 1

Index Scan using idx_contractdpjournal_pointid_pk on contractdpjournal cdp_1 (cost=0.29..537.57 rows=10,619 width=25) (actual time=0.010..12.236 rows=10,619 loops=1)

135. 2.659 14.153 ↑ 1.0 10,404 1

Hash (cost=461.04..461.04 rows=10,404 width=8) (actual time=14.153..14.153 rows=10,404 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 407kB
136. 11.494 11.494 ↑ 1.0 10,404 1

Seq Scan on contract contract_1 (cost=0.00..461.04 rows=10,404 width=8) (actual time=0.255..11.494 rows=10,404 loops=1)

137. 0.003 0.048 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=36) (actual time=0.048..0.048 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
138. 0.045 0.045 ↑ 1.0 2 1

Seq Scan on supplier s_1 (cost=0.00..1.02 rows=2 width=36) (actual time=0.045..0.045 rows=2 loops=1)

139. 71.104 235.987 ↑ 1.0 194,940 1

Hash (cost=6,743.40..6,743.40 rows=194,940 width=21) (actual time=235.987..235.987 rows=194,940 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 10,849kB
140. 164.883 164.883 ↑ 1.0 194,940 1

Seq Scan on msgenv msg_1 (cost=0.00..6,743.40 rows=194,940 width=21) (actual time=0.040..164.883 rows=194,940 loops=1)

141. 0.204 0.901 ↓ 5.5 1,096 1

Hash (cost=43.60..43.60 rows=200 width=4) (actual time=0.901..0.901 rows=1,096 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
142. 0.543 0.697 ↓ 5.5 1,096 1

HashAggregate (cost=41.60..43.60 rows=200 width=4) (actual time=0.518..0.697 rows=1,096 loops=1)

  • Group Key: previousmet.meteringid
143. 0.154 0.154 ↑ 1.7 1,096 1

CTE Scan on previousmet (cost=0.00..36.98 rows=1,849 width=4) (actual time=0.002..0.154 rows=1,096 loops=1)

144. 0.000 8.184 ↑ 1.0 1 2,728

Index Scan using dpj_un on dpconfigjournal dpc_1 (cost=7.98..8.04 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=2,728)

  • Index Cond: (dpconfigjid = (SubPlan 4))
145.          

SubPlan (for Index Scan)

146. 2.728 98.208 ↑ 1.0 1 2,728

Limit (cost=7.69..7.70 rows=1 width=26) (actual time=0.036..0.036 rows=1 loops=2,728)

147. 13.640 95.480 ↑ 1.0 1 2,728

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.035..0.035 rows=1 loops=2,728)

  • Sort Key: ((tx.msgdate)::date), ((j_1.creationdate)::date), j_1.fromdate, j_1.powerlimiter, m_3.budgetmeter
  • Sort Method: quicksort Memory: 25kB
148. 11.366 81.840 ↓ 3.0 3 2,728

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.014..0.030 rows=3 loops=2,728)

149. 7.880 51.832 ↓ 2.0 2 2,728

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.009..0.019 rows=2 loops=2,728)

150. 19.096 19.096 ↓ 2.0 2 2,728

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_1 (cost=0.29..2.91 rows=1 width=25) (actual time=0.004..0.007 rows=2 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: ((fromdate <= i_1.indexdate) AND ((source)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
151. 24.856 24.856 ↑ 1.0 1 6,214

Index Scan using idx_transaction_msgid_pk on transaction tx (cost=0.42..2.44 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=6,214)

  • Index Cond: (msgid = j_1.txref)
152. 18.642 18.642 ↑ 1.0 1 6,214

Index Scan using idx_meter_physicalconfigid_pk on meter m_3 (cost=0.29..2.30 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=6,214)

  • Index Cond: (j_1.physicalconfigid = physicalconfigid)
153. 2.728 98.208 ↑ 1.0 1 2,728

Limit (cost=7.69..7.70 rows=1 width=26) (actual time=0.036..0.036 rows=1 loops=2,728)

154. 13.640 95.480 ↑ 1.0 1 2,728

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.035..0.035 rows=1 loops=2,728)

  • Sort Key: ((tx.msgdate)::date), ((j_1.creationdate)::date), j_1.fromdate, j_1.powerlimiter, m_3.budgetmeter
  • Sort Method: quicksort Memory: 25kB
155. 11.366 81.840 ↓ 3.0 3 2,728

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.014..0.030 rows=3 loops=2,728)

156. 7.880 51.832 ↓ 2.0 2 2,728

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.009..0.019 rows=2 loops=2,728)

157. 19.096 19.096 ↓ 2.0 2 2,728

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_1 (cost=0.29..2.91 rows=1 width=25) (actual time=0.004..0.007 rows=2 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: ((fromdate <= i_1.indexdate) AND ((source)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
158. 24.856 24.856 ↑ 1.0 1 6,214

Index Scan using idx_transaction_msgid_pk on transaction tx (cost=0.42..2.44 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=6,214)

  • Index Cond: (msgid = j_1.txref)
159. 18.642 18.642 ↑ 1.0 1 6,214

Index Scan using idx_meter_physicalconfigid_pk on meter m_3 (cost=0.29..2.30 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=6,214)

  • Index Cond: (j_1.physicalconfigid = physicalconfigid)
160. 0.000 8.184 ↑ 1.0 1 2,728

Index Scan using dpj_un on dpconfigjournal dpc2_1 (cost=15.53..15.59 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=2,728)

  • Index Cond: (dpconfigjid = (SubPlan 6))
161.          

SubPlan (for Index Scan)

162. 0.000 114.576 ↑ 1.0 1 2,728

Limit (cost=15.24..15.25 rows=1 width=26) (actual time=0.042..0.042 rows=1 loops=2,728)

163.          

Initplan (for Limit)

164. 2.728 51.832 ↑ 1.0 1 2,728

Aggregate (cost=7.54..7.55 rows=1 width=4) (actual time=0.019..0.019 rows=1 loops=2,728)

165. 3.939 49.104 ↓ 2.0 4 2,728

Nested Loop Left Join (cost=0.57..7.53 rows=2 width=4) (actual time=0.006..0.018 rows=4 loops=2,728)

166. 16.368 16.368 ↓ 2.0 4 2,728

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j1 (cost=0.29..2.91 rows=2 width=12) (actual time=0.003..0.006 rows=4 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: ((source)::text = 'DGO'::text)
167. 28.797 28.797 ↑ 1.0 1 9,599

Index Only Scan using idx_meter_physicalconfigid_pk on meter m1 (cost=0.29..2.30 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=9,599)

  • Index Cond: (physicalconfigid = j1.physicalconfigid)
  • Heap Fetches: 10,919
168. 10.912 111.848 ↑ 1.0 1 2,728

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.041..0.041 rows=1 loops=2,728)

  • Sort Key: ((tx_1.msgdate)::date), ((j_2.creationdate)::date), j_2.powerlimiter, m_4.budgetmeter
  • Sort Method: quicksort Memory: 25kB
169. 3.440 100.936 ↑ 1.0 1 2,728

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.032..0.037 rows=1 loops=2,728)

170. 6.168 87.296 ↑ 1.0 1 2,728

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.028..0.032 rows=1 loops=2,728)

171. 70.928 70.928 ↑ 1.0 1 2,728

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_2 (cost=0.29..2.91 rows=1 width=25) (actual time=0.024..0.026 rows=1 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: (((source)::text = 'DGO'::text) AND (fromdate = $10))
  • Rows Removed by Filter: 2
172. 10.200 10.200 ↑ 1.0 1 3,400

Index Scan using idx_transaction_msgid_pk on transaction tx_1 (cost=0.42..2.44 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=3,400)

  • Index Cond: (msgid = j_2.txref)
173. 10.200 10.200 ↑ 1.0 1 3,400

Index Scan using idx_meter_physicalconfigid_pk on meter m_4 (cost=0.29..2.30 rows=1 width=5) (actual time=0.002..0.003 rows=1 loops=3,400)

  • Index Cond: (j_2.physicalconfigid = physicalconfigid)
174. 0.000 114.576 ↑ 1.0 1 2,728

Limit (cost=15.24..15.25 rows=1 width=26) (actual time=0.042..0.042 rows=1 loops=2,728)

175.          

Initplan (for Limit)

176. 2.728 51.832 ↑ 1.0 1 2,728

Aggregate (cost=7.54..7.55 rows=1 width=4) (actual time=0.019..0.019 rows=1 loops=2,728)

177. 3.939 49.104 ↓ 2.0 4 2,728

Nested Loop Left Join (cost=0.57..7.53 rows=2 width=4) (actual time=0.006..0.018 rows=4 loops=2,728)

178. 16.368 16.368 ↓ 2.0 4 2,728

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j1 (cost=0.29..2.91 rows=2 width=12) (actual time=0.003..0.006 rows=4 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: ((source)::text = 'DGO'::text)
179. 28.797 28.797 ↑ 1.0 1 9,599

Index Only Scan using idx_meter_physicalconfigid_pk on meter m1 (cost=0.29..2.30 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=9,599)

  • Index Cond: (physicalconfigid = j1.physicalconfigid)
  • Heap Fetches: 10,919
180. 10.912 111.848 ↑ 1.0 1 2,728

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.041..0.041 rows=1 loops=2,728)

  • Sort Key: ((tx_1.msgdate)::date), ((j_2.creationdate)::date), j_2.powerlimiter, m_4.budgetmeter
  • Sort Method: quicksort Memory: 25kB
181. 3.440 100.936 ↑ 1.0 1 2,728

Nested Loop Left Join (cost=0.99..7.68 rows=1 width=26) (actual time=0.032..0.037 rows=1 loops=2,728)

182. 6.168 87.296 ↑ 1.0 1 2,728

Nested Loop Left Join (cost=0.71..5.37 rows=1 width=29) (actual time=0.028..0.032 rows=1 loops=2,728)

183. 70.928 70.928 ↑ 1.0 1 2,728

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_2 (cost=0.29..2.91 rows=1 width=25) (actual time=0.024..0.026 rows=1 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: (((source)::text = 'DGO'::text) AND (fromdate = $10))
  • Rows Removed by Filter: 2
184. 10.200 10.200 ↑ 1.0 1 3,400

Index Scan using idx_transaction_msgid_pk on transaction tx_1 (cost=0.42..2.44 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=3,400)

  • Index Cond: (msgid = j_2.txref)
185. 10.200 10.200 ↑ 1.0 1 3,400

Index Scan using idx_meter_physicalconfigid_pk on meter m_4 (cost=0.29..2.30 rows=1 width=5) (actual time=0.002..0.003 rows=1 loops=3,400)

  • Index Cond: (j_2.physicalconfigid = physicalconfigid)
186. 16.368 16.368 ↓ 0.0 0 2,728

Index Scan using idx_index_meteringid on index i2_1 (cost=0.29..0.38 rows=1 width=19) (actual time=0.006..0.006 rows=0 loops=2,728)

  • Index Cond: (i_1.meteringid = meteringid)
  • Filter: ((i_1.meterid <> meterid) AND ((i_1.timeframe)::text = (timeframe)::text) AND ((i_1.unit)::text = (unit)::text) AND ((i_1.type)::text = (type)::text))
  • Rows Removed by Filter: 4
187.          

SubPlan (for Nested Loop Left Join)

188. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..8.64 rows=6 width=0) (never executed)

189. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_contractdpjournal_pointid_pk on contractdpjournal cdp_3 (cost=0.29..2.30 rows=1 width=4) (never executed)

  • Index Cond: (pointid = dp_1.pointid)
190. 0.000 0.000 ↓ 0.0 0

Index Only Scan using process_idx4test on process p (cost=0.29..6.27 rows=7 width=4) (never executed)

  • Index Cond: (contractdpid = cdp_3.contractdpid)
  • Heap Fetches: 0
191. 35.465 50.875 ↑ 1.0 61,691 1

Hash Join (cost=546.93..3,359.54 rows=61,691 width=4) (actual time=4.868..50.875 rows=61,691 loops=1)

  • Hash Cond: (p_1.contractdpid = cdp_4.contractdpid)
192. 10.559 10.559 ↑ 1.0 61,691 1

Seq Scan on process p_1 (cost=0.00..1,655.91 rows=61,691 width=4) (actual time=0.005..10.559 rows=61,691 loops=1)

193. 2.168 4.851 ↑ 1.0 10,619 1

Hash (cost=414.19..414.19 rows=10,619 width=8) (actual time=4.851..4.851 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 415kB
194. 2.683 2.683 ↑ 1.0 10,619 1

Seq Scan on contractdpjournal cdp_4 (cost=0.00..414.19 rows=10,619 width=8) (actual time=0.005..2.683 rows=10,619 loops=1)

195. 5.510 134.254 ↓ 1.0 12,768 1

Subquery Scan on *SELECT* 3 (cost=2,052.11..3,701.75 rows=12,704 width=106) (actual time=40.582..134.254 rows=12,768 loops=1)

196. 80.848 128.744 ↓ 1.0 12,768 1

Hash Join (cost=2,052.11..3,574.71 rows=12,704 width=106) (actual time=40.580..128.744 rows=12,768 loops=1)

  • Hash Cond: (i_2.contractdpid = cdp_2.contractdpid)
197. 7.445 7.445 ↓ 1.0 12,768 1

Seq Scan on userindex i_2 (cost=0.00..331.60 rows=12,704 width=42) (actual time=0.068..7.445 rows=12,768 loops=1)

  • Filter: ((indexdate IS NULL) OR (indexdate <= '9999-12-31 00:00:00+01'::timestamp with time zone))
198. 5.334 40.451 ↑ 1.0 10,619 1

Hash (cost=1,919.37..1,919.37 rows=10,619 width=68) (actual time=40.451..40.451 rows=10,619 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 839kB
199. 4.138 35.117 ↑ 1.0 10,619 1

Hash Left Join (cost=592.74..1,919.37 rows=10,619 width=68) (actual time=4.942..35.117 rows=10,619 loops=1)

  • Hash Cond: (contract_2.supplierid = s_2.supplierid)
200. 6.440 30.974 ↑ 1.0 10,619 1

Hash Join (cost=591.70..1,772.31 rows=10,619 width=40) (actual time=4.928..30.974 rows=10,619 loops=1)

  • Hash Cond: (cdp_2.contractid = contract_2.contractid)
201. 6.377 19.645 ↑ 1.0 10,619 1

Merge Join (cost=0.61..982.12 rows=10,619 width=36) (actual time=0.029..19.645 rows=10,619 loops=1)

  • Merge Cond: (dp_2.pointid = cdp_2.pointid)
202. 5.364 5.364 ↑ 1.0 8,487 1

Index Scan using deliverypoint_pkey on deliverypoint dp_2 (cost=0.29..290.59 rows=8,487 width=24) (actual time=0.012..5.364 rows=8,487 loops=1)

203. 7.904 7.904 ↑ 1.0 10,619 1

Index Scan using idx_contractdpjournal_pointid_pk on contractdpjournal cdp_2 (cost=0.29..537.57 rows=10,619 width=20) (actual time=0.008..7.904 rows=10,619 loops=1)

204. 2.116 4.889 ↑ 1.0 10,404 1

Hash (cost=461.04..461.04 rows=10,404 width=8) (actual time=4.889..4.889 rows=10,404 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 407kB
205. 2.773 2.773 ↑ 1.0 10,404 1

Seq Scan on contract contract_2 (cost=0.00..461.04 rows=10,404 width=8) (actual time=0.013..2.773 rows=10,404 loops=1)

206. 0.001 0.005 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=36) (actual time=0.005..0.005 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
207. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on supplier s_2 (cost=0.00..1.02 rows=2 width=36) (actual time=0.003..0.004 rows=2 loops=1)