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 | imputed_fix_costs |
|---|---|---|---|---|
| 2020-01-03 | DE | 500 | 2000 | 37.95066413662239 |
| 2020-01-03 | FR | 350 | 2000 | 26.56546489563567 |
| 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.196353436185134 |
| 2020-03-27 | FR | 970 | 4000 | 108.835904628331 |
| 2020-03-27 | NL | 670 | 4000 | 0 |