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?.
4 rows affected
device_name down_interfaces
one 1
two 1
three 0
four 2
device_name all_interfaces down_interfaces
one 2 1
two 1 1
three 1 0
four 2 2