explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J7m

Settings
# exclusive inclusive rows x rows loops node
1. 48.225 207,040.131 ↓ 29,842.0 29,842 1

Nested Loop Left Join (cost=1.69..88,726.64 rows=1 width=218) (actual time=213.643..207,040.131 rows=29,842 loops=1)

2. 46.537 146,233.594 ↓ 29,842.0 29,842 1

Nested Loop (cost=0.84..88,701.85 rows=1 width=214) (actual time=208.566..146,233.594 rows=29,842 loops=1)

  • Join Filter: ((m_point_int_status.m_point)::text = (contract.m_point)::text)
3. 37.312 125,827.311 ↓ 29,853.0 29,853 1

Nested Loop (cost=0.84..88,686.13 rows=1 width=273) (actual time=208.440..125,827.311 rows=29,853 loops=1)

4. 23.935 106,168.037 ↓ 29,866.0 29,866 1

Nested Loop Left Join (cost=0.84..88,677.71 rows=1 width=256) (actual time=208.371..106,168.037 rows=29,866 loops=1)

5. 26.929 88,306.912 ↓ 17,234.0 17,234 1

Nested Loop Left Join (cost=0.56..88,545.78 rows=1 width=248) (actual time=208.274..88,306.912 rows=17,234 loops=1)

6. 28.965 64,565.999 ↓ 17,234.0 17,234 1

Nested Loop (cost=0.28..88,500.66 rows=1 width=240) (actual time=208.165..64,565.999 rows=17,234 loops=1)

7. 33.718 56,281.948 ↓ 4,308.5 17,234 1

Nested Loop (cost=0.28..88,466.22 rows=4 width=240) (actual time=208.102..56,281.948 rows=17,234 loops=1)

  • Join Filter: ((m_point_int_status.m_point)::text = (m_point_read_mode.m_point)::text)
8. 39.823 45,321.874 ↓ 17,234.0 17,234 1

Nested Loop (cost=0.28..88,457.88 rows=1 width=194) (actual time=206.953..45,321.874 rows=17,234 loops=1)

  • Join Filter: ((measurement_point.m_point)::text = (m_point_int_status.m_point)::text)
9. 23.417 35,542.242 ↓ 17,741.0 17,741 1

Nested Loop Left Join (cost=0.28..88,449.72 rows=1 width=155) (actual time=205.010..35,542.242 rows=17,741 loops=1)

10. 23.439 11,568.475 ↓ 17,741.0 17,741 1

Nested Loop (cost=0.00..88,435.57 rows=1 width=147) (actual time=204.902..11,568.475 rows=17,741 loops=1)

11. 4.336 3,308.332 ↓ 999.6 9,996 1

Append (cost=0.00..88,309.05 rows=10 width=93) (actual time=204.834..3,308.332 rows=9,996 loops=1)

12. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on measurement_point (cost=0.00..0.00 rows=1 width=93) (actual time=0.000..0.000 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-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
13. 3,102.294 3,303.996 ↓ 1,110.7 9,996 1

Bitmap Heap Scan on measurement_point_ges_erz_une (cost=1,226.84..88,309.05 rows=9 width=93) (actual time=204.834..3,303.996 rows=9,996 loops=1)

  • Recheck Cond: (((pod)::text >= 'ES0031300000521054KK0F'::text) AND ((pod)::text < 'ES0031300001901044ZB0F'::text))
  • Filter: (((status)::text = 'ACTIVE'::text) AND (start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 30980
  • Heap Blocks: exact=13274
14. 201.702 201.702 ↓ 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=201.702..201.702 rows=41,013 loops=1)

  • Index Cond: (((pod)::text >= 'ES0031300000521054KK0F'::text) AND ((pod)::text < 'ES0031300001901044ZB0F'::text))
15. 49.980 8,236.704 ↑ 1.0 2 9,996

Append (cost=0.00..12.63 rows=2 width=54) (actual time=0.716..0.824 rows=2 loops=9,996)

16. 0.000 0.000 ↓ 0.0 0 9,996

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

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
17. 8,186.724 8,186.724 ↓ 2.0 2 9,996

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.712..0.819 rows=2 loops=9,996)

  • Index Cond: (((m_point)::text = (measurement_point.m_point)::text) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference))
  • Filter: ((start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
18. 35.482 23,950.350 ↑ 1.0 1 17,741

Nested Loop (cost=0.28..14.13 rows=1 width=44) (actual time=1.346..1.350 rows=1 loops=17,741)

19. 35.482 19,444.136 ↑ 1.0 1 17,741

Nested Loop (cost=0.00..12.82 rows=1 width=38) (actual time=1.092..1.096 rows=1 loops=17,741)

20. 35.482 11,478.427 ↑ 2.0 1 17,741

Append (cost=0.00..4.59 rows=2 width=50) (actual time=0.646..0.647 rows=1 loops=17,741)

21. 0.000 0.000 ↓ 0.0 0 17,741

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

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
22. 11,442.945 11,442.945 ↑ 1.0 1 17,741

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_1 (cost=0.56..4.59 rows=1 width=50) (actual time=0.643..0.645 rows=1 loops=17,741)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Filter: ((substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
  • Heap Fetches: 0
23. 53.223 7,930.227 ↑ 2.0 1 17,741

Append (cost=0.00..4.10 rows=2 width=15) (actual time=0.445..0.447 rows=1 loops=17,741)

24. 0.000 0.000 ↓ 0.0 0 17,741

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

  • Filter: ((zip_code IS NOT NULL) AND ((mpa.country_division)::text = (country_division)::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
25. 7,877.004 7,877.004 ↑ 1.0 1 17,741

Index Only Scan using country_division_view_ges_erz_une on country_division_ges_erz_une cd_1 (cost=0.42..4.10 rows=1 width=15) (actual time=0.443..0.444 rows=1 loops=17,741)

  • Index Cond: ((country_division = (mpa.country_division)::text) AND (zip_code IS NOT NULL))
  • Filter: (substr((country_division)::text, 1, 3) = 'ERZ'::text)
  • Heap Fetches: 16487
26. 4,470.732 4,470.732 ↑ 1.0 1 17,741

Index Only Scan using zip_code_territory_pkey on zip_code_territory tv (cost=0.28..1.30 rows=1 width=8) (actual time=0.251..0.252 rows=1 loops=17,741)

  • Index Cond: (zip_code = (cd.zip_code)::text)
  • Heap Fetches: 0
27. 70.964 9,739.809 ↑ 2.0 1 17,741

Append (cost=0.00..8.14 rows=2 width=39) (actual time=0.546..0.549 rows=1 loops=17,741)

28. 0.000 0.000 ↓ 0.0 0 17,741

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

  • Filter: (((m_point_meter.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
29. 9,668.845 9,668.845 ↑ 1.0 1 17,741

Index Scan using pk_m_point_int_status_ges_erz_une on m_point_int_status_ges_erz_une (cost=0.56..8.14 rows=1 width=39) (actual time=0.542..0.545 rows=1 loops=17,741)

  • Index Cond: (((m_point)::text = (m_point_meter.m_point)::text) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference))
  • Filter: ((start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
30. 68.936 10,926.356 ↑ 2.0 1 17,234

Append (cost=0.00..8.32 rows=2 width=46) (actual time=0.627..0.634 rows=1 loops=17,234)

31. 0.000 0.000 ↓ 0.0 0 17,234

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

  • Filter: (((m_point_meter.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
32. 10,857.420 10,857.420 ↑ 1.0 1 17,234

Index Scan using pk_m_point_read_mode_ges_erz_une on m_point_read_mode_ges_erz_une (cost=0.56..8.32 rows=1 width=46) (actual time=0.624..0.630 rows=1 loops=17,234)

  • Index Cond: (((m_point)::text = (m_point_meter.m_point)::text) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference))
  • Filter: ((start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 0
33. 34.468 8,255.086 ↑ 2.0 1 17,234

Append (cost=0.00..8.59 rows=2 width=20) (actual time=0.475..0.479 rows=1 loops=17,234)

34. 0.000 0.000 ↓ 0.0 0 17,234

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

  • Filter: (((measurement_point.derivation)::text = (derivation)::text) AND (start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((derivation)::text, 1, 3) = 'ERZ'::text))
35. 8,220.618 8,220.618 ↑ 1.0 1 17,234

Index Scan using derivation_derivation_ges_erz_une on derivation_ges_erz_une (cost=0.56..8.59 rows=1 width=20) (actual time=0.472..0.477 rows=1 loops=17,234)

  • Index Cond: ((derivation)::text = (measurement_point.derivation)::text)
  • Filter: ((start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((derivation)::text, 1, 3) = 'ERZ'::text))
36. 12.524 23,713.984 ↓ 0.0 0 17,234

Nested Loop (cost=0.28..45.11 rows=1 width=44) (actual time=1.376..1.376 rows=0 loops=17,234)

37. 18.570 22,231.860 ↓ 0.0 0 17,234

Nested Loop (cost=0.00..43.85 rows=1 width=37) (actual time=1.189..1.290 rows=0 loops=17,234)

38. 34.468 16,458.470 ↓ 0.0 0 17,234

Nested Loop (cost=0.00..20.62 rows=1 width=47) (actual time=0.954..0.955 rows=0 loops=17,234)

39. 34.468 9,857.848 ↑ 2.0 1 17,234

Append (cost=0.00..4.59 rows=2 width=50) (actual time=0.569..0.572 rows=1 loops=17,234)

40. 0.000 0.000 ↓ 0.0 0 17,234

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

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
41. 9,823.380 9,823.380 ↑ 1.0 1 17,234

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_5 (cost=0.56..4.59 rows=1 width=50) (actual time=0.567..0.570 rows=1 loops=17,234)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Filter: ((substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
  • Heap Fetches: 0
42. 34.468 6,566.154 ↓ 0.0 0 17,234

Append (cost=0.00..8.00 rows=2 width=24) (actual time=0.381..0.381 rows=0 loops=17,234)

43. 0.000 0.000 ↓ 0.0 0 17,234

Seq Scan on country_division cd_4 (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=17,234)

  • Filter: (((zip_code IS NULL) OR ((zip_code)::text = ''::text)) AND ((mpa_4.country_division)::text = (country_division)::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
44. 6,531.686 6,531.686 ↓ 0.0 0 17,234

Index Scan using country_division_view_ges_erz_une on country_division_ges_erz_une cd_5 (cost=0.42..8.00 rows=1 width=24) (actual time=0.379..0.379 rows=0 loops=17,234)

  • Index Cond: ((country_division)::text = (mpa_4.country_division)::text)
  • Filter: (((zip_code IS NULL) OR ((zip_code)::text = ''::text)) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 1
45. 16.700 5,754.820 ↑ 4.0 1 3,340

Append (cost=0.00..23.19 rows=4 width=15) (actual time=1.203..1.723 rows=1 loops=3,340)

46. 0.000 0.000 ↓ 0.0 0 3,340

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

  • Filter: (((country_division_type)::text = '2'::text) AND ((cd_4.parent_country_division)::text = (country_division)::text))
47. 581.160 581.160 ↓ 0.0 0 3,340

Index Scan using country_division_view_sev on country_division_sev parent_1 (cost=0.42..7.84 rows=1 width=15) (actual time=0.174..0.174 rows=0 loops=3,340)

  • Index Cond: ((country_division)::text = (cd_4.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
48. 3,426.840 3,426.840 ↑ 1.0 1 3,340

Index Scan using country_division_view_ges_erz_une on country_division_ges_erz_une parent_2 (cost=0.42..7.60 rows=1 width=15) (actual time=1.025..1.026 rows=1 loops=3,340)

  • Index Cond: ((country_division)::text = (cd_4.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
49. 1,730.120 1,730.120 ↓ 0.0 0 3,340

Index Scan using country_division_view_fec on country_division_fec parent_3 (cost=0.42..7.74 rows=1 width=15) (actual time=0.518..0.518 rows=0 loops=3,340)

  • Index Cond: ((country_division)::text = (cd_4.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
50. 1,469.600 1,469.600 ↓ 0.0 0 3,340

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.440..0.440 rows=0 loops=3,340)

  • Index Cond: (zip_code = (parent.zip_code)::text)
  • Heap Fetches: 0
51. 45.370 17,837.190 ↑ 1.0 1 17,234

Nested Loop (cost=0.28..131.92 rows=1 width=44) (actual time=0.815..1.035 rows=1 loops=17,234)

52. 17.234 14,821.240 ↑ 1.0 1 17,234

Nested Loop (cost=0.00..130.63 rows=1 width=38) (actual time=0.764..0.860 rows=1 loops=17,234)

53. 51.702 6,014.666 ↑ 2.0 1 17,234

Append (cost=0.00..4.59 rows=2 width=50) (actual time=0.347..0.349 rows=1 loops=17,234)

54. 0.000 0.000 ↓ 0.0 0 17,234

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

  • Filter: (((measurement_point.m_point)::text = (m_point)::text) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
55. 5,962.964 5,962.964 ↑ 1.0 1 17,234

Index Only Scan using pk_m_point_address_ges_erz_une on m_point_address_ges_erz_une mpa_3 (cost=0.56..4.59 rows=1 width=50) (actual time=0.345..0.346 rows=1 loops=17,234)

  • Index Cond: (m_point = (measurement_point.m_point)::text)
  • Filter: ((substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
  • Heap Fetches: 0
56. 34.468 8,789.340 ↑ 2.0 1 17,234

Append (cost=0.00..63.00 rows=2 width=13) (actual time=0.415..0.510 rows=1 loops=17,234)

57. 0.000 0.000 ↓ 0.0 0 17,234

Seq Scan on country_division cd_2 (cost=0.00..0.00 rows=1 width=13) (actual time=0.000..0.000 rows=0 loops=17,234)

  • Filter: (((mpa_2.country_division)::text = (parent_country_division)::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
58. 8,754.872 8,754.872 ↑ 1.0 1 17,234

Index Scan using country_division_parent_ges_erz_une on country_division_ges_erz_une cd_3 (cost=0.42..63.00 rows=1 width=13) (actual time=0.413..0.508 rows=1 loops=17,234)

  • Index Cond: ((parent_country_division)::text = (mpa_2.country_division)::text)
  • Filter: (substr((country_division)::text, 1, 3) = 'ERZ'::text)
59. 2,970.580 2,970.580 ↑ 1.0 1 17,474

Index Only Scan using zip_code_territory_pkey on zip_code_territory tv_1 (cost=0.28..1.28 rows=1 width=8) (actual time=0.170..0.170 rows=1 loops=17,474)

  • Index Cond: (zip_code = (cd_2.zip_code)::text)
  • Heap Fetches: 0
60. 59.732 19,621.962 ↑ 2.0 1 29,866

Append (cost=0.00..8.40 rows=2 width=35) (actual time=0.655..0.657 rows=1 loops=29,866)

61. 0.000 0.000 ↓ 0.0 0 29,866

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

  • Filter: (((m_point_meter.meter)::text = (meter)::text) AND (start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((meter)::text, 1, 3) = 'ERZ'::text))
62. 19,562.230 19,562.230 ↑ 1.0 1 29,866

Index Scan using meter_meter_ges_erz_une on meter_ges_erz_une (cost=0.56..8.40 rows=1 width=35) (actual time=0.653..0.655 rows=1 loops=29,866)

  • Index Cond: ((meter)::text = (m_point_meter.meter)::text)
  • Filter: ((start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((meter)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 0
63. 59.706 20,359.746 ↑ 2.0 1 29,853

Append (cost=0.00..15.69 rows=2 width=85) (actual time=0.648..0.682 rows=1 loops=29,853)

64. 0.000 0.000 ↓ 0.0 0 29,853

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

  • Filter: (((m_point_meter.m_point)::text = (m_point)::text) AND (start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((contract)::text, 1, 3) = 'ERZ'::text))
65. 20,300.040 20,300.040 ↑ 1.0 1 29,853

Index Scan using contract_m_point_ges_erz_une on contract_ges_erz_une (cost=0.56..15.69 rows=1 width=85) (actual time=0.646..0.680 rows=1 loops=29,853)

  • Index Cond: ((m_point)::text = (m_point_meter.m_point)::text)
  • Filter: ((start_reference <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)) AND (to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text) <= end_reference) AND (substr((m_point)::text, 1, 3) = 'ERZ'::text) AND (substr((contract)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 1
66. 89.526 60,758.312 ↑ 3.0 1 29,842

Nested Loop (cost=0.84..24.77 rows=3 width=24) (actual time=1.631..2.036 rows=1 loops=29,842)

67. 33,751.302 33,751.302 ↑ 1.5 2 29,842

Index Scan using in_deriv_group_derivation on pln_deriv_group (cost=0.56..18.37 rows=3 width=28) (actual time=0.957..1.131 rows=2 loops=29,842)

  • Index Cond: ((derivation.derivation)::text = (derivation)::text)
  • Filter: ((end_date IS NULL) AND (start_date <= to_timestamp('2019-06-10'::text, 'YYYY-MM-DD'::text)))
  • Rows Removed by Filter: 1
68. 26,917.484 26,917.484 ↓ 0.0 0 59,684

Index Scan using pk_group on pln_group (cost=0.28..2.12 rows=1 width=12) (actual time=0.450..0.451 rows=0 loops=59,684)

  • Index Cond: (id_group = pln_deriv_group.id_group)
  • Filter: ((d_planning_type)::text = '1'::text)
  • Rows Removed by Filter: 0