add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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