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?.
7 rows affected
| data_date | data_value | cumulative_sum |
|---|---|---|
| 2021-08-25 | 1 | 1 |
| 2021-08-26 | 7 | 8 |
| 2021-08-27 | 8 | 16 |
| 2021-08-28 | 7 | 23 |
| 2021-08-29 | 2 | 25 |
| 2021-08-30 | 2 | 27 |
| 2021-08-31 | 7 | 34 |
| 2021-09-01 | 7 | 41 |
| 2021-09-02 | 7 | 48 |
| 2021-09-03 | 7 | 55 |