By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
10 rows affected
| date | consecutive_group_nr | daily_cumulative_precip | cum_precipitation_mm |
|---|---|---|---|
| 2016-07-28 | 1 | 3.048 | 3.048 |
| 2016-08-04 | 2 | 2.286 | 2.286 |
| 2016-08-11 | 3 | 5.334 | 5.334 |
| 2016-08-12 | 3 | 0.254 | 5.588 |
| 2016-08-13 | 3 | 2.794 | 8.382 |
| 2016-08-14 | 3 | 2.286 | 10.668 |
| 2016-08-15 | 3 | 3.302 | 13.97 |
| 2016-08-17 | 4 | 3.81 | 3.81 |
| 2016-08-19 | 5 | 15.746 | 15.746 |
| 2016-08-20 | 5 | 46.74 | 62.486 |