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?.
8 rows affected
| date | pageviews | moving_average |
|---|---|---|
| 2020-02-01 | 42 | 42.0000000000000000 |
| 2020-02-02 | 3 | 22.5000000000000000 |
| 2020-02-03 | 216 | 87.0000000000000000 |
| 2020-02-04 | 186 | 135.0000000000000000 |
| 2020-02-05 | 510 | 304.0000000000000000 |
| 2020-02-06 | 419 | 371.6666666666666667 |
| 2020-02-07 | 64 | 331.0000000000000000 |
| 2020-02-08 | 0 | 161.0000000000000000 |
| 2020-02-09 | 230 | 98.0000000000000000 |