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?.
2 rows affected
gid line
1 LINESTRING(0 0,1 0)
1 LINESTRING(1 0,1 1)
1 LINESTRING(1 1,0 1)
2 LINESTRING(3 4,5 6)
2 LINESTRING(5 6,7 8)
2 LINESTRING(7 8,9 10)
gid line
1 LINESTRING(0 0,1 0)
1 LINESTRING(1 0,1 1)
1 LINESTRING(1 1,0 1)
2 LINESTRING(3 4,5 6)
2 LINESTRING(5 6,7 8)
2 LINESTRING(7 8,9 10)
gid line
1 LINESTRING(0 0,1 0)
1 LINESTRING(1 0,1 1)
1 LINESTRING(1 1,0 1)
2 LINESTRING(3 4,5 6)
2 LINESTRING(5 6,7 8)
2 LINESTRING(7 8,9 10)