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?.
CREATE EXTENSION
SELECT 12
| id | st_astext |
|---|---|
| 1 | LINESTRING(0 0,0 5) |
| 2 | LINESTRING(0 5,0 10) |
| 3 | LINESTRING(0 10,0 15) |
| 4 | LINESTRING(0 15,0 20) |
| 5 | LINESTRING(0 20,0 25) |
| 6 | LINESTRING(0 25,0 30) |
| 7 | LINESTRING(0 30,0 35) |
| 8 | LINESTRING(0 35,0 40) |
| 9 | LINESTRING(0 40,0 45) |
| 10 | LINESTRING(0 45,0 50) |
| 11 | LINESTRING(0 50,0 55) |
| 12 | LINESTRING(0 55,0 60) |
SELECT 12
| zoom_level | st_astext |
|---|---|
| L | LINESTRING(0 0,0 30) |
| L | LINESTRING(0 30,0 60) |
| M | LINESTRING(0 0,0 15) |
| M | LINESTRING(0 15,0 30) |
| M | LINESTRING(0 30,0 45) |
| M | LINESTRING(0 45,0 60) |
| S | LINESTRING(0 0,0 10) |
| S | LINESTRING(0 10,0 20) |
| S | LINESTRING(0 20,0 30) |
| S | LINESTRING(0 30,0 40) |
| S | LINESTRING(0 40,0 50) |
| S | LINESTRING(0 50,0 60) |
| XL | LINESTRING(0 0,0 30) |
| XL | LINESTRING(0 30,0 60) |
| XXL | LINESTRING(0 0,0 60) |
SELECT 15