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?.
s_jahr | s_monat | s_erzeugung | s_einspeisung | s_stromversorger |
---|---|---|---|---|
2017 | 12 | 147.5 | 22.3 | 14.8 |
2018 | 1 | 311.1 | 57.3 | 38.8 |
2018 | 2 | 482.9 | 90.4 | 53.6 |
s_jahr | s_monat | s_erzeugung | s_erzeugung_diff | s_einspeisung | s_einspeisung_diff | s_stromversorger | s_stromversorger_diff |
---|---|---|---|---|---|---|---|
2017 | 12 | 147.5 | null | 22.3 | null | 14.8 | null |
2018 | 1 | 311.1 | 163.6 | 57.3 | 35.0 | 38.8 | 24.0 |
2018 | 2 | 482.9 | 171.8 | 90.4 | 33.1 | 53.6 | 14.8 |
s_jahr | s_monat | s_erzeugung | s_erzeugung_diff | s_einspeisung | s_einspeisung_diff | s_stromversorger | s_stromversorger_diff |
---|---|---|---|---|---|---|---|
2017 | 12 | 147.5 | null | 22.3 | null | 14.8 | null |
2018 | 1 | 311.1 | 163.6 | 57.3 | 35.0 | 38.8 | 24.0 |
2018 | 2 | 482.9 | 171.8 | 90.4 | 33.1 | 53.6 | 14.8 |