explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OC4

Settings
# exclusive inclusive rows x rows loops node
1. 5.429 4,826.404 ↓ 3.6 8,736 1

Sort (cost=14,949.93..14,955.93 rows=2,400 width=18) (actual time=4,824.814..4,826.404 rows=8,736 loops=1)

  • Sort Key: ts.ts
  • Sort Method: quicksort Memory: 1067kB
  • Buffers: shared hit=76 read=6767 dirtied=191
2. 6.608 4,820.975 ↓ 3.6 8,736 1

HashAggregate (cost=14,779.19..14,815.19 rows=2,400 width=18) (actual time=4,818.735..4,820.975 rows=8,736 loops=1)

  • Group Key: ts.ts, lat_lon_hrrr.station_id, (CASE WHEN (t1.binary_precipflag IS NULL) THEN 0 ELSE (t1.binary_precipflag)::integer END)::smallint
  • Buffers: shared hit=76 read=6767 dirtied=191
3. 5.916 4,814.367 ↑ 1.3 8,736 1

Merge Left Join (cost=14,397.45..14,692.83 rows=11,515 width=18) (actual time=4,805.919..4,814.367 rows=8,736 loops=1)

  • Merge Cond: (ts.ts = ((t1."timestamp")::timestamp without time zone))
  • Join Filter: (lat_lon_hrrr.station_id = t1.station_id)
  • Buffers: shared hit=76 read=6767 dirtied=191
4. 4.505 11.782 ↓ 8.7 8,736 1

Sort (cost=74.28..76.78 rows=1,000 width=16) (actual time=9.952..11.782 rows=8,736 loops=1)

  • Sort Key: ts.ts
  • Sort Method: quicksort Memory: 794kB
  • Buffers: shared hit=5 read=2
5. 3.405 7.277 ↓ 8.7 8,736 1

Nested Loop (cost=0.43..24.45 rows=1,000 width=16) (actual time=2.165..7.277 rows=8,736 loops=1)

  • Buffers: shared hit=5 read=2
6. 1.302 1.302 ↑ 1.0 1 1

Index Only Scan using hrrr_station_idx on lat_lon_hrrr (cost=0.43..4.45 rows=1 width=8) (actual time=1.300..1.302 rows=1 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Heap Fetches: 1
  • Buffers: shared hit=5 read=2
7. 2.570 2.570 ↓ 8.7 8,736 1

Function Scan on generate_series ts (cost=0.00..10.00 rows=1,000 width=8) (actual time=0.861..2.570 rows=8,736 loops=1)

8. 3.758 4,796.669 ↓ 1.3 2,945 1

Sort (cost=14,323.17..14,328.93 rows=2,303 width=18) (actual time=4,795.958..4,796.669 rows=2,945 loops=1)

  • Sort Key: ((t1."timestamp")::timestamp without time zone)
  • Sort Method: quicksort Memory: 327kB
  • Buffers: shared hit=71 read=6765 dirtied=191
9. 3.364 4,792.911 ↓ 1.3 2,945 1

Result (cost=0.00..14,194.56 rows=2,303 width=18) (actual time=961.626..4,792.911 rows=2,945 loops=1)

  • Buffers: shared hit=71 read=6765 dirtied=191
10. 1.836 4,789.547 ↓ 1.3 2,945 1

Append (cost=0.00..14,194.56 rows=2,303 width=18) (actual time=961.623..4,789.547 rows=2,945 loops=1)

  • Buffers: shared hit=71 read=6765 dirtied=191
11. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on hires_precip_tbl_hrrr_mstr t1 (cost=0.00..0.00 rows=1 width=18) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone) AND (station_id = 1840366203))
12. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2014_10to11 t1_1 (cost=2.21..9.71 rows=1 width=18) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
13. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2014_10to11 (cost=0.00..2.21 rows=8 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
14. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2014_11to12 t1_2 (cost=2.21..9.71 rows=1 width=18) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
15. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2014_11to12 (cost=0.00..2.21 rows=8 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
16. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2014_12to12 t1_3 (cost=2.21..9.71 rows=1 width=18) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
17. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2014_12to12 (cost=0.00..2.21 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
18. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2015_01to02 t1_4 (cost=2.21..9.71 rows=1 width=18) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
19. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2015_01to02 (cost=0.00..2.21 rows=8 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
20. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2015_02to03 t1_5 (cost=2.21..9.71 rows=1 width=18) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
21. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2015_02to03 (cost=0.00..2.21 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
22. 0.000 0.001 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2015_03to04 t1_6 (cost=2.21..9.71 rows=1 width=18) (actual time=0.001..0.001 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
23. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2015_03to04 (cost=0.00..2.21 rows=8 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
24. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2015_04to05 t1_7 (cost=2.21..9.71 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
25. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2015_04to05 (cost=0.00..2.21 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
26. 15.404 15.404 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2015_05to06 on hires_precip_tbl_hrrr_2015_05to06 t1_8 (cost=0.44..24.41 rows=1 width=18) (actual time=15.404..15.404 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 15
  • Buffers: shared hit=1 read=17
27. 75.450 75.450 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2015_06to07 on hires_precip_tbl_hrrr_2015_06to07 t1_9 (cost=0.57..168.40 rows=1 width=18) (actual time=75.450..75.450 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 114
  • Buffers: shared hit=1 read=118
28. 0.024 0.024 ↓ 0.0 0 1

Index Scan using hires_precip_hrrr_timestamp_idx_2015_07to08 on hires_precip_tbl_hrrr_2015_07to08 t1_10 (cost=0.57..4.59 rows=1 width=18) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Filter: (station_id = 1840366203)
  • Buffers: shared hit=7
29. 40.211 40.211 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2015_08to09 on hires_precip_tbl_hrrr_2015_08to09 t1_11 (cost=0.57..188.31 rows=1 width=18) (actual time=40.211..40.211 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 55
  • Buffers: shared hit=1 read=58
30. 14.974 14.974 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2015_09to10 on hires_precip_tbl_hrrr_2015_09to10 t1_12 (cost=0.57..176.39 rows=1 width=18) (actual time=14.974..14.974 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 20
  • Buffers: shared hit=1 read=23
31. 26.332 26.332 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2015_10to11 on hires_precip_tbl_hrrr_2015_10to11 t1_13 (cost=0.57..234.17 rows=1 width=18) (actual time=26.332..26.332 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 38
  • Buffers: shared hit=1 read=41
32. 39.184 39.184 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2015_11to12 on hires_precip_tbl_hrrr_2015_11to12 t1_14 (cost=0.57..270.26 rows=1 width=18) (actual time=39.184..39.184 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 58
  • Buffers: shared hit=1 read=62
33. 110.974 110.974 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2015_12to12 on hires_precip_tbl_hrrr_2015_12to12 t1_15 (cost=0.57..459.75 rows=1 width=18) (actual time=110.974..110.974 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 154
  • Buffers: shared hit=1 read=158
34. 0.004 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2015_11to12_patch t1_16 (cost=2.21..9.71 rows=1 width=18) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
35. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2015_11to12_patch (cost=0.00..2.21 rows=8 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
36. 48.170 48.170 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_04to05 on hires_precip_tbl_hrrr_2016_04to05 t1_17 (cost=0.57..234.62 rows=1 width=18) (actual time=48.170..48.170 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 63
  • Buffers: shared hit=1 read=66
37. 69.498 69.498 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_05to06 on hires_precip_tbl_hrrr_2016_05to06 t1_18 (cost=0.57..208.81 rows=1 width=18) (actual time=69.498..69.498 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 94
  • Buffers: shared hit=1 read=98
38. 61.052 61.052 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_06to07 on hires_precip_tbl_hrrr_2016_06to07 t1_19 (cost=0.57..158.19 rows=1 width=18) (actual time=61.052..61.052 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 71
  • Buffers: shared hit=1 read=74
39. 20.850 20.850 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_07to08 on hires_precip_tbl_hrrr_2016_07to08 t1_20 (cost=0.57..134.28 rows=1 width=18) (actual time=20.850..20.850 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 32
  • Buffers: shared hit=1 read=35
40. 161.794 161.794 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_08to09 on hires_precip_tbl_hrrr_2016_08to09 t1_21 (cost=0.58..392.92 rows=1 width=18) (actual time=161.794..161.794 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 234
  • Buffers: shared hit=1 read=238
41. 177.754 177.754 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_09to10 on hires_precip_tbl_hrrr_2016_09to10 t1_22 (cost=0.57..291.87 rows=1 width=18) (actual time=177.754..177.754 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 258
  • Buffers: shared hit=1 read=261
42. 97.688 97.688 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_11to12 on hires_precip_tbl_hrrr_2016_11to12 t1_23 (cost=0.57..322.57 rows=1 width=18) (actual time=97.688..97.688 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 148
  • Buffers: shared hit=1 read=151
43. 212.359 212.359 ↓ 1.3 323 1

Index Scan using hires_precip_stationid_idx_2016_12to12 on hires_precip_tbl_hrrr_2016_12to12 t1_24 (cost=0.58..512.20 rows=252 width=18) (actual time=2.220..212.359 rows=323 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=327
44. 232.266 232.266 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_10to11 on hires_precip_tbl_hrrr_2016_10to11 t1_25 (cost=0.57..350.40 rows=1 width=18) (actual time=232.266..232.266 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 315
  • Buffers: shared hit=1 read=319
45. 39.263 39.263 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_01to02 on hires_precip_tbl_hrrr_2016_01to02 t1_26 (cost=0.57..449.56 rows=1 width=18) (actual time=39.263..39.263 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 59
  • Buffers: shared hit=1 read=62
46. 24.466 24.466 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_02to03 on hires_precip_tbl_hrrr_2016_02to03 t1_27 (cost=0.57..343.76 rows=1 width=18) (actual time=24.466..24.466 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 36
  • Buffers: shared hit=1 read=39
47. 64.035 64.035 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2016_03to04 on hires_precip_tbl_hrrr_2016_03to04 t1_28 (cost=0.57..288.87 rows=1 width=18) (actual time=64.035..64.035 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 84
  • Buffers: shared hit=1 read=87
48. 154.833 154.833 ↓ 1.3 206 1

Index Scan using hires_precip_stationid_idx_2017_04to05 on hires_precip_tbl_hrrr_2017_04to05 t1_29 (cost=0.57..331.96 rows=163 width=18) (actual time=2.585..154.833 rows=206 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=210
49. 145.003 145.003 ↑ 1.2 156 1

Index Scan using hires_precip_stationid_idx_2017_05to06 on hires_precip_tbl_hrrr_2017_05to06 t1_30 (cost=0.57..378.65 rows=188 width=18) (actual time=2.435..145.003 rows=156 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=160
50. 240.079 240.079 ↓ 1.8 362 1

Index Scan using hires_precip_stationid_idx_2017_06to07 on hires_precip_tbl_hrrr_2017_06to07 t1_31 (cost=0.57..403.37 rows=199 width=18) (actual time=2.721..240.079 rows=362 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=366
51. 204.472 204.472 ↓ 1.9 304 1

Index Scan using hires_precip_stationid_idx_2017_07to08 on hires_precip_tbl_hrrr_2017_07to08 t1_32 (cost=0.57..319.49 rows=157 width=18) (actual time=3.437..204.472 rows=304 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=308
52. 239.034 239.034 ↓ 1.9 348 1

Index Scan using hires_precip_stationid_idx_2017_08to09 on hires_precip_tbl_hrrr_2017_08to09 t1_33 (cost=0.57..367.53 rows=181 width=18) (actual time=2.349..239.034 rows=348 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=352
53. 213.706 213.706 ↓ 1.9 249 1

Index Scan using hires_precip_stationid_idx_2017_09to10 on hires_precip_tbl_hrrr_2017_09to10 t1_34 (cost=0.57..266.58 rows=132 width=18) (actual time=4.634..213.706 rows=249 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=253
54. 75.979 75.979 ↑ 1.7 111 1

Index Scan using hires_precip_stationid_idx_2017_11to12 on hires_precip_tbl_hrrr_2017_11to12 t1_35 (cost=0.57..400.99 rows=194 width=18) (actual time=7.602..75.979 rows=111 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 9
  • Buffers: shared hit=1 read=123
55. 65.669 65.669 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2017_12to12 on hires_precip_tbl_hrrr_2017_12to12 t1_36 (cost=0.57..506.14 rows=1 width=18) (actual time=65.669..65.669 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 97
  • Buffers: shared hit=1 read=101
56. 166.386 166.386 ↓ 1.4 231 1

Index Scan using hires_precip_stationid_idx_2017_10to11 on hires_precip_tbl_hrrr_2017_10to11 t1_37 (cost=0.57..327.36 rows=162 width=18) (actual time=3.223..166.386 rows=231 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=235
57. 154.430 154.430 ↑ 1.2 199 1

Index Scan using hires_precip_stationid_idx_2017_01to02 on hires_precip_tbl_hrrr_2017_01to02 t1_38 (cost=0.57..462.32 rows=231 width=18) (actual time=2.241..154.430 rows=199 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=204 dirtied=1
58. 150.390 150.390 ↓ 1.1 223 1

Index Scan using hires_precip_stationid_idx_2017_02to03 on hires_precip_tbl_hrrr_2017_02to03 t1_39 (cost=0.57..426.68 rows=210 width=18) (actual time=2.307..150.390 rows=223 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=226
59. 163.314 163.314 ↓ 1.3 233 1

Index Scan using hires_precip_stationid_idx_2017_03to04 on hires_precip_tbl_hrrr_2017_03to04 t1_40 (cost=0.57..368.62 rows=181 width=18) (actual time=12.097..163.314 rows=233 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1 read=237
60. 111.640 111.640 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_01to02 on hires_precip_tbl_hrrr_2018_01to02 t1_41 (cost=0.57..481.33 rows=1 width=18) (actual time=111.640..111.640 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 156
  • Buffers: shared hit=1 read=159
61. 81.675 81.675 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_02to03 on hires_precip_tbl_hrrr_2018_02to03 t1_42 (cost=0.57..352.45 rows=1 width=18) (actual time=81.675..81.675 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 108
  • Buffers: shared hit=1 read=111
62. 50.567 50.567 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_03to04 on hires_precip_tbl_hrrr_2018_03to04 t1_43 (cost=0.57..353.07 rows=1 width=18) (actual time=50.567..50.567 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 60
  • Buffers: shared hit=1 read=63
63. 142.249 142.249 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_04to05 on hires_precip_tbl_hrrr_2018_04to05 t1_44 (cost=0.57..286.40 rows=1 width=18) (actual time=142.249..142.249 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 201
  • Buffers: shared hit=1 read=205
64. 157.072 157.072 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_05to06 on hires_precip_tbl_hrrr_2018_05to06 t1_45 (cost=0.57..401.40 rows=1 width=18) (actual time=157.072..157.072 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 241
  • Buffers: shared hit=1 read=245
65. 247.221 247.221 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_06to07 on hires_precip_tbl_hrrr_2018_06to07 t1_46 (cost=0.57..348.53 rows=1 width=18) (actual time=247.221..247.221 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 352
  • Buffers: shared hit=1 read=356
66. 133.470 133.470 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_07to08 on hires_precip_tbl_hrrr_2018_07to08 t1_47 (cost=0.57..264.59 rows=1 width=18) (actual time=133.470..133.470 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 166
  • Buffers: shared hit=1 read=169
67. 139.050 139.050 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_08to09 on hires_precip_tbl_hrrr_2018_08to09 t1_48 (cost=0.57..290.25 rows=1 width=18) (actual time=139.050..139.050 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 146
  • Buffers: shared hit=1 read=153 dirtied=3
68. 92.897 92.897 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_09to10 on hires_precip_tbl_hrrr_2018_09to10 t1_49 (cost=0.57..293.61 rows=1 width=18) (actual time=92.897..92.897 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 113
  • Buffers: shared hit=1 read=117 dirtied=99
69. 49.353 49.353 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_10to11 on hires_precip_tbl_hrrr_2018_10to11 t1_50 (cost=0.57..333.67 rows=1 width=18) (actual time=49.353..49.353 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 81
  • Buffers: shared hit=1 read=84 dirtied=18
70. 46.272 46.272 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_11to12 on hires_precip_tbl_hrrr_2018_11to12 t1_51 (cost=0.57..404.98 rows=1 width=18) (actual time=46.272..46.272 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 59
  • Buffers: shared hit=1 read=62 dirtied=55
71. 26.473 26.473 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2018_12to12 on hires_precip_tbl_hrrr_2018_12to12 t1_52 (cost=0.57..392.01 rows=1 width=18) (actual time=26.473..26.473 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 21
  • Buffers: shared hit=1 read=26 dirtied=12
72. 4.647 4.647 ↓ 0.0 0 1

Index Scan using hires_precip_stationid_idx_2019_01to02 on hires_precip_tbl_hrrr_2019_01to02 t1_53 (cost=0.56..33.84 rows=1 width=18) (actual time=4.647..4.647 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=2 read=6 dirtied=3
73. 0.008 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_02to03 t1_54 (cost=2.21..9.71 rows=1 width=18) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
74. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_02to03 (cost=0.00..2.21 rows=8 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
75. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_03to04 t1_55 (cost=2.21..9.71 rows=1 width=18) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
76. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_03to04 (cost=0.00..2.21 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
77. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_04to05 t1_56 (cost=2.21..9.71 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
78. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_04to05 (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
79. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_05to06 t1_57 (cost=2.21..9.71 rows=1 width=18) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
80. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_05to06 (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
81. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_06to07 t1_58 (cost=2.21..9.71 rows=1 width=18) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
82. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_06to07 (cost=0.00..2.21 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
83. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_07to08 t1_59 (cost=2.21..9.71 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
84. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_07to08 (cost=0.00..2.21 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
85. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_08to09 t1_60 (cost=2.21..9.71 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
86. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_08to09 (cost=0.00..2.21 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
87. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_09to10 t1_61 (cost=2.21..9.71 rows=1 width=18) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
88. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_09to10 (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
89. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_10to11 t1_62 (cost=2.21..9.71 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
90. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_10to11 (cost=0.00..2.21 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
91. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_11to12 t1_63 (cost=2.21..9.71 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
92. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_11to12 (cost=0.00..2.21 rows=8 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1
93. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on hires_precip_tbl_hrrr_2019_12to12 t1_64 (cost=2.21..9.71 rows=1 width=18) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (station_id = 1840366203)
  • Filter: (("timestamp" >= 2016-12-01 00:00:00::timestamp without time zone) AND ("timestamp" <= 2017-11-29 23:00:00::timestamp without time zone))
  • Buffers: shared hit=1
94. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on hires_precip_stationid_idx_2019_12to12 (cost=0.00..2.21 rows=8 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (station_id = 1840366203)
  • Buffers: shared hit=1