explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CSbP

Settings
# exclusive inclusive rows x rows loops node
1. 2,435.124 16,271.691 ↑ 1.4 99,669 1

Sort (cost=8,007,444.53..8,007,791.68 rows=138,859 width=820) (actual time=16,188.809..16,271.691 rows=99,669 loops=1)

  • Sort Key: q."Point Id", q."From date", q."To date
  • Sort Method: external merge Disk: 25,856kB
2. 70.448 13,836.567 ↑ 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,807.184..13,836.567 rows=99,669 loops=1)

3. 27.406 13,766.119 ↑ 1.4 99,669 1

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

4.          

CTE previousmet

5. 0.911 825.435 ↑ 1.7 1,096 1

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

  • Group Key: i_3.meteringid
6. 95.452 824.524 ↓ 1.2 2,132 1

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

Sort (cost=9,514.67..9,584.81 rows=28,056 width=29) (actual time=367.552..376.568 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
8. 53.079 285.336 ↓ 2.3 63,890 1

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

  • Hash Cond: (m_2.contractdpid = j.contractdpid)
9. 83.925 225.502 ↓ 2.3 63,890 1

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

  • Hash Cond: (i_3.meteringid = m_2.meteringid)
10. 113.483 113.483 ↓ 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.043..113.483 rows=63,890 loops=1)

  • Filter: (previousindexdate < indexdate)
  • Rows Removed by Filter: 20,277
11. 14.409 28.094 ↑ 1.0 68,114 1

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

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

13. 3.536 6.755 ↑ 1.0 10,619 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 415kB
14. 3.219 3.219 ↑ 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.219 rows=10,619 loops=1)

15. 84.790 352.504 ↑ 1.0 76,473 1

Sort (cost=15,411.37..15,602.92 rows=76,617 width=25) (actual time=342.176..352.504 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
16. 63.860 267.714 ↑ 1.0 76,481 1

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

  • Hash Cond: (metering.contractdpid = contractdpjournal.contractdpid)
17. 73.136 197.305 ↑ 1.0 76,481 1

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

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

19. 77.220 77.220 ↑ 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.020..77.220 rows=76,481 loops=1)

  • Filter: ((status)::text = 'A'::text)
  • Rows Removed by Filter: 7,686
20. 3.385 6.549 ↑ 1.0 10,619 1

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

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

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

22. 1,538.970 12,345.035 ↓ 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,807.181..12,345.035 rows=84,173 loops=1)

  • Join Filter: (i.previousindexdate = i.indexdate)
  • Rows Removed by Join Filter: 792
23. 3,566.824 9,408.535 ↑ 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,797.018..9,408.535 rows=84,167 loops=1)

  • Join Filter: (dpc.dpconfigjid IS NULL)
  • Rows Removed by Join Filter: 84,166
24. 3,308.689 5,589.210 ↑ 1.0 84,167 1

Nested Loop Left Join (cost=44,754.08..727,475.28 rows=84,167 width=223) (actual time=1,796.724..5,589.210 rows=84,167 loops=1)

25. 204.017 2,028.020 ↑ 1.0 84,167 1

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

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

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

27. 67.540 1,796.029 ↑ 1.0 68,114 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 11,385kB
28. 71.608 1,728.489 ↑ 1.0 68,114 1

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

  • Hash Cond: (t.envid = msg.envid)
29. 84.378 1,362.984 ↑ 1.0 68,114 1

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

  • Hash Cond: (m.contractdpid = cdp.contractdpid)
30. 605.972 1,190.972 ↑ 1.0 68,114 1

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

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

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

32. 29.314 95.545 ↑ 1.0 68,114 1

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

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

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

34. 7.751 87.634 ↑ 1.0 10,619 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 1,036kB
35. 6.373 79.883 ↑ 1.0 10,619 1

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

  • Hash Cond: (contract.supplierid = s.supplierid)
36. 12.067 73.468 ↑ 1.0 10,619 1

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

  • Hash Cond: (cdp.contractid = contract.contractid)
37. 11.034 43.829 ↑ 1.0 10,619 1

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

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

39. 19.796 19.796 ↑ 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.010..19.796 rows=10,619 loops=1)

40. 3.741 17.572 ↑ 1.0 10,404 1

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

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

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

42. 0.002 0.042 ↑ 1.0 2 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
43. 0.040 0.040 ↑ 1.0 2 1

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

44. 87.735 293.897 ↑ 1.0 194,940 1

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

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

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

46. 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))
47.          

SubPlan (for Index Scan)

48. 84.167 3,114.179 ↑ 1.0 1 84,167

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

49. 505.002 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_2.msgdate)::date), ((j_3.creationdate)::date), j_3.fromdate, j_3.powerlimiter, m_5.budgetmeter
  • Sort Method: quicksort Memory: 25kB
50. 321.251 2,525.010 ↓ 2.0 2 84,167

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

51. 226.806 1,683.340 ↓ 2.0 2 84,167

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

52. 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.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
53. 867.365 867.365 ↑ 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.005..0.005 rows=1 loops=173,473)

  • Index Cond: (msgid = j_3.txref)
54. 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)
55. 84.167 3,114.179 ↑ 1.0 1 84,167

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

56. 505.002 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_2.msgdate)::date), ((j_3.creationdate)::date), j_3.fromdate, j_3.powerlimiter, m_5.budgetmeter
  • Sort Method: quicksort Memory: 25kB
57. 321.251 2,525.010 ↓ 2.0 2 84,167

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

58. 226.806 1,683.340 ↓ 2.0 2 84,167

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

59. 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.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
60. 867.365 867.365 ↑ 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.005..0.005 rows=1 loops=173,473)

  • Index Cond: (msgid = j_3.txref)
61. 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)
62. 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))
63.          

SubPlan (for Index Scan)

64. 0.000 3,366.680 ↑ 1.0 1 84,167

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

65.          

Initplan (for Limit)

66. 84.167 1,430.839 ↑ 1.0 1 84,167

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

67. 211.930 1,346.672 ↓ 1.5 3 84,167

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

68. 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)
69. 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.003..0.003 rows=1 loops=237,969)

  • Index Cond: (physicalconfigid = j1_1.physicalconfigid)
  • Heap Fetches: 265,022
70. 336.668 3,282.513 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.039..0.039 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
71. 201.918 2,945.845 ↑ 1.0 1 84,167

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

72. 16.723 2,440.843 ↑ 1.0 1 84,167

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

73. 2,020.008 2,020.008 ↑ 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.022..0.024 rows=1 loops=84,167)

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

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

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

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

77.          

Initplan (for Limit)

78. 84.167 1,430.839 ↑ 1.0 1 84,167

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

79. 211.930 1,346.672 ↓ 1.5 3 84,167

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

80. 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)
81. 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.003..0.003 rows=1 loops=237,969)

  • Index Cond: (physicalconfigid = j1_1.physicalconfigid)
  • Heap Fetches: 265,022
82. 336.668 3,282.513 ↑ 1.0 1 84,167

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.039..0.039 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
83. 201.918 2,945.845 ↑ 1.0 1 84,167

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

84. 16.723 2,440.843 ↑ 1.0 1 84,167

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

85. 2,020.008 2,020.008 ↑ 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.022..0.024 rows=1 loops=84,167)

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

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

  • Index Cond: (j_4.physicalconfigid = physicalconfigid)
88. 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
89.          

SubPlan (for Nested Loop Left Join)

90. 0.000 0.000 ↓ 0.0 0

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

91. 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)
92. 0.000 0.000 ↓ 0.0 0

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

  • Group Key: previousmet_1.meteringid
93. 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)

94. 0.000 0.000 ↓ 0.0 0

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

95. 0.000 0.000 ↓ 0.0 0

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

96. 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)
97. 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)
98. 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))
99. 0.984 871.675 ↑ 22.4 1,710 1

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

  • Hash Cond: (m3_1.contractdpid = j3_1.contractdpid)
100. 1.340 858.801 ↑ 22.4 1,710 1

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

  • Hash Cond: (i3_1.meteringid = m3_1.meteringid)
101. 0.524 832.288 ↑ 22.4 1,710 1

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

102. 0.560 826.284 ↓ 5.5 1,096 1

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

  • Group Key: previousmet_2.meteringid
103. 825.724 825.724 ↑ 1.7 1,096 1

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

104. 5.480 5.480 ↑ 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.004..0.005 rows=2 loops=1,096)

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

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

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

107. 3.826 11.890 ↑ 1.0 10,619 1

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

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

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

109. 0.000 0.000 ↓ 0.0 0

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

110. 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)
111. 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
112. 50.984 105.020 ↑ 1.0 61,691 1

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

  • Hash Cond: (p_3.contractdpid = cdp_6.contractdpid)
113. 49.547 49.547 ↑ 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.027..49.547 rows=61,691 loops=1)

114. 2.072 4.489 ↑ 1.0 10,619 1

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

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

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

116. 1.787 1,253.601 ↑ 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=707.971..1,253.601 rows=2,728 loops=1)

117. 68.354 1,251.814 ↑ 15.4 2,728 1

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

  • Join Filter: (i_1.previousindexdate = i_1.indexdate)
  • Rows Removed by Join Filter: 44
118. 121.153 1,121.712 ↑ 15.4 2,728 1

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

  • Join Filter: (dpc_1.dpconfigjid IS NULL)
  • Rows Removed by Join Filter: 2,728
119. 107.320 989.647 ↑ 15.4 2,728 1

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

120. 18.517 874.143 ↑ 15.4 2,728 1

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

  • Hash Cond: (m_1.meteringid = previousmet.meteringid)
121. 117.632 854.677 ↓ 1.0 84,080 1

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

  • Hash Cond: (i_1.meteringid = m_1.meteringid)
122. 30.385 30.385 ↓ 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.032..30.385 rows=84,080 loops=1)

  • Filter: ((previousindexdate IS NOT NULL) AND (previousindex IS NOT NULL))
  • Rows Removed by Filter: 87
123. 44.708 706.660 ↑ 1.0 68,114 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 11,168kB
124. 49.629 661.952 ↑ 1.0 68,114 1

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

  • Hash Cond: (t_1.envid = msg_1.envid)
125. 47.758 488.705 ↑ 1.0 68,114 1

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

  • Hash Cond: (m_1.contractdpid = cdp_1.contractdpid)
126. 267.844 397.903 ↑ 1.0 68,114 1

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

  • Hash Cond: (t_1.msgid = m_1.txref)
127. 89.878 89.878 ↑ 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..89.878 rows=564,873 loops=1)

128. 18.323 40.181 ↑ 1.0 68,114 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 3,438kB
129. 21.858 21.858 ↑ 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..21.858 rows=68,114 loops=1)

130. 5.196 43.044 ↑ 1.0 10,619 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 995kB
131. 4.723 37.848 ↑ 1.0 10,619 1

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

  • Hash Cond: (contract_1.supplierid = s_1.supplierid)
132. 6.911 33.120 ↑ 1.0 10,619 1

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

  • Hash Cond: (cdp_1.contractid = contract_1.contractid)
133. 7.492 21.169 ↑ 1.0 10,619 1

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

  • Merge Cond: (dp_1.pointid = cdp_1.pointid)
134. 5.468 5.468 ↑ 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..5.468 rows=8,487 loops=1)

135. 8.209 8.209 ↑ 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.008..8.209 rows=10,619 loops=1)

136. 2.207 5.040 ↑ 1.0 10,404 1

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

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

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

138. 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
139. 0.004 0.004 ↑ 1.0 2 1

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

140. 56.143 123.618 ↑ 1.0 194,940 1

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 10,849kB
141. 67.475 67.475 ↑ 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.006..67.475 rows=194,940 loops=1)

142. 0.209 0.949 ↓ 5.5 1,096 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
143. 0.599 0.740 ↓ 5.5 1,096 1

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

  • Group Key: previousmet.meteringid
144. 0.141 0.141 ↑ 1.7 1,096 1

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

145. 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))
146.          

SubPlan (for Index Scan)

147. 2.728 100.936 ↑ 1.0 1 2,728

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

148. 16.368 98.208 ↑ 1.0 1 2,728

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.036..0.036 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
149. 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)

150. 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.010..0.019 rows=2 loops=2,728)

151. 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
152. 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)
153. 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)
154. 2.728 100.936 ↑ 1.0 1 2,728

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

155. 16.368 98.208 ↑ 1.0 1 2,728

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.036..0.036 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
156. 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)

157. 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.010..0.019 rows=2 loops=2,728)

158. 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
159. 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)
160. 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)
161. 0.000 10.912 ↑ 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.004 rows=1 loops=2,728)

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

SubPlan (for Index Scan)

163. 0.000 117.304 ↑ 1.0 1 2,728

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

164.          

Initplan (for Limit)

165. 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)

166. 6.667 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)

167. 13.640 13.640 ↓ 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.005 rows=4 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: ((source)::text = 'DGO'::text)
168. 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.003..0.003 rows=1 loops=9,599)

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

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.042..0.042 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
170. 6.168 103.664 ↑ 1.0 1 2,728

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

171. 2.768 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)

172. 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
173. 13.600 13.600 ↑ 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.004 rows=1 loops=3,400)

  • Index Cond: (msgid = j_2.txref)
174. 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)
175. 0.000 117.304 ↑ 1.0 1 2,728

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

176.          

Initplan (for Limit)

177. 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)

178. 6.667 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)

179. 13.640 13.640 ↓ 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.005 rows=4 loops=2,728)

  • Index Cond: (pointid = dp_1.pointid)
  • Filter: ((source)::text = 'DGO'::text)
180. 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.003..0.003 rows=1 loops=9,599)

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

Sort (cost=7.69..7.70 rows=1 width=26) (actual time=0.042..0.042 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
182. 6.168 103.664 ↑ 1.0 1 2,728

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

183. 2.768 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)

184. 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
185. 13.600 13.600 ↑ 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.004 rows=1 loops=3,400)

  • Index Cond: (msgid = j_2.txref)
186. 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)
187. 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
188.          

SubPlan (for Nested Loop Left Join)

189. 0.000 0.000 ↓ 0.0 0

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

190. 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)
191. 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
192. 30.425 45.380 ↑ 1.0 61,691 1

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

  • Hash Cond: (p_1.contractdpid = cdp_4.contractdpid)
193. 9.298 9.298 ↑ 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.004..9.298 rows=61,691 loops=1)

194. 3.000 5.657 ↑ 1.0 10,619 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 415kB
195. 2.657 2.657 ↑ 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.657 rows=10,619 loops=1)

196. 5.592 140.077 ↓ 1.0 12,768 1

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

197. 84.637 134.485 ↓ 1.0 12,768 1

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

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

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

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

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 839kB
200. 4.665 36.690 ↑ 1.0 10,619 1

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

  • Hash Cond: (contract_2.supplierid = s_2.supplierid)
201. 6.152 32.020 ↑ 1.0 10,619 1

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

  • Hash Cond: (cdp_2.contractid = contract_2.contractid)
202. 6.517 20.162 ↑ 1.0 10,619 1

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

  • Merge Cond: (dp_2.pointid = cdp_2.pointid)
203. 5.503 5.503 ↑ 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.503 rows=8,487 loops=1)

204. 8.142 8.142 ↑ 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.009..8.142 rows=10,619 loops=1)

205. 2.784 5.706 ↑ 1.0 10,404 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 407kB
206. 2.922 2.922 ↑ 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.922 rows=10,404 loops=1)

207. 0.002 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
208. 0.003 0.003 ↑ 1.0 2 1

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