explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rCQS

Settings
# exclusive inclusive rows x rows loops node
1. 1,803.300 27,713.360 ↓ 2.0 84,173 1

Nested Loop Left Join (cost=67,725.01..3,388,460.46 rows=42,084 width=217) (actual time=3,921.769..27,713.360 rows=84,173 loops=1)

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

CTE previousmet

3. 125.598 915.308 ↓ 1.2 2,132 1

Merge Anti Join (cost=24,926.04..26,757.83 rows=1,849 width=4) (actual time=765.865..915.308 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))
4. 95.914 452.691 ↓ 2.3 63,890 1

Sort (cost=9,514.67..9,584.81 rows=28,056 width=29) (actual time=441.731..452.691 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
5. 61.646 356.777 ↓ 2.3 63,890 1

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

  • Hash Cond: (m_1.contractdpid = j.contractdpid)
6. 96.155 279.353 ↓ 2.3 63,890 1

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

  • Hash Cond: (i_1.meteringid = m_1.meteringid)
7. 140.783 140.783 ↓ 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.024..140.783 rows=63,890 loops=1)

  • Filter: (previousindexdate < indexdate)
  • Rows Removed by Filter: 20,277
8. 25.158 42.415 ↑ 1.0 68,114 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,661kB
9. 17.257 17.257 ↑ 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..17.257 rows=68,114 loops=1)

10. 6.451 15.778 ↑ 1.0 10,619 1

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

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

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

12. 103.672 337.019 ↑ 1.0 76,473 1

Sort (cost=15,411.37..15,602.92 rows=76,617 width=25) (actual time=324.124..337.019 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
13. 57.196 233.347 ↑ 1.0 76,481 1

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

  • Hash Cond: (metering.contractdpid = contractdpjournal.contractdpid)
14. 57.555 168.540 ↑ 1.0 76,481 1

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

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

16. 67.695 67.695 ↑ 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.016..67.695 rows=76,481 loops=1)

  • Filter: ((status)::text = 'A'::text)
  • Rows Removed by Filter: 7,686
17. 3.889 7.611 ↑ 1.0 10,619 1

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

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

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

19. 3,772.548 11,689.374 ↓ 2.0 84,167 1

Nested Loop Left Join (cost=40,966.88..1,042,616.72 rows=42,084 width=221) (actual time=3,003.352..11,689.374 rows=84,167 loops=1)

  • Join Filter: (dpc.dpconfigjid IS NULL)
  • Rows Removed by Join Filter: 84,166
20. 3,756.098 7,664.325 ↓ 2.0 84,167 1

Nested Loop Left Join (cost=40,951.35..385,928.99 rows=42,084 width=223) (actual time=3,002.717..7,664.325 rows=84,167 loops=1)

21. 114.904 3,571.559 ↓ 2.0 84,167 1

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

  • Hash Cond: (t.envid = msg.envid)
22. 133.654 3,076.898 ↓ 2.0 84,167 1

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

  • Hash Cond: (m.contractdpid = cdp.contractdpid)
23. 275.467 2,722.357 ↓ 2.0 84,167 1

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

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

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

25. 60.276 2,399.594 ↓ 2.0 68,114 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 5,975kB
26. 1,267.206 2,339.318 ↓ 2.0 68,114 1

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

  • Hash Cond: (t.msgid = m.txref)
27. 953.434 953.434 ↑ 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..953.434 rows=564,873 loops=1)

28. 33.652 118.678 ↓ 2.0 68,114 1

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

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

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

  • Filter: (migration IS TRUE)
30. 9.164 220.887 ↑ 1.0 10,619 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 1,036kB
31. 6.806 211.723 ↑ 1.0 10,619 1

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

  • Hash Cond: (contract.supplierid = s.supplierid)
32. 30.034 204.839 ↑ 1.0 10,619 1

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

  • Hash Cond: (cdp.contractid = contract.contractid)
33. 12.696 141.355 ↑ 1.0 10,619 1

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

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

35. 112.158 112.158 ↑ 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.013..112.158 rows=10,619 loops=1)

36. 6.586 33.450 ↑ 1.0 10,404 1

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

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

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

38. 0.003 0.078 ↑ 1.0 2 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
39. 0.075 0.075 ↑ 1.0 2 1

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

40. 95.565 379.757 ↑ 1.0 194,940 1

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

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

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

42. 0.000 336.668 ↑ 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.004 rows=1 loops=84,167)

  • Index Cond: (dpconfigjid = (SubPlan 5))
43.          

SubPlan (for Index Scan)

44. 84.167 3,535.014 ↑ 1.0 1 84,167

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

45. 505.002 3,450.847 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.041..0.041 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
46. 316.112 2,945.845 ↓ 2.0 2 84,167

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

47. 137.500 1,935.841 ↓ 2.0 2 84,167

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

48. 757.503 757.503 ↓ 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.006..0.009 rows=2 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((fromdate <= i.indexdate) AND ((source)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
49. 1,040.838 1,040.838 ↑ 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.006..0.006 rows=1 loops=173,473)

  • Index Cond: (msgid = j_1.txref)
50. 693.892 693.892 ↑ 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.004 rows=1 loops=173,473)

  • Index Cond: (j_1.physicalconfigid = physicalconfigid)
51. 84.167 3,535.014 ↑ 1.0 1 84,167

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

52. 505.002 3,450.847 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.041..0.041 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
53. 316.112 2,945.845 ↓ 2.0 2 84,167

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

54. 137.500 1,935.841 ↓ 2.0 2 84,167

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

55. 757.503 757.503 ↓ 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.006..0.009 rows=2 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((fromdate <= i.indexdate) AND ((source)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
56. 1,040.838 1,040.838 ↑ 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.006..0.006 rows=1 loops=173,473)

  • Index Cond: (msgid = j_1.txref)
57. 693.892 693.892 ↑ 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.004 rows=1 loops=173,473)

  • Index Cond: (j_1.physicalconfigid = physicalconfigid)
58. 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 7))
59.          

SubPlan (for Index Scan)

60. 0.000 3,535.014 ↑ 1.0 1 84,167

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

61.          

Initplan (for Limit)

62. 84.167 1,515.006 ↑ 1.0 1 84,167

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

63. 296.097 1,430.839 ↓ 1.5 3 84,167

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

64. 420.835 420.835 ↓ 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.003..0.005 rows=3 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((source)::text = 'DGO'::text)
65. 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.003..0.003 rows=1 loops=237,969)

  • Index Cond: (physicalconfigid = j1.physicalconfigid)
  • Heap Fetches: 265,022
66. 336.668 3,450.847 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.041..0.041 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
67. 201.918 3,114.179 ↑ 1.0 1 84,167

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

68. 100.890 2,609.177 ↑ 1.0 1 84,167

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

69. 2,104.175 2,104.175 ↑ 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.023..0.025 rows=1 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: (((source)::text = 'DGO'::text) AND (fromdate = $14))
  • Rows Removed by Filter: 2
70. 404.112 404.112 ↑ 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.004 rows=1 loops=101,028)

  • Index Cond: (msgid = j_2.txref)
71. 303.084 303.084 ↑ 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.003 rows=1 loops=101,028)

  • Index Cond: (j_2.physicalconfigid = physicalconfigid)
72. 0.000 3,535.014 ↑ 1.0 1 84,167

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

73.          

Initplan (for Limit)

74. 84.167 1,515.006 ↑ 1.0 1 84,167

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

75. 296.097 1,430.839 ↓ 1.5 3 84,167

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

76. 420.835 420.835 ↓ 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.003..0.005 rows=3 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: ((source)::text = 'DGO'::text)
77. 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.003..0.003 rows=1 loops=237,969)

  • Index Cond: (physicalconfigid = j1.physicalconfigid)
  • Heap Fetches: 265,022
78. 336.668 3,450.847 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.041..0.041 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
79. 201.918 3,114.179 ↑ 1.0 1 84,167

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

80. 100.890 2,609.177 ↑ 1.0 1 84,167

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

81. 2,104.175 2,104.175 ↑ 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.023..0.025 rows=1 loops=84,167)

  • Index Cond: (pointid = dp.pointid)
  • Filter: (((source)::text = 'DGO'::text) AND (fromdate = $14))
  • Rows Removed by Filter: 2
82. 404.112 404.112 ↑ 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.004 rows=1 loops=101,028)

  • Index Cond: (msgid = j_2.txref)
83. 303.084 303.084 ↑ 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.003 rows=1 loops=101,028)

  • Index Cond: (j_2.physicalconfigid = physicalconfigid)
84. 420.835 420.835 ↓ 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.005..0.005 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
85.          

SubPlan (for Nested Loop Left Join)

86. 31.174 13,686.840 ↓ 0.0 0 18,009

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

  • Join Filter: (previousmet.meteringid = i3.meteringid)
87. 6,357.177 13,578.786 ↑ 1.0 1 18,009

Hash Join (cost=8.18..52.10 rows=1 width=8) (actual time=0.718..0.754 rows=1 loops=18,009)

  • Hash Cond: (previousmet.meteringid = m3.meteringid)
88. 6,645.321 6,645.321 ↓ 1.1 2,116 18,009

CTE Scan on previousmet (cost=0.00..36.98 rows=1,849 width=4) (actual time=0.043..0.369 rows=2,116 loops=18,009)

89. 72.036 576.288 ↓ 1.8 11 18,009

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
90. 71.802 504.252 ↓ 1.8 11 18,009

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

91. 108.054 108.054 ↓ 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.005..0.006 rows=2 loops=18,009)

  • Index Cond: (pointid = cdp.pointid)
92. 324.396 324.396 ↑ 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.012 rows=7 loops=27,033)

  • Index Cond: (contractdpid = j3.contractdpid)
93. 76.880 76.880 ↓ 0.0 0 9,610

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

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

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

95. 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)
96. 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
97. 50.865 113.011 ↑ 1.0 61,691 1

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

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

99. 5.504 10.520 ↑ 1.0 10,619 1

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

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

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