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?.
11 rows affected
| id | name | date | value |
|---|---|---|---|
| 9 | Bob | 2021-08-26 00:00:00 | 3 |
| 10 | Bob | 2021-05-13 00:00:00 | 12 |
| 11 | Bob | 2021-03-08 00:00:00 | 2 |
| 3 | John | 2022-01-31 00:00:00 | -12 |
| 4 | John | 2021-12-15 00:00:00 | 32 |
| 6 | Tom | 2021-05-05 00:00:00 | 201 |
| 7 | Tom | 2020-11-27 00:00:00 | 76 |