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 20
| date | service | value | realized | group_num | realized_value |
|---|---|---|---|---|---|
| 2023-04-01 | A | null | 0 | 0 | 150.80 |
| 2023-04-02 | A | null | 0 | 0 | 150.80 |
| 2023-04-03 | A | null | 0 | 0 | 150.80 |
| 2023-04-04 | A | null | 0 | 0 | 150.80 |
| 2023-04-05 | A | null | 0 | 0 | 150.80 |
| 2023-04-06 | A | null | 0 | 0 | 150.80 |
| 2023-04-07 | A | 150.80 | 0 | 0 | 150.80 |
| 2023-04-08 | A | null | 1 | 1 | null |
| 2023-04-09 | A | null | 0 | 1 | null |
| 2023-04-10 | A | null | 0 | 1 | null |
| 2023-04-01 | B | null | 0 | 0 | 247.17 |
| 2023-04-02 | B | null | 0 | 0 | 247.17 |
| 2023-04-03 | B | 247.17 | 0 | 0 | 247.17 |
| 2023-04-04 | B | null | 1 | 1 | 75.12 |
| 2023-04-05 | B | null | 0 | 1 | 75.12 |
| 2023-04-06 | B | null | 0 | 1 | 75.12 |
| 2023-04-07 | B | null | 0 | 1 | 75.12 |
| 2023-04-08 | B | 75.12 | 0 | 1 | 75.12 |
| 2023-04-09 | B | null | 1 | 2 | null |
| 2023-04-10 | B | null | 0 | 2 | null |
SELECT 20