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?.
12 rows affected
| sales_date | country | sales_volume | fix_costs | used_fix_costs |
|---|---|---|---|---|
| 2020-01-03 | DE | 500 | 2000 | 37.950664136622386 |
| 2020-01-03 | FR | 350 | 2000 | 26.565464895635674 |
| 2020-01-03 | NL | 320 | 2000 | 0 |
| 2020-02-15 | DE | 0 | 5000 | 86.20689655172414 |
| 2020-02-15 | FR | 0 | 5000 | 86.20689655172414 |
| 2020-02-15 | NL | 0 | 5000 | 0 |
| 2020-03-27 | DE | 180 | 4000 | 20.19635343618513 |
| 2020-03-27 | FR | 970 | 4000 | 108.83590462833101 |
| 2020-03-27 | NL | 670 | 4000 | 0 |