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?.
| yr | wk | res |
|---|---|---|
| 2020 | 1 | 2019-12-30 00:00:00+00 |
| 2020 | 33 | 2020-08-10 00:00:00+01 |
| 2020 | 53 | 2020-12-28 00:00:00+00 |
| 2020 | 54 | 2021-01-04 00:00:00+00 |
| yr | wk | res |
|---|---|---|
| 2020 | 1 | 2019-12-30 00:00:00+00 |
| 2020 | 33 | 2020-08-10 00:00:00+01 |
| 2020 | 53 | 2020-12-28 00:00:00+00 |
| 2020 | 54 | 2021-01-04 00:00:00+00 |