explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rM9Q : all partitioned

Settings
# exclusive inclusive rows x rows loops node
1. 84.857 86,129.371 ↓ 134.4 29,440 1

Nested Loop (cost=1.69..91,715.47 rows=219 width=218) (actual time=226.206..86,129.371 rows=29,440 loops=1)

  • Join Filter: ((m_point_int_status.m_point)::text = (contract.m_point)::text)
2. 39.497 71,430.370 ↓ 1,281.0 29,464 1

Nested Loop Left Join (cost=1.69..90,233.29 rows=23 width=277) (actual time=222.951..71,430.370 rows=29,464 loops=1)

3. 26.818 62,846.313 ↓ 2,104.6 29,464 1

Nested Loop Left Join (cost=0.84..90,066.87 rows=14 width=273) (actual time=220.636..62,846.313 rows=29,464 loops=1)

4. 45.476 59,913.350 ↓ 4,248.8 16,995 1

Nested Loop Left Join (cost=0.56..88,822.87 rows=4 width=265) (actual time=218.927..59,913.350 rows=16,995 loops=1)

5. 36.144 57,131.679 ↓ 4,248.8 16,995 1

Nested Loop Left Join (cost=0.56..88,719.70 rows=4 width=265) (actual time=216.494..57,131.679 rows=16,995 loops=1)

6. 43.946 41,817.030 ↓ 4,248.8 16,995 1

Nested Loop Left Join (cost=0.56..88,618.34 rows=4 width=248) (actual time=215.966..41,817.030 rows=16,995 loops=1)

7. 44.642 38,917.924 ↓ 4,248.8 16,995 1

Nested Loop (cost=0.28..88,468.07 rows=4 width=240) (actual time=215.824..38,917.924 rows=16,995 loops=1)

  • Join Filter: ((m_point_int_status.m_point)::text = (m_point_read_mode.m_point)::text)
8. 40.133 29,628.002 ↓ 16,995.0 16,995 1

Nested Loop (cost=0.28..88,459.74 rows=1 width=194) (actual time=213.966..29,628.002 rows=16,995 loops=1)

  • Join Filter: ((measurement_point.m_point)::text = (m_point_int_status.m_point)::text)
9. 41.352 19,891.207 ↓ 17,503.0 17,503 1

Nested Loop Left Join (cost=0.28..88,451.59 rows=1 width=155) (actual time=205.178..19,891.207 rows=17,503 loops=1)

10. 27.757 15,981.692 ↓ 17,503.0 17,503 1

Nested Loop (cost=0.00..88,435.57 rows=1 width=147) (actual time=201.564..15,981.692 rows=17,503 loops=1)

11. 4.764 2,403.310 ↓ 985.5 9,855 1

Append (cost=0.00..88,309.05 rows=10 width=93) (actual time=199.359..2,403.310 rows=9,855 loops=1)

12. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on measurement_point (cost=0.00..0.00 rows=1 width=93) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((pod)::text >= 'ES0031300000521054KK0F'::text) AND ((pod)::text < 'ES0031300001901044ZB0F'::text) AND ((status)::text = 'ACTIVE'::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
13. 2,203.114 2,398.545 ↓ 1,095.0 9,855 1

Bitmap Heap Scan on measurement_point_ges_erz_une (cost=1,226.84..88,309.05 rows=9 width=93) (actual time=199.358..2,398.545 rows=9,855 loops=1)

  • Recheck Cond: (((pod)::text >= 'ES0031300000521054KK0F'::text) AND ((pod)::text < 'ES0031300001901044ZB0F'::text))
  • Filter: (((status)::text = 'ACTIVE'::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 31121
  • Heap Blocks: exact=13274
14. 195.431 195.431 ↓ 1.5 41,013 1

Bitmap Index Scan on m_point_pod_ges_erz_une (cost=0.00..1,226.84 rows=28,228 width=0) (actual time=195.431..195.431 rows=41,013 loops=1)

  • Index Cond: (((pod)::text >= 'ES0031300000521054KK0F'::text) AND ((pod)::text < 'ES0031300001901044ZB0F'::text))
15. 59.130 13,550.625 ↑ 1.0 2 9,855

Append (cost=0.00..12.63 rows=2 width=54) (actual time=0.902..1.375 rows=2 loops=9,855)

16. 0.000 0.000 ↓ 0.0 0 9,855

Seq Scan on m_point_meter (cost=0.00..0.00 rows=1 width=54) (actual time=0.000..0.000 rows=0 loops=9,855)

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
17. 13,491.495 13,491.495 ↓ 2.0 2 9,855

Index Scan using mp_meter_m_point_end_reference_ges_erz_une on m_point_meter_ges_erz_une (cost=0.57..12.63 rows=1 width=54) (actual time=0.897..1.369 rows=2 loops=9,855)

  • Index Cond: (((m_point)::text = (measurement_point.m_point)::text) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 0
18. 35.006 3,868.163 ↑ 2.0 1 17,503

Nested Loop (cost=0.28..15.99 rows=2 width=44) (actual time=0.207..0.221 rows=1 loops=17,503)

19. 52.509 3,588.115 ↑ 2.0 1 17,503

Nested Loop (cost=0.00..13.49 rows=2 width=37) (actual time=0.188..0.205 rows=1 loops=17,503)

20. 52.509 1,855.318 ↑ 2.0 1 17,503

Append (cost=0.00..4.58 rows=2 width=50) (actual time=0.105..0.106 rows=1 loops=17,503)

21. 0.000 0.000 ↓ 0.0 0 17,503

Seq Scan on m_point_address mpa (cost=0.00..0.00 rows=1 width=50) (actual time=0.000..0.000 rows=0 loops=17,503)

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
22. 1,802.809 1,802.809 ↑ 1.0 1 17,503

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_1 (cost=0.56..4.58 rows=1 width=50) (actual time=0.102..0.103 rows=1 loops=17,503)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Filter: (substr((m_point)::text, 1, 3) = 'ERZ'::text)
  • Heap Fetches: 0
23. 87.515 1,680.288 ↑ 4.0 1 17,503

Append (cost=0.00..4.41 rows=4 width=15) (actual time=0.081..0.096 rows=1 loops=17,503)

24. 0.000 0.000 ↓ 0.0 0 17,503

Seq Scan on country_division cd (cost=0.00..0.00 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=17,503)

  • Filter: ((zip_code IS NOT NULL) AND ((mpa.country_division)::text = (country_division)::text))
25. 315.054 315.054 ↓ 0.0 0 17,503

Index Only Scan using country_division_view_sev on country_division_sev cd_1 (cost=0.42..1.48 rows=1 width=15) (actual time=0.018..0.018 rows=0 loops=17,503)

  • Index Cond: ((country_division = (mpa.country_division)::text) AND (zip_code IS NOT NULL))
  • Heap Fetches: 0
26. 1,050.180 1,050.180 ↑ 1.0 1 17,503

Index Only Scan using country_division_view_ges_erz_une on country_division_ges_erz_une cd_2 (cost=0.42..1.46 rows=1 width=15) (actual time=0.059..0.060 rows=1 loops=17,503)

  • Index Cond: ((country_division = (mpa.country_division)::text) AND (zip_code IS NOT NULL))
  • Heap Fetches: 16269
27. 227.539 227.539 ↓ 0.0 0 17,503

Index Only Scan using country_division_view_fec on country_division_fec cd_3 (cost=0.42..1.47 rows=1 width=15) (actual time=0.013..0.013 rows=0 loops=17,503)

  • Index Cond: ((country_division = (mpa.country_division)::text) AND (zip_code IS NOT NULL))
  • Heap Fetches: 0
28. 245.042 245.042 ↑ 1.0 1 17,503

Index Only Scan using zip_code_territory_pkey on zip_code_territory tv (cost=0.28..1.24 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=17,503)

  • Index Cond: (zip_code = (cd.zip_code)::text)
  • Heap Fetches: 0
29. 87.515 9,696.662 ↑ 2.0 1 17,503

Append (cost=0.00..8.12 rows=2 width=39) (actual time=0.553..0.554 rows=1 loops=17,503)

30. 0.000 0.000 ↓ 0.0 0 17,503

Seq Scan on m_point_int_status (cost=0.00..0.00 rows=1 width=39) (actual time=0.000..0.000 rows=0 loops=17,503)

  • Filter: (((m_point_meter.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
31. 9,609.147 9,609.147 ↑ 1.0 1 17,503

Index Scan using pk_m_point_int_status_ges_erz_une on m_point_int_status_ges_erz_une (cost=0.56..8.12 rows=1 width=39) (actual time=0.548..0.549 rows=1 loops=17,503)

  • Index Cond: (((m_point)::text = (m_point_meter.m_point)::text) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 0
32. 84.975 9,245.280 ↑ 2.0 1 16,995

Append (cost=0.00..8.31 rows=2 width=46) (actual time=0.533..0.544 rows=1 loops=16,995)

33. 0.000 0.000 ↓ 0.0 0 16,995

Seq Scan on m_point_read_mode (cost=0.00..0.00 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=16,995)

  • Filter: (((m_point_meter.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
34. 9,160.305 9,160.305 ↑ 1.0 1 16,995

Index Scan using pk_m_point_read_mode_ges_erz_une on m_point_read_mode_ges_erz_une (cost=0.56..8.31 rows=1 width=46) (actual time=0.528..0.539 rows=1 loops=16,995)

  • Index Cond: (((m_point)::text = (m_point_meter.m_point)::text) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 0
35. 17.935 2,855.160 ↓ 0.0 0 16,995

Nested Loop (cost=0.28..37.55 rows=2 width=44) (actual time=0.168..0.168 rows=0 loops=16,995)

36. 5.170 2,804.175 ↓ 0.0 0 16,995

Nested Loop (cost=0.00..35.04 rows=2 width=37) (actual time=0.161..0.165 rows=0 loops=16,995)

37. 33.990 2,617.230 ↓ 0.0 0 16,995

Nested Loop (cost=0.00..20.43 rows=2 width=47) (actual time=0.152..0.154 rows=0 loops=16,995)

38. 67.980 1,325.610 ↑ 2.0 1 16,995

Append (cost=0.00..4.58 rows=2 width=50) (actual time=0.076..0.078 rows=1 loops=16,995)

39. 0.000 0.000 ↓ 0.0 0 16,995

Seq Scan on m_point_address mpa_4 (cost=0.00..0.00 rows=1 width=50) (actual time=0.000..0.000 rows=0 loops=16,995)

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
40. 1,257.630 1,257.630 ↑ 1.0 1 16,995

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_5 (cost=0.56..4.58 rows=1 width=50) (actual time=0.074..0.074 rows=1 loops=16,995)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Filter: (substr((m_point)::text, 1, 3) = 'ERZ'::text)
  • Heap Fetches: 0
41. 50.985 1,257.630 ↓ 0.0 0 16,995

Append (cost=0.00..7.88 rows=4 width=24) (actual time=0.072..0.074 rows=0 loops=16,995)

42. 0.000 0.000 ↓ 0.0 0 16,995

Seq Scan on country_division cd_8 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=16,995)

  • Filter: (((zip_code IS NULL) OR ((zip_code)::text = ''::text)) AND ((mpa_4.country_division)::text = (country_division)::text))
43. 254.925 254.925 ↓ 0.0 0 16,995

Index Scan using country_division_view_sev on country_division_sev cd_9 (cost=0.42..2.67 rows=1 width=25) (actual time=0.015..0.015 rows=0 loops=16,995)

  • Index Cond: ((country_division)::text = (mpa_4.country_division)::text)
  • Filter: ((zip_code IS NULL) OR ((zip_code)::text = ''::text))
44. 628.815 628.815 ↓ 0.0 0 16,995

Index Scan using country_division_view_ges_erz_une on country_division_ges_erz_une cd_10 (cost=0.42..2.59 rows=1 width=24) (actual time=0.037..0.037 rows=0 loops=16,995)

  • Index Cond: ((country_division)::text = (mpa_4.country_division)::text)
  • Filter: ((zip_code IS NULL) OR ((zip_code)::text = ''::text))
  • Rows Removed by Filter: 1
45. 322.905 322.905 ↓ 0.0 0 16,995

Index Scan using country_division_view_fec on country_division_fec cd_11 (cost=0.42..2.62 rows=1 width=25) (actual time=0.019..0.019 rows=0 loops=16,995)

  • Index Cond: ((country_division)::text = (mpa_4.country_division)::text)
  • Filter: ((zip_code IS NULL) OR ((zip_code)::text = ''::text))
46. 13.220 181.775 ↑ 4.0 1 3,305

Append (cost=0.00..7.27 rows=4 width=15) (actual time=0.042..0.055 rows=1 loops=3,305)

47. 0.000 0.000 ↓ 0.0 0 3,305

Seq Scan on country_division parent (cost=0.00..0.00 rows=1 width=15) (actual time=0.000..0.000 rows=0 loops=3,305)

  • Filter: (((country_division_type)::text = '2'::text) AND ((cd_8.parent_country_division)::text = (country_division)::text))
48. 26.440 26.440 ↓ 0.0 0 3,305

Index Scan using country_division_view_sev on country_division_sev parent_1 (cost=0.42..2.43 rows=1 width=15) (actual time=0.008..0.008 rows=0 loops=3,305)

  • Index Cond: ((country_division)::text = (cd_8.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
49. 105.760 105.760 ↑ 1.0 1 3,305

Index Scan using country_division_view_ges_erz_une on country_division_ges_erz_une parent_2 (cost=0.42..2.41 rows=1 width=15) (actual time=0.031..0.032 rows=1 loops=3,305)

  • Index Cond: ((country_division)::text = (cd_8.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
50. 36.355 36.355 ↓ 0.0 0 3,305

Index Scan using country_division_view_fec on country_division_fec parent_3 (cost=0.42..2.42 rows=1 width=15) (actual time=0.011..0.011 rows=0 loops=3,305)

  • Index Cond: ((country_division)::text = (cd_8.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
51. 33.050 33.050 ↓ 0.0 0 3,305

Index Only Scan using zip_code_territory_pkey on zip_code_territory tv_2 (cost=0.28..1.25 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=3,305)

  • Index Cond: (zip_code = (parent.zip_code)::text)
  • Heap Fetches: 0
52. 84.975 15,278.505 ↑ 4.0 1 16,995

Append (cost=0.00..25.30 rows=4 width=35) (actual time=0.871..0.899 rows=1 loops=16,995)

53. 0.000 0.000 ↓ 0.0 0 16,995

Seq Scan on meter (cost=0.00..0.00 rows=1 width=35) (actual time=0.000..0.000 rows=0 loops=16,995)

  • Filter: (((m_point_meter.meter)::text = (meter)::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
54. 305.910 305.910 ↓ 0.0 0 16,995

Index Scan using meter_meter_sev on meter_sev (cost=0.56..8.46 rows=1 width=35) (actual time=0.018..0.018 rows=0 loops=16,995)

  • Index Cond: ((m_point_meter.meter)::text = (meter)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
55. 14,462.745 14,462.745 ↑ 1.0 1 16,995

Index Scan using meter_meter_ges_erz_une on meter_ges_erz_une (cost=0.56..8.38 rows=1 width=35) (actual time=0.849..0.851 rows=1 loops=16,995)

  • Index Cond: ((m_point_meter.meter)::text = (meter)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
  • Rows Removed by Filter: 0
56. 424.875 424.875 ↓ 0.0 0 16,995

Index Scan using meter_meter_fec on meter_fec (cost=0.56..8.46 rows=1 width=35) (actual time=0.025..0.025 rows=0 loops=16,995)

  • Index Cond: ((m_point_meter.meter)::text = (meter)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
57. 118.965 2,736.195 ↑ 4.0 1 16,995

Append (cost=0.00..25.75 rows=4 width=20) (actual time=0.133..0.161 rows=1 loops=16,995)

58. 0.000 0.000 ↓ 0.0 0 16,995

Seq Scan on derivation (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=16,995)

  • Filter: (((measurement_point.derivation)::text = (derivation)::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
59. 798.765 798.765 ↓ 0.0 0 16,995

Index Scan using derivation_derivation_sev on derivation_sev (cost=0.56..8.58 rows=1 width=20) (actual time=0.047..0.047 rows=0 loops=16,995)

  • Index Cond: ((measurement_point.derivation)::text = (derivation)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
60. 1,393.590 1,393.590 ↑ 1.0 1 16,995

Index Scan using derivation_derivation_ges_erz_une on derivation_ges_erz_une (cost=0.56..8.58 rows=1 width=20) (actual time=0.081..0.082 rows=1 loops=16,995)

  • Index Cond: ((measurement_point.derivation)::text = (derivation)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
61. 424.875 424.875 ↓ 0.0 0 16,995

Index Scan using derivation_derivation_fec on derivation_fec (cost=0.56..8.58 rows=1 width=20) (actual time=0.025..0.025 rows=0 loops=16,995)

  • Index Cond: ((measurement_point.derivation)::text = (derivation)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference))
62. 47.657 2,906.145 ↑ 7.0 1 16,995

Nested Loop (cost=0.28..310.93 rows=7 width=44) (actual time=0.151..0.171 rows=1 loops=16,995)

63. 33.990 2,634.225 ↑ 9.0 1 16,995

Nested Loop (cost=0.00..299.67 rows=9 width=37) (actual time=0.145..0.155 rows=1 loops=16,995)

64. 67.980 1,291.620 ↑ 2.0 1 16,995

Append (cost=0.00..4.58 rows=2 width=50) (actual time=0.075..0.076 rows=1 loops=16,995)

65. 0.000 0.000 ↓ 0.0 0 16,995

Seq Scan on m_point_address mpa_2 (cost=0.00..0.00 rows=1 width=50) (actual time=0.000..0.000 rows=0 loops=16,995)

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
66. 1,223.640 1,223.640 ↑ 1.0 1 16,995

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_3 (cost=0.56..4.58 rows=1 width=50) (actual time=0.072..0.072 rows=1 loops=16,995)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Filter: (substr((m_point)::text, 1, 3) = 'ERZ'::text)
  • Heap Fetches: 0
67. 118.965 1,308.615 ↑ 146.0 1 16,995

Append (cost=0.00..146.08 rows=146 width=12) (actual time=0.068..0.077 rows=1 loops=16,995)

68. 0.000 0.000 ↓ 0.0 0 16,995

Seq Scan on country_division cd_4 (cost=0.00..0.00 rows=1 width=13) (actual time=0.000..0.000 rows=0 loops=16,995)

  • Filter: ((mpa_2.country_division)::text = (parent_country_division)::text)
69. 16.995 339.900 ↓ 0.0 0 16,995

Bitmap Heap Scan on country_division_sev cd_5 (cost=2.06..75.96 rows=76 width=12) (actual time=0.020..0.020 rows=0 loops=16,995)

  • Recheck Cond: ((parent_country_division)::text = (mpa_2.country_division)::text)
70. 322.905 322.905 ↓ 0.0 0 16,995

Bitmap Index Scan on country_division_parent_sev (cost=0.00..2.04 rows=76 width=0) (actual time=0.019..0.019 rows=0 loops=16,995)

  • Index Cond: ((parent_country_division)::text = (mpa_2.country_division)::text)
71. 526.845 526.845 ↑ 29.0 1 16,995

Index Scan using country_division_parent_ges_erz_une on country_division_ges_erz_une cd_6 (cost=0.42..29.16 rows=29 width=13) (actual time=0.028..0.031 rows=1 loops=16,995)

  • Index Cond: ((parent_country_division)::text = (mpa_2.country_division)::text)
72. 16.995 322.905 ↓ 0.0 0 16,995

Bitmap Heap Scan on country_division_fec cd_7 (cost=1.76..40.97 rows=40 width=12) (actual time=0.019..0.019 rows=0 loops=16,995)

  • Recheck Cond: ((parent_country_division)::text = (mpa_2.country_division)::text)
73. 305.910 305.910 ↓ 0.0 0 16,995

Bitmap Index Scan on country_division_parent_fec (cost=0.00..1.75 rows=40 width=0) (actual time=0.018..0.018 rows=0 loops=16,995)

  • Index Cond: ((parent_country_division)::text = (mpa_2.country_division)::text)
74. 224.263 224.263 ↑ 1.0 1 17,251

Index Only Scan using zip_code_territory_pkey on zip_code_territory tv_1 (cost=0.28..1.24 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=17,251)

  • Index Cond: (zip_code = (cd_4.zip_code)::text)
  • Heap Fetches: 0
75. 59.288 8,544.560 ↑ 3.0 1 29,464

Nested Loop (cost=0.84..11.86 rows=3 width=24) (actual time=0.184..0.290 rows=1 loops=29,464)

76. 7,424.928 7,424.928 ↑ 1.5 2 29,464

Index Scan using in_deriv_group_derivation on pln_deriv_group (cost=0.56..5.46 rows=3 width=28) (actual time=0.125..0.252 rows=2 loops=29,464)

  • Index Cond: ((derivation.derivation)::text = (derivation)::text)
  • Filter: ((end_date IS NULL) AND (start_date <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)))
  • Rows Removed by Filter: 1
77. 1,060.344 1,060.344 ↑ 1.0 1 58,908

Index Scan using pk_group on pln_group (cost=0.28..2.12 rows=1 width=12) (actual time=0.017..0.018 rows=1 loops=58,908)

  • Index Cond: (id_group = pln_deriv_group.id_group)
  • Filter: ((d_planning_type)::text = '1'::text)
  • Rows Removed by Filter: 0
78. 147.320 14,614.144 ↑ 4.0 1 29,464

Append (cost=0.00..64.39 rows=4 width=85) (actual time=0.413..0.496 rows=1 loops=29,464)

79. 0.000 0.000 ↓ 0.0 0 29,464

Seq Scan on contract (cost=0.00..0.00 rows=1 width=85) (actual time=0.000..0.000 rows=0 loops=29,464)

  • Filter: (((m_point_meter.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
80. 707.136 707.136 ↓ 0.0 0 29,464

Index Scan using contract_m_point_sev on contract_sev (cost=0.56..26.23 rows=1 width=85) (actual time=0.024..0.024 rows=0 loops=29,464)

  • Index Cond: ((m_point)::text = (m_point_meter.m_point)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
81. 12,934.696 12,934.696 ↑ 1.0 1 29,464

Index Scan using contract_m_point_ges_erz_une on contract_ges_erz_une (cost=0.56..15.65 rows=1 width=85) (actual time=0.386..0.439 rows=1 loops=29,464)

  • Index Cond: ((m_point)::text = (m_point_meter.m_point)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 1
82. 824.992 824.992 ↓ 0.0 0 29,464

Index Scan using contract_m_point_fec on contract_fec (cost=0.56..22.51 rows=1 width=85) (actual time=0.028..0.028 rows=0 loops=29,464)

  • Index Cond: ((m_point)::text = (m_point_meter.m_point)::text)
  • Filter: ((start_reference <= to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-05-29'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
Planning time : 165.392 ms
Execution time : 86,140.279 ms