explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h72E

Settings
# exclusive inclusive rows x rows loops node
1. 16.911 12,656.403 ↓ 29,436.0 29,436 1

Nested Loop Left Join (cost=1.69..88,726.59 rows=1 width=218) (actual time=87.763..12,656.403 rows=29,436 loops=1)

2. 33.247 11,432.616 ↓ 29,436.0 29,436 1

Nested Loop (cost=0.84..88,701.79 rows=1 width=214) (actual time=87.684..11,432.616 rows=29,436 loops=1)

  • Join Filter: ((m_point_int_status.m_point)::text = (contract.m_point)::text)
3. 12.827 9,720.890 ↓ 29,447.0 29,447 1

Nested Loop (cost=0.84..88,686.10 rows=1 width=273) (actual time=87.610..9,720.890 rows=29,447 loops=1)

4. 16.106 8,234.863 ↓ 29,464.0 29,464 1

Nested Loop Left Join (cost=0.84..88,677.69 rows=1 width=256) (actual time=87.554..8,234.863 rows=29,464 loops=1)

5. 21.004 7,114.082 ↓ 16,995.0 16,995 1

Nested Loop Left Join (cost=0.56..88,545.76 rows=1 width=248) (actual time=87.485..7,114.082 rows=16,995 loops=1)

6. 7.366 5,937.418 ↓ 16,995.0 16,995 1

Nested Loop (cost=0.28..88,500.64 rows=1 width=240) (actual time=87.387..5,937.418 rows=16,995 loops=1)

7. 17.020 5,454.192 ↓ 4,248.8 16,995 1

Nested Loop (cost=0.28..88,466.20 rows=4 width=240) (actual time=87.324..5,454.192 rows=16,995 loops=1)

  • Join Filter: ((m_point_int_status.m_point)::text = (m_point_read_mode.m_point)::text)
8. 24.548 4,468.457 ↓ 16,995.0 16,995 1

Nested Loop (cost=0.28..88,457.86 rows=1 width=194) (actual time=87.215..4,468.457 rows=16,995 loops=1)

  • Join Filter: ((measurement_point.m_point)::text = (m_point_int_status.m_point)::text)
9. 22.049 3,481.244 ↓ 17,503.0 17,503 1

Nested Loop Left Join (cost=0.28..88,449.72 rows=1 width=155) (actual time=86.899..3,481.244 rows=17,503 loops=1)

10. 11.914 2,181.476 ↓ 17,503.0 17,503 1

Nested Loop (cost=0.00..88,435.57 rows=1 width=147) (actual time=86.734..2,181.476 rows=17,503 loops=1)

11. 2.079 937.687 ↓ 985.5 9,855 1

Append (cost=0.00..88,309.05 rows=10 width=93) (actual time=86.623..937.687 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. 852.164 935.607 ↓ 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=86.622..935.607 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. 83.443 83.443 ↓ 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=83.443..83.443 rows=41,013 loops=1)

  • Index Cond: (((pod)::text >= 'ES0031300000521054KK0F'::text) AND ((pod)::text < 'ES0031300001901044ZB0F'::text))
15. 19.710 1,231.875 ↑ 1.0 2 9,855

Append (cost=0.00..12.63 rows=2 width=54) (actual time=0.096..0.125 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. 1,212.165 1,212.165 ↓ 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.094..0.123 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. 17.503 1,277.719 ↑ 1.0 1 17,503

Nested Loop (cost=0.28..14.13 rows=1 width=44) (actual time=0.072..0.073 rows=1 loops=17,503)

19. 17.503 1,155.198 ↑ 1.0 1 17,503

Nested Loop (cost=0.00..12.82 rows=1 width=38) (actual time=0.065..0.066 rows=1 loops=17,503)

20. 17.503 787.635 ↑ 2.0 1 17,503

Append (cost=0.00..4.59 rows=2 width=50) (actual time=0.045..0.045 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) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
22. 770.132 770.132 ↑ 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.59 rows=1 width=50) (actual time=0.044..0.044 rows=1 loops=17,503)

  • 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. 17.503 350.060 ↑ 2.0 1 17,503

Append (cost=0.00..4.10 rows=2 width=15) (actual time=0.019..0.020 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) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
25. 332.557 332.557 ↑ 1.0 1 17,503

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.018..0.019 rows=1 loops=17,503)

  • 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: 16269
26. 105.018 105.018 ↑ 1.0 1 17,503

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.006..0.006 rows=1 loops=17,503)

  • Index Cond: (zip_code = (cd.zip_code)::text)
  • Heap Fetches: 0
27. 35.006 962.665 ↑ 2.0 1 17,503

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

28. 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))
29. 927.659 927.659 ↑ 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.053..0.053 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
30. 33.990 968.715 ↑ 2.0 1 16,995

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

31. 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))
32. 934.725 934.725 ↑ 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.054..0.055 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
33. 33.990 475.860 ↑ 2.0 1 16,995

Append (cost=0.00..8.59 rows=2 width=20) (actual time=0.027..0.028 rows=1 loops=16,995)

34. 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) AND (substr((derivation)::text, 1, 3) = 'ERZ'::text))
35. 441.870 441.870 ↑ 1.0 1 16,995

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.026..0.026 rows=1 loops=16,995)

  • Index Cond: ((derivation)::text = (measurement_point.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) AND (substr((derivation)::text, 1, 3) = 'ERZ'::text))
36. 0.000 1,155.660 ↓ 0.0 0 16,995

Nested Loop (cost=0.28..45.11 rows=1 width=44) (actual time=0.068..0.068 rows=0 loops=16,995)

37. 16.510 1,155.660 ↓ 0.0 0 16,995

Nested Loop (cost=0.00..43.85 rows=1 width=37) (actual time=0.066..0.068 rows=0 loops=16,995)

38. 0.000 1,036.695 ↓ 0.0 0 16,995

Nested Loop (cost=0.00..20.62 rows=1 width=47) (actual time=0.061..0.061 rows=0 loops=16,995)

39. 16.995 730.785 ↑ 2.0 1 16,995

Append (cost=0.00..4.59 rows=2 width=50) (actual time=0.042..0.043 rows=1 loops=16,995)

40. 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) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
41. 713.790 713.790 ↑ 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.59 rows=1 width=50) (actual time=0.041..0.042 rows=1 loops=16,995)

  • 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. 16.995 305.910 ↓ 0.0 0 16,995

Append (cost=0.00..8.00 rows=2 width=24) (actual time=0.018..0.018 rows=0 loops=16,995)

43. 0.000 0.000 ↓ 0.0 0 16,995

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=16,995)

  • 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. 288.915 288.915 ↓ 0.0 0 16,995

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.017..0.017 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)) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 1
45. 6.610 102.455 ↑ 4.0 1 3,305

Append (cost=0.00..23.19 rows=4 width=15) (actual time=0.024..0.031 rows=1 loops=3,305)

46. 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_4.parent_country_division)::text = (country_division)::text))
47. 23.135 23.135 ↓ 0.0 0 3,305

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.007..0.007 rows=0 loops=3,305)

  • Index Cond: ((country_division)::text = (cd_4.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
48. 52.880 52.880 ↑ 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..7.60 rows=1 width=15) (actual time=0.015..0.016 rows=1 loops=3,305)

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

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.006..0.006 rows=0 loops=3,305)

  • Index Cond: ((country_division)::text = (cd_4.parent_country_division)::text)
  • Filter: ((country_division_type)::text = '2'::text)
50. 6.610 6.610 ↓ 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.002..0.002 rows=0 loops=3,305)

  • Index Cond: (zip_code = (parent.zip_code)::text)
  • Heap Fetches: 0
51. 15.459 1,104.675 ↑ 1.0 1 16,995

Nested Loop (cost=0.28..131.92 rows=1 width=44) (actual time=0.058..0.065 rows=1 loops=16,995)

52. 16.995 985.710 ↑ 1.0 1 16,995

Nested Loop (cost=0.00..130.63 rows=1 width=38) (actual time=0.056..0.058 rows=1 loops=16,995)

53. 16.995 696.795 ↑ 2.0 1 16,995

Append (cost=0.00..4.59 rows=2 width=50) (actual time=0.040..0.041 rows=1 loops=16,995)

54. 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) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
55. 679.800 679.800 ↑ 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.59 rows=1 width=50) (actual time=0.039..0.040 rows=1 loops=16,995)

  • 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. 16.995 271.920 ↑ 2.0 1 16,995

Append (cost=0.00..63.00 rows=2 width=13) (actual time=0.015..0.016 rows=1 loops=16,995)

57. 0.000 0.000 ↓ 0.0 0 16,995

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=16,995)

  • Filter: (((mpa_2.country_division)::text = (parent_country_division)::text) AND (substr((country_division)::text, 1, 3) = 'ERZ'::text))
58. 254.925 254.925 ↑ 1.0 1 16,995

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.014..0.015 rows=1 loops=16,995)

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

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.006..0.006 rows=1 loops=17,251)

  • Index Cond: (zip_code = (cd_2.zip_code)::text)
  • Heap Fetches: 0
60. 29.464 1,473.200 ↑ 2.0 1 29,464

Append (cost=0.00..8.39 rows=2 width=35) (actual time=0.049..0.050 rows=1 loops=29,464)

61. 0.000 0.000 ↓ 0.0 0 29,464

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

  • 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) AND (substr((meter)::text, 1, 3) = 'ERZ'::text))
62. 1,443.736 1,443.736 ↑ 1.0 1 29,464

Index Scan using meter_meter_ges_erz_une on meter_ges_erz_une (cost=0.56..8.39 rows=1 width=35) (actual time=0.048..0.049 rows=1 loops=29,464)

  • Index Cond: ((meter)::text = (m_point_meter.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) AND (substr((meter)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 0
63. 29.447 1,678.479 ↑ 2.0 1 29,447

Append (cost=0.00..15.67 rows=2 width=85) (actual time=0.056..0.057 rows=1 loops=29,447)

64. 0.000 0.000 ↓ 0.0 0 29,447

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

  • 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) AND (substr((contract)::text, 1, 3) = 'ERZ'::text))
65. 1,649.032 1,649.032 ↑ 1.0 1 29,447

Index Scan using contract_m_point_ges_erz_une on contract_ges_erz_une (cost=0.56..15.67 rows=1 width=85) (actual time=0.055..0.056 rows=1 loops=29,447)

  • 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) AND (substr((contract)::text, 1, 3) = 'ERZ'::text))
  • Rows Removed by Filter: 1
66. 29.508 1,206.876 ↑ 3.0 1 29,436

Nested Loop (cost=0.84..24.77 rows=3 width=24) (actual time=0.034..0.041 rows=1 loops=29,436)

67. 941.952 941.952 ↑ 1.5 2 29,436

Index Scan using in_deriv_group_derivation on pln_deriv_group (cost=0.56..18.37 rows=3 width=28) (actual time=0.027..0.032 rows=2 loops=29,436)

  • 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: 0
68. 235.416 235.416 ↑ 1.0 1 58,854

Index Scan using pk_group on pln_group (cost=0.28..2.12 rows=1 width=12) (actual time=0.003..0.004 rows=1 loops=58,854)

  • Index Cond: (id_group = pln_deriv_group.id_group)
  • Filter: ((d_planning_type)::text = '1'::text)
  • Rows Removed by Filter: 0
Planning time : 148.158 ms
Execution time : 12,661.220 ms