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?.
6 rows affected
point stop nxt grp
1 t 2 1
2 f 3 1
3 t 4 2
4 f 5 2
5 f 6 2
6 t null 3
grp points
1 {"(1,2)","(2,3)"}
2 {"(3,4)","(4,5)","(5,6)"}
grp lines
1 010200000002000000000000000000F03F000000000000004000000000000000400000000000000840
2 010200000003000000000000000000084000000000000010400000000000001040000000000000144000000000000014400000000000001840