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?.
t1 j1 r2 j2 r3 j3 r4 j4
(1,x,42.1) {"?column?":1,"?column?":"x","numeric":42.1} (1,x,42.1) {"f1":1,"f2":"x","f3":42.1} (1,x,42.1) {"f1":1,"f2":"x","f3":42.1} (1,x,42.1) {"xx1":1,"xx2":"x","xx3":42.1}