explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qIwt

Settings
# exclusive inclusive rows x rows loops node
1. 1,511.921 17,791.310 ↓ 2.0 84,173 1

Nested Loop Left Join (cost=67,748.12..3,388,483.57 rows=42,084 width=217) (actual time=3,067.743..17,791.310 rows=84,173 loops=1)

  • Join Filter: (i.previousindexdate = i.indexdate)
  • Rows Removed by Join Filter: 792
2.          

CTE previousmet

3. 1.067 891.965 ↑ 1.7 1,096 1

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

  • Group Key: i_1.meteringid
4. 96.675 890.898 ↓ 1.2 2,132 1

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

  • Merge Cond: ((j.pointid = contractdpjournal.pointid) AND (i_1.previousindexdate = index.indexdate) AND (i_1.previousindex = index.index) AND ((i_1.timeframe)::text = (index.timeframe)::text) AND ((i_1.unit)::text = (index.unit)::text) AND ((i_1.type)::text = (index.type)::text))
5. 93.377 487.309 ↓ 2.3 63,890 1

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

  • Sort Key: j.pointid, i_1.previousindexdate, i_1.previousindex, i_1.timeframe, i_1.unit, i_1.type
  • Sort Method: quicksort Memory: 6,528kB
6. 47.887 393.932 ↓ 2.3 63,890 1

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

  • Hash Cond: (m_1.contractdpid = j.contractdpid)
7. 75.950 328.549 ↓ 2.3 63,890 1

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

  • Hash Cond: (i_1.meteringid = m_1.meteringid)
8. 175.747 175.747 ↓ 2.3 63,890 1

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

  • Filter: (previousindexdate < indexdate)
  • Rows Removed by Filter: 20,277
9. 45.505 76.852 ↑ 1.0 68,114 1

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

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

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

11. 5.840 17.496 ↑ 1.0 10,619 1

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

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

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

13. 96.506 306.914 ↑ 1.0 76,473 1

Sort (cost=15,411.37..15,602.92 rows=76,617 width=25) (actual time=296.764..306.914 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
14. 49.356 210.408 ↑ 1.0 76,481 1

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

  • Hash Cond: (metering.contractdpid = contractdpjournal.contractdpid)
15. 55.281 155.345 ↑ 1.0 76,481 1

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

  • Merge Cond: (metering.meteringid = index.meteringid)
16. 38.606 38.606 ↑ 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.018..38.606 rows=68,114 loops=1)

17. 61.458 61.458 ↑ 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..61.458 rows=76,481 loops=1)

  • Filter: ((status)::text = 'A'::text)
  • Rows Removed by Filter: 7,686
18. 2.807 5.707 ↑ 1.0 10,619 1

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

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

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

20. 3,026.595 9,158.024 ↓ 2.0 84,167 1

Nested Loop Left Join (cost=40,966.88..1,042,616.72 rows=42,084 width=221) (actual time=2,068.312..9,158.024 rows=84,167 loops=1)

  • Join Filter: (dpc.dpconfigjid IS NULL)
  • Rows Removed by Join Filter: 84,166
21. 3,093.323 5,878.928 ↓ 2.0 84,167 1

Nested Loop Left Join (cost=40,951.35..385,928.99 rows=42,084 width=223) (actual time=2,065.314..5,878.928 rows=84,167 loops=1)

22. 100.252 2,533.104 ↓ 2.0 84,167 1

Hash Left Join (cost=40,943.36..46,968.09 rows=42,084 width=217) (actual time=2,060.525..2,533.104 rows=84,167 loops=1)

  • Hash Cond: (t.envid = msg.envid)
23. 113.357 2,056.183 ↓ 2.0 84,167 1

Hash Join (cost=31,763.21..36,946.89 rows=42,084 width=204) (actual time=1,683.426..2,056.183 rows=84,167 loops=1)

  • Hash Cond: (m.contractdpid = cdp.contractdpid)
24. 230.685 1,830.807 ↓ 2.0 84,167 1

Hash Join (cost=29,711.11..34,105.71 rows=42,084 width=124) (actual time=1,571.329..1,830.807 rows=84,167 loops=1)

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

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

26. 51.784 1,570.797 ↓ 2.0 68,114 1

Hash (cost=29,285.40..29,285.40 rows=34,057 width=57) (actual time=1,570.797..1,570.797 rows=68,114 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 5,975kB
27. 734.527 1,519.013 ↓ 2.0 68,114 1

Hash Right Join (cost=2,179.85..29,285.40 rows=34,057 width=57) (actual time=95.130..1,519.013 rows=68,114 loops=1)

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

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

29. 25.030 92.737 ↓ 2.0 68,114 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 3,438kB
30. 67.707 67.707 ↓ 2.0 68,114 1

Seq Scan on metering m (cost=0.00..1,754.14 rows=34,057 width=18) (actual time=0.006..67.707 rows=68,114 loops=1)

  • Filter: (migration IS TRUE)
31. 7.956 112.019 ↑ 1.0 10,619 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 1,036kB
32. 4.689 104.063 ↑ 1.0 10,619 1

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

  • Hash Cond: (contract.supplierid = s.supplierid)
33. 8.047 99.315 ↑ 1.0 10,619 1

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

  • Hash Cond: (cdp.contractid = contract.contractid)
34. 7.027 48.095 ↑ 1.0 10,619 1

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

  • Merge Cond: (dp.pointid = cdp.pointid)
35. 19.631 19.631 ↑ 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.019..19.631 rows=8,487 loops=1)

36. 21.437 21.437 ↑ 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.012..21.437 rows=10,619 loops=1)

37. 4.711 43.173 ↑ 1.0 10,404 1

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

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

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

39. 0.002 0.059 ↑ 1.0 2 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
40. 0.057 0.057 ↑ 1.0 2 1

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

41. 90.352 376.669 ↑ 1.0 194,940 1

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

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

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

43. 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 5))
44.          

SubPlan (for Index Scan)

45. 84.167 2,861.678 ↑ 1.0 1 84,167

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

46. 420.835 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.msgdate)::date), ((j_1.creationdate)::date), j_1.fromdate, j_1.powerlimiter, m_2.budgetmeter
  • Sort Method: quicksort Memory: 25kB
47. 237.084 2,356.676 ↓ 2.0 2 84,167

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

48. 142.639 1,599.173 ↓ 2.0 2 84,167

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

49. 589.169 589.169 ↓ 2.0 2 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_1 (cost=0.29..2.91 rows=1 width=25) (actual time=0.005..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
50. 867.365 867.365 ↑ 1.0 1 173,473

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

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

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

  • Index Cond: (j_1.physicalconfigid = physicalconfigid)
52. 84.167 2,861.678 ↑ 1.0 1 84,167

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

53. 420.835 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.msgdate)::date), ((j_1.creationdate)::date), j_1.fromdate, j_1.powerlimiter, m_2.budgetmeter
  • Sort Method: quicksort Memory: 25kB
54. 237.084 2,356.676 ↓ 2.0 2 84,167

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

55. 142.639 1,599.173 ↓ 2.0 2 84,167

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

56. 589.169 589.169 ↓ 2.0 2 84,167

Index Scan using idx_dpconfigjournal_pointid_pk on dpconfigjournal j_1 (cost=0.29..2.91 rows=1 width=25) (actual time=0.005..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
57. 867.365 867.365 ↑ 1.0 1 173,473

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

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

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

  • Index Cond: (j_1.physicalconfigid = physicalconfigid)
59. 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.002..0.003 rows=1 loops=84,167)

  • Index Cond: (dpconfigjid = (SubPlan 7))
60.          

SubPlan (for Index Scan)

61. 0.000 2,861.678 ↑ 1.0 1 84,167

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

62.          

Initplan (for Limit)

63. 168.334 1,262.505 ↑ 1.0 1 84,167

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

64. 43.596 1,094.171 ↓ 1.5 3 84,167

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

65. 336.668 336.668 ↓ 1.5 3 84,167

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

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

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=237,969)

  • Index Cond: (physicalconfigid = j1.physicalconfigid)
  • Heap Fetches: 265,022
67. 336.668 2,861.678 ↑ 1.0 1 84,167

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

  • Sort Key: ((tx_1.msgdate)::date), ((j_2.creationdate)::date), j_2.powerlimiter, m_3.budgetmeter
  • Sort Method: quicksort Memory: 25kB
68. 218.779 2,525.010 ↑ 1.0 1 84,167

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

69. 117.751 2,104.175 ↑ 1.0 1 84,167

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

70. 1,683.340 1,683.340 ↑ 1.0 1 84,167

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

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

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=101,028)

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

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

  • Index Cond: (j_2.physicalconfigid = physicalconfigid)
73. 0.000 2,861.678 ↑ 1.0 1 84,167

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

74.          

Initplan (for Limit)

75. 168.334 1,262.505 ↑ 1.0 1 84,167

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

76. 43.596 1,094.171 ↓ 1.5 3 84,167

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

77. 336.668 336.668 ↓ 1.5 3 84,167

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

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

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=237,969)

  • Index Cond: (physicalconfigid = j1.physicalconfigid)
  • Heap Fetches: 265,022
79. 336.668 2,861.678 ↑ 1.0 1 84,167

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

  • Sort Key: ((tx_1.msgdate)::date), ((j_2.creationdate)::date), j_2.powerlimiter, m_3.budgetmeter
  • Sort Method: quicksort Memory: 25kB
80. 218.779 2,525.010 ↑ 1.0 1 84,167

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

81. 117.751 2,104.175 ↑ 1.0 1 84,167

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

82. 1,683.340 1,683.340 ↑ 1.0 1 84,167

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

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

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=101,028)

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

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

  • Index Cond: (j_2.physicalconfigid = physicalconfigid)
85. 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
86.          

SubPlan (for Nested Loop Left Join)

87. 14.133 6,699.348 ↓ 0.0 0 18,009

Nested Loop (cost=8.47..52.49 rows=1 width=0) (actual time=0.372..0.372 rows=0 loops=18,009)

  • Join Filter: (previousmet.meteringid = i3.meteringid)
88. 2,755.377 6,663.330 ↓ 0.0 0 18,009

Hash Join (cost=8.18..52.10 rows=1 width=8) (actual time=0.350..0.370 rows=0 loops=18,009)

  • Hash Cond: (previousmet.meteringid = m3.meteringid)
89. 3,421.710 3,421.710 ↑ 1.7 1,089 18,009

CTE Scan on previousmet (cost=0.00..36.98 rows=1,849 width=4) (actual time=0.050..0.190 rows=1,089 loops=18,009)

90. 54.027 486.243 ↓ 1.8 11 18,009

Hash (cost=8.10..8.10 rows=6 width=4) (actual time=0.027..0.027 rows=11 loops=18,009)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
91. 44.808 432.216 ↓ 1.8 11 18,009

Nested Loop (cost=0.58..8.10 rows=6 width=4) (actual time=0.010..0.024 rows=11 loops=18,009)

92. 90.045 90.045 ↓ 2.0 2 18,009

Index Scan using idx_contractdpjournal_pointid_pk on contractdpjournal j3 (cost=0.29..2.30 rows=1 width=4) (actual time=0.004..0.005 rows=2 loops=18,009)

  • Index Cond: (pointid = cdp.pointid)
93. 297.363 297.363 ↑ 1.0 7 27,033

Index Scan using idx_metering_contractdpid_2 on metering m3 (cost=0.29..5.73 rows=7 width=8) (actual time=0.005..0.011 rows=7 loops=27,033)

  • Index Cond: (contractdpid = j3.contractdpid)
94. 21.885 21.885 ↓ 0.0 0 4,377

Index Scan using idx_index_meteringid on index i3 (cost=0.29..0.38 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=4,377)

  • Index Cond: (meteringid = m3.meteringid)
  • Filter: (((status)::text = 'A'::text) AND (previousindexdate = i.indexdate))
  • Rows Removed by Filter: 3
95. 0.000 0.000 ↓ 0.0 0

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

96. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (pointid = dp.pointid)
97. 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_1.contractdpid)
  • Heap Fetches: 0
98. 31.626 85.349 ↑ 1.0 61,691 1

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

  • Hash Cond: (p_1.contractdpid = cdp_2.contractdpid)
99. 49.396 49.396 ↑ 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.046..49.396 rows=61,691 loops=1)

100. 1.874 4.327 ↑ 1.0 10,619 1

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

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

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