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?.
CREATE TABLE
INSERT 0 100
INSERT 0 60
| ts_min | cnt | sumqty |
|---|---|---|
| 2023-10-11 09:00:00 | 6 | 13 |
| 2023-10-11 09:15:00 | 10 | 25 |
| 2023-10-11 09:30:00 | 12 | 24 |
| 2023-10-11 09:45:00 | 15 | 30 |
| 2023-10-11 10:00:00 | 24 | 60 |
| 2023-10-11 10:15:00 | 18 | 46 |
| 2023-10-11 10:30:00 | 28 | 73 |
| 2023-10-11 10:45:00 | 17 | 42 |
| 2023-10-11 11:00:00 | 12 | 31 |
| 2023-10-11 11:15:00 | 18 | 50 |
SELECT 10