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?.
11 rows affected
a b c cnt
1 1 null 4
2 null null null
3 null null null
4 null 1 null
6 null null null
7 null null null
8 1 null 2
9 null 1 null
10 1 null 2
11 null 1 null
12 1 1 1