explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ipd : all with cost

Settings
# exclusive inclusive rows x rows loops node
1. 146.123 756,555.575 ↑ 6.3 30,315 1

Nested Loop Left Join (cost=1.69..4,301,859.16 rows=192,077 width=218) (actual time=489.886..756,555.575 rows=30,315 loops=1)

2. 66.015 658,492.002 ↓ 1.5 30,315 1

Nested Loop Left Join (cost=1.69..2,889,587.40 rows=20,195 width=169) (actual time=489.688..658,492.002 rows=30,315 loops=1)

3. 76.579 566,510.907 ↓ 2.5 30,315 1

Nested Loop Left Join (cost=0.84..2,743,227.47 rows=12,313 width=165) (actual time=489.526..566,510.907 rows=30,315 loops=1)

4. 76.889 489,491.063 ↓ 4.9 17,507 1

Nested Loop Left Join (cost=0.56..502,663.49 rows=3,584 width=157) (actual time=489.086..489,491.063 rows=17,507 loops=1)

5. 73.449 426,616.565 ↓ 4.9 17,507 1

Nested Loop Left Join (cost=0.56..410,223.17 rows=3,584 width=157) (actual time=488.927..426,616.565 rows=17,507 loops=1)

6. 77.897 334,631.366 ↓ 4.9 17,507 1

Nested Loop Left Join (cost=0.56..379,597.41 rows=3,584 width=140) (actual time=488.805..334,631.366 rows=17,507 loops=1)

7. 62.141 225,222.254 ↓ 4.9 17,507 1

Nested Loop Left Join (cost=0.28..108,996.24 rows=3,584 width=132) (actual time=476.387..225,222.254 rows=17,507 loops=1)

8. 50.364 148,285.370 ↓ 38.8 9,857 1

Nested Loop Left Join (cost=0.28..90,143.63 rows=254 width=114) (actual time=461.239..148,285.370 rows=9,857 loops=1)

9. 37.567 93,725.796 ↓ 209.7 9,857 1

Nested Loop Left Join (cost=0.28..88,926.33 rows=47 width=104) (actual time=461.027..93,725.796 rows=9,857 loops=1)

10. 34.084 51,341.294 ↓ 985.5 9,855 1

Nested Loop Left Join (cost=0.28..88,667.83 rows=10 width=101) (actual time=460.798..51,341.294 rows=9,855 loops=1)

11. 7.575 22,471.480 ↓ 985.5 9,855 1

Append (cost=0.00..88,309.05 rows=10 width=93) (actual time=460.344..22,471.480 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. 22,009.559 22,463.904 ↓ 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=460.342..22,463.904 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. 454.345 454.345 ↓ 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=454.345..454.345 rows=41,013 loops=1)

  • Index Cond: (((pod)::text >= 'ES0031300000521054KK0F'::text) AND ((pod)::text < 'ES0031300001901044ZB0F'::text))
15. 49.275 28,835.730 ↑ 3.0 1 9,855

Nested Loop (cost=0.28..35.85 rows=3 width=44) (actual time=2.323..2.926 rows=1 loops=9,855)

16. 49.275 26,480.385 ↑ 4.0 1 9,855

Nested Loop (cost=0.00..30.84 rows=4 width=37) (actual time=1.896..2.687 rows=1 loops=9,855)

17. 88.695 16,024.230 ↑ 4.0 1 9,855

Append (cost=0.00..13.73 rows=4 width=50) (actual time=1.271..1.626 rows=1 loops=9,855)

18. 9.855 9.855 ↓ 0.0 0 9,855

Seq Scan on m_point_address mpa (cost=0.00..0.00 rows=1 width=50) (actual time=0.001..0.001 rows=0 loops=9,855)

  • Filter: ((measurement_point.m_point)::text = (m_point)::text)
19. 5,390.685 5,390.685 ↓ 0.0 0 9,855

Index Only Scan using pk_m_point_address_sev on m_point_address_sev mpa_1 (cost=0.56..4.58 rows=1 width=50) (actual time=0.547..0.547 rows=0 loops=9,855)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
20. 7,085.745 7,085.745 ↑ 1.0 1 9,855

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_2 (cost=0.56..4.58 rows=1 width=50) (actual time=0.717..0.719 rows=1 loops=9,855)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
21. 3,449.250 3,449.250 ↓ 0.0 0 9,855

Index Only Scan using pk_m_point_address_fec on m_point_address_fec mpa_3 (cost=0.56..4.58 rows=1 width=50) (actual time=0.350..0.350 rows=0 loops=9,855)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
22. 88.695 10,406.880 ↑ 4.0 1 9,855

Append (cost=0.00..4.24 rows=4 width=15) (actual time=0.621..1.056 rows=1 loops=9,855)

23. 9.855 9.855 ↓ 0.0 0 9,855

Seq Scan on country_division cd (cost=0.00..0.00 rows=1 width=15) (actual time=0.001..0.001 rows=0 loops=9,855)

  • Filter: ((zip_code IS NOT NULL) AND ((mpa.country_division)::text = (country_division)::text))
24. 1,980.855 1,980.855 ↓ 0.0 0 9,855

Index Only Scan using country_division_view_sev on country_division_sev cd_1 (cost=0.42..1.41 rows=1 width=15) (actual time=0.201..0.201 rows=0 loops=9,855)

  • Index Cond: ((country_division = (mpa.country_division)::text) AND (zip_code IS NOT NULL))
  • Heap Fetches: 0
25. 4,089.825 4,089.825 ↑ 1.0 1 9,855

Index Only Scan using country_division_view_ges_erz_une on country_division_ges_erz_une cd_2 (cost=0.42..1.41 rows=1 width=15) (actual time=0.413..0.415 rows=1 loops=9,855)

  • Index Cond: ((country_division = (mpa.country_division)::text) AND (zip_code IS NOT NULL))
  • Heap Fetches: 9149
26. 4,237.650 4,237.650 ↓ 0.0 0 9,855

Index Only Scan using country_division_view_fec on country_division_fec cd_3 (cost=0.42..1.41 rows=1 width=15) (actual time=0.430..0.430 rows=0 loops=9,855)

  • Index Cond: ((country_division = (mpa.country_division)::text) AND (zip_code IS NOT NULL))
  • Heap Fetches: 0
27. 2,306.070 2,306.070 ↑ 1.0 1 9,855

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.232..0.234 rows=1 loops=9,855)

  • Index Cond: (zip_code = (cd.zip_code)::text)
  • Heap Fetches: 0
28. 177.390 42,346.935 ↑ 4.0 1 9,855

Append (cost=0.00..25.81 rows=4 width=39) (actual time=3.722..4.297 rows=1 loops=9,855)

29. 0.000 0.000 ↓ 0.0 0 9,855

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=9,855)

  • Filter: (((m_point)::text = (measurement_point.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))
30. 2,611.575 2,611.575 ↓ 0.0 0 9,855

Index Scan using pk_m_point_int_status_sev on m_point_int_status_sev (cost=0.56..8.61 rows=1 width=39) (actual time=0.265..0.265 rows=0 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))
31. 34,945.830 34,945.830 ↑ 1.0 1 9,855

Index Scan using pk_m_point_int_status_ges_erz_une on m_point_int_status_ges_erz_une (cost=0.56..8.60 rows=1 width=39) (actual time=3.368..3.546 rows=1 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))
  • Rows Removed by Filter: 0
32. 4,612.140 4,612.140 ↓ 0.0 0 9,855

Index Scan using pk_m_point_int_status_fec on m_point_int_status_fec (cost=0.56..8.61 rows=1 width=39) (actual time=0.468..0.468 rows=0 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))
33. 157.712 54,509.210 ↑ 4.0 1 9,857

Append (cost=0.00..25.86 rows=4 width=46) (actual time=5.189..5.530 rows=1 loops=9,857)

34. 9.857 9.857 ↓ 0.0 0 9,857

Seq Scan on m_point_read_mode (cost=0.00..0.00 rows=1 width=46) (actual time=0.001..0.001 rows=0 loops=9,857)

  • 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))
35. 14,785.500 14,785.500 ↓ 0.0 0 9,857

Index Scan using pk_m_point_read_mode_sev on m_point_read_mode_sev (cost=0.56..8.62 rows=1 width=46) (actual time=1.500..1.500 rows=0 loops=9,857)

  • Index Cond: (((measurement_point.m_point)::text = (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))
36. 36,924.322 36,924.322 ↑ 1.0 1 9,857

Index Scan using pk_m_point_read_mode_ges_erz_une on m_point_read_mode_ges_erz_une (cost=0.56..8.63 rows=1 width=46) (actual time=3.676..3.746 rows=1 loops=9,857)

  • Index Cond: (((measurement_point.m_point)::text = (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))
  • Rows Removed by Filter: 0
37. 2,631.819 2,631.819 ↓ 0.0 0 9,857

Index Scan using pk_m_point_read_mode_fec on m_point_read_mode_fec (cost=0.56..8.61 rows=1 width=46) (actual time=0.267..0.267 rows=0 loops=9,857)

  • Index Cond: (((measurement_point.m_point)::text = (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))
38. 187.283 76,874.743 ↑ 8.5 2 9,857

Append (cost=0.00..74.05 rows=17 width=54) (actual time=5.707..7.799 rows=2 loops=9,857)

39. 9.857 9.857 ↓ 0.0 0 9,857

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

  • 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))
40. 9,354.293 9,354.293 ↓ 0.0 0 9,857

Index Scan using mp_meter_m_point_end_reference_sev on m_point_meter_sev (cost=0.57..30.55 rows=7 width=54) (actual time=0.949..0.949 rows=0 loops=9,857)

  • Index Cond: (((measurement_point.m_point)::text = (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))
41. 64,701.348 64,701.348 ↑ 1.0 2 9,857

Index Scan using mp_meter_m_point_end_reference_ges_erz_une on m_point_meter_ges_erz_une (cost=0.57..12.62 rows=2 width=54) (actual time=4.745..6.564 rows=2 loops=9,857)

  • Index Cond: (((measurement_point.m_point)::text = (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))
  • Rows Removed by Filter: 0
42. 2,621.962 2,621.962 ↓ 0.0 0 9,857

Index Scan using mp_meter_m_point_end_reference_fec on m_point_meter_fec (cost=0.57..30.89 rows=7 width=54) (actual time=0.266..0.266 rows=0 loops=9,857)

  • Index Cond: (((measurement_point.m_point)::text = (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))
43. 30.744 109,331.215 ↓ 0.0 0 17,507

Nested Loop (cost=0.28..75.48 rows=2 width=44) (actual time=6.245..6.245 rows=0 loops=17,507)

44. 39.711 107,370.431 ↓ 0.0 0 17,507

Nested Loop (cost=0.00..71.72 rows=3 width=37) (actual time=5.643..6.133 rows=0 loops=17,507)

45. 87.535 101,120.432 ↓ 0.0 0 17,507

Nested Loop (cost=0.00..42.50 rows=4 width=47) (actual time=5.376..5.776 rows=0 loops=17,507)

46. 157.563 45,588.228 ↑ 4.0 1 17,507

Append (cost=0.00..13.73 rows=4 width=50) (actual time=2.315..2.604 rows=1 loops=17,507)

47. 17.507 17.507 ↓ 0.0 0 17,507

Seq Scan on m_point_address mpa_8 (cost=0.00..0.00 rows=1 width=50) (actual time=0.001..0.001 rows=0 loops=17,507)

  • Filter: ((measurement_point.m_point)::text = (m_point)::text)
48. 17,594.535 17,594.535 ↓ 0.0 0 17,507

Index Only Scan using pk_m_point_address_sev on m_point_address_sev mpa_9 (cost=0.56..4.58 rows=1 width=50) (actual time=1.005..1.005 rows=0 loops=17,507)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
49. 22,864.142 22,864.142 ↑ 1.0 1 17,507

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_10 (cost=0.56..4.58 rows=1 width=50) (actual time=1.303..1.306 rows=1 loops=17,507)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
50. 4,954.481 4,954.481 ↓ 0.0 0 17,507

Index Only Scan using pk_m_point_address_fec on m_point_address_fec mpa_11 (cost=0.56..4.58 rows=1 width=50) (actual time=0.283..0.283 rows=0 loops=17,507)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
51. 157.563 55,444.669 ↓ 0.0 0 17,507

Append (cost=0.00..7.15 rows=4 width=24) (actual time=2.808..3.167 rows=0 loops=17,507)

52. 0.000 0.000 ↓ 0.0 0 17,507

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=17,507)

  • Filter: (((zip_code IS NULL) OR ((zip_code)::text = ''::text)) AND ((mpa_8.country_division)::text = (country_division)::text))
53. 7,422.968 7,422.968 ↓ 0.0 0 17,507

Index Scan using country_division_view_sev on country_division_sev cd_9 (cost=0.42..2.38 rows=1 width=25) (actual time=0.424..0.424 rows=0 loops=17,507)

  • Index Cond: ((country_division)::text = (mpa_8.country_division)::text)
  • Filter: ((zip_code IS NULL) OR ((zip_code)::text = ''::text))
54. 13,462.883 13,462.883 ↓ 0.0 0 17,507

Index Scan using country_division_view_ges_erz_une on country_division_ges_erz_une cd_10 (cost=0.42..2.38 rows=1 width=24) (actual time=0.769..0.769 rows=0 loops=17,507)

  • Index Cond: ((country_division)::text = (mpa_8.country_division)::text)
  • Filter: ((zip_code IS NULL) OR ((zip_code)::text = ''::text))
  • Rows Removed by Filter: 1
55. 34,401.255 34,401.255 ↓ 0.0 0 17,507

Index Scan using pk_country_division_fec on country_division_fec cd_11 (cost=0.42..2.38 rows=1 width=25) (actual time=1.965..1.965 rows=0 loops=17,507)

  • Index Cond: ((country_division)::text = (mpa_8.country_division)::text)
  • Filter: ((zip_code IS NULL) OR ((zip_code)::text = ''::text))
56. 27.328 6,210.288 ↑ 4.0 1 3,416

Append (cost=0.00..7.27 rows=4 width=15) (actual time=1.355..1.818 rows=1 loops=3,416)

57. 0.000 0.000 ↓ 0.0 0 3,416

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,416)

  • Filter: (((country_division_type)::text = '2'::text) AND ((cd_8.parent_country_division)::text = (country_division)::text))
58. 245.952 245.952 ↓ 0.0 0 3,416

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.072..0.072 rows=0 loops=3,416)

  • Index Cond: ((country_division)::text = (cd_8.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
59. 4,365.648 4,365.648 ↑ 1.0 1 3,416

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=1.278..1.278 rows=1 loops=3,416)

  • Index Cond: ((country_division)::text = (cd_8.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
60. 1,571.360 1,571.360 ↓ 0.0 0 3,416

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.460..0.460 rows=0 loops=3,416)

  • Index Cond: ((country_division)::text = (cd_8.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
61. 1,930.040 1,930.040 ↓ 0.0 0 3,416

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.565..0.565 rows=0 loops=3,416)

  • Index Cond: (zip_code = (parent.zip_code)::text)
  • Heap Fetches: 0
62. 175.070 91,911.750 ↑ 4.0 1 17,507

Append (cost=0.00..8.51 rows=4 width=35) (actual time=4.503..5.250 rows=1 loops=17,507)

63. 0.000 0.000 ↓ 0.0 0 17,507

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

  • 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))
64. 17,542.014 17,542.014 ↓ 0.0 0 17,507

Index Scan using meter_meter_sev on meter_sev (cost=0.56..2.88 rows=1 width=35) (actual time=1.002..1.002 rows=0 loops=17,507)

  • 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))
65. 61,414.556 61,414.556 ↑ 1.0 1 17,507

Index Scan using meter_meter_ges_erz_une on meter_ges_erz_une (cost=0.56..2.76 rows=1 width=35) (actual time=3.493..3.508 rows=1 loops=17,507)

  • 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
66. 12,780.110 12,780.110 ↓ 0.0 0 17,507

Index Scan using meter_meter_fec on meter_fec (cost=0.56..2.87 rows=1 width=35) (actual time=0.730..0.730 rows=0 loops=17,507)

  • 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))
67. 192.577 62,797.609 ↑ 4.0 1 17,507

Append (cost=0.00..25.75 rows=4 width=20) (actual time=2.807..3.587 rows=1 loops=17,507)

68. 17.507 17.507 ↓ 0.0 0 17,507

Seq Scan on derivation (cost=0.00..0.00 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=17,507)

  • 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))
69. 31,407.558 31,407.558 ↓ 0.0 0 17,507

Index Scan using derivation_derivation_sev on derivation_sev (cost=0.56..8.58 rows=1 width=20) (actual time=1.794..1.794 rows=0 loops=17,507)

  • 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))
70. 17,664.563 17,664.563 ↑ 1.0 1 17,507

Index Scan using derivation_derivation_ges_erz_une on derivation_ges_erz_une (cost=0.56..8.58 rows=1 width=20) (actual time=1.004..1.009 rows=1 loops=17,507)

  • 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))
71. 13,515.404 13,515.404 ↓ 0.0 0 17,507

Index Scan using derivation_derivation_fec on derivation_fec (cost=0.56..8.58 rows=1 width=20) (actual time=0.772..0.772 rows=0 loops=17,507)

  • 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))
72. 47.005 76,943.265 ↑ 14.0 1 17,507

Nested Loop (cost=0.28..625.02 rows=14 width=44) (actual time=4.002..4.395 rows=1 loops=17,507)

73. 122.549 73,476.879 ↑ 18.0 1 17,507

Nested Loop (cost=0.00..602.49 rows=18 width=37) (actual time=3.919..4.197 rows=1 loops=17,507)

74. 157.563 44,030.105 ↑ 4.0 1 17,507

Append (cost=0.00..13.73 rows=4 width=50) (actual time=1.837..2.515 rows=1 loops=17,507)

75. 0.000 0.000 ↓ 0.0 0 17,507

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=17,507)

  • Filter: ((measurement_point.m_point)::text = (m_point)::text)
76. 16,561.622 16,561.622 ↓ 0.0 0 17,507

Index Only Scan using pk_m_point_address_sev on m_point_address_sev mpa_5 (cost=0.56..4.58 rows=1 width=50) (actual time=0.946..0.946 rows=0 loops=17,507)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
77. 15,528.709 15,528.709 ↑ 1.0 1 17,507

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_6 (cost=0.56..4.58 rows=1 width=50) (actual time=0.885..0.887 rows=1 loops=17,507)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
78. 11,782.211 11,782.211 ↓ 0.0 0 17,507

Index Only Scan using pk_m_point_address_fec on m_point_address_fec mpa_7 (cost=0.56..4.58 rows=1 width=50) (actual time=0.673..0.673 rows=0 loops=17,507)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Heap Fetches: 0
79. 175.070 29,324.225 ↑ 146.0 1 17,507

Append (cost=0.00..145.73 rows=146 width=12) (actual time=1.498..1.675 rows=1 loops=17,507)

80. 0.000 0.000 ↓ 0.0 0 17,507

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=17,507)

  • Filter: ((mpa_4.country_division)::text = (parent_country_division)::text)
81. 52.521 4,621.848 ↓ 0.0 0 17,507

Bitmap Heap Scan on country_division_sev cd_5 (cost=1.98..75.88 rows=76 width=12) (actual time=0.264..0.264 rows=0 loops=17,507)

  • Recheck Cond: ((parent_country_division)::text = (mpa_4.country_division)::text)
82. 4,569.327 4,569.327 ↓ 0.0 0 17,507

Bitmap Index Scan on country_division_parent_sev (cost=0.00..1.96 rows=76 width=0) (actual time=0.261..0.261 rows=0 loops=17,507)

  • Index Cond: ((parent_country_division)::text = (mpa_4.country_division)::text)
83. 11,729.690 11,729.690 ↑ 29.0 1 17,507

Index Scan using country_division_parent_ges_erz_une on country_division_ges_erz_une cd_6 (cost=0.42..28.94 rows=29 width=13) (actual time=0.604..0.670 rows=1 loops=17,507)

  • Index Cond: ((parent_country_division)::text = (mpa_4.country_division)::text)
84. 35.014 12,797.617 ↓ 0.0 0 17,507

Bitmap Heap Scan on country_division_fec cd_7 (cost=1.70..40.91 rows=40 width=12) (actual time=0.731..0.731 rows=0 loops=17,507)

  • Recheck Cond: ((parent_country_division)::text = (mpa_4.country_division)::text)
85. 12,762.603 12,762.603 ↓ 0.0 0 17,507

Bitmap Index Scan on country_division_parent_fec (cost=0.00..1.69 rows=40 width=0) (actual time=0.729..0.729 rows=0 loops=17,507)

  • Index Cond: ((parent_country_division)::text = (mpa_4.country_division)::text)
86. 3,419.381 3,419.381 ↑ 1.0 1 17,717

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.192..0.193 rows=1 loops=17,717)

  • Index Cond: (zip_code = (cd_4.zip_code)::text)
  • Heap Fetches: 0
87. 134.124 91,915.080 ↑ 3.0 1 30,315

Nested Loop (cost=0.84..11.86 rows=3 width=24) (actual time=2.100..3.032 rows=1 loops=30,315)

88. 59,296.140 59,296.140 ↑ 1.5 2 30,315

Index Scan using in_deriv_group_derivation on pln_deriv_group (cost=0.56..5.46 rows=3 width=28) (actual time=1.262..1.956 rows=2 loops=30,315)

  • 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
89. 32,484.816 32,484.816 ↑ 1.0 1 60,606

Index Scan using pk_group on pln_group (cost=0.28..2.12 rows=1 width=12) (actual time=0.523..0.536 rows=1 loops=60,606)

  • Index Cond: (id_group = pln_deriv_group.id_group)
  • Filter: ((d_planning_type)::text = '1'::text)
  • Rows Removed by Filter: 0
90. 272.835 97,917.450 ↑ 4.0 1 30,315

Append (cost=0.00..69.89 rows=4 width=85) (actual time=2.296..3.230 rows=1 loops=30,315)

91. 0.000 0.000 ↓ 0.0 0 30,315

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

  • 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))
92. 30.315 13,156.710 ↓ 0.0 0 30,315

Bitmap Heap Scan on contract_sev (cost=4.61..28.69 rows=1 width=85) (actual time=0.434..0.434 rows=0 loops=30,315)

  • Recheck Cond: ((measurement_point.m_point)::text = (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))
93. 13,126.395 13,126.395 ↓ 0.0 0 30,315

Bitmap Index Scan on contract_m_point_sev (cost=0.00..4.61 rows=6 width=0) (actual time=0.433..0.433 rows=0 loops=30,315)

  • Index Cond: ((measurement_point.m_point)::text = (m_point)::text)
94. 62,842.995 62,842.995 ↑ 1.0 1 30,315

Index Scan using contract_m_point_ges_erz_une on contract_ges_erz_une (cost=0.56..16.58 rows=1 width=85) (actual time=1.855..2.073 rows=1 loops=30,315)

  • Index Cond: ((measurement_point.m_point)::text = (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))
  • Rows Removed by Filter: 1
95. 21,644.910 21,644.910 ↓ 0.0 0 30,315

Index Scan using contract_m_point_fec on contract_fec (cost=0.56..24.62 rows=1 width=85) (actual time=0.714..0.714 rows=0 loops=30,315)

  • Index Cond: ((measurement_point.m_point)::text = (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))
Planning time : 293.158 ms
Execution time : 756,567.415 ms