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?.
16 rows affected
| dept | cmonth | fmonth | amount |
|---|---|---|---|
| AA | 2021-07 | 2021-07 | 100 |
| AA | 2021-07 | 2021-08 | 100 |
| AA | 2021-07 | 2021-09 | 100 |
| AA | 2021-07 | 2021-10 | 100 |
| AA | 2021-08 | 2021-08 | 150 |
| AA | 2021-08 | 2021-09 | 150 |
| AA | 2021-08 | 2021-10 | 150 |
| AA | 2021-08 | 2021-11 | 150 |
| BB | 2021-07 | 2021-07 | 110 |
| BB | 2021-07 | 2021-08 | 110 |
| BB | 2021-07 | 2021-09 | 110 |
| BB | 2021-07 | 2021-10 | 110 |
| BB | 2021-08 | 2021-08 | 120 |
| BB | 2021-08 | 2021-09 | 120 |
| BB | 2021-08 | 2021-10 | 120 |
| BB | 2021-08 | 2021-11 | 120 |
| dept | fmonth | amount |
|---|---|---|
| AA | 2021-11 | 150 |
| AA | 2021-10 | 150 |
| AA | 2021-09 | 150 |
| AA | 2021-08 | 150 |
| AA | 2021-07 | 100 |
| BB | 2021-11 | 120 |
| BB | 2021-10 | 120 |
| BB | 2021-09 | 120 |
| BB | 2021-08 | 120 |
| BB | 2021-07 | 110 |