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?.
| row_to_json |
|---|
| {"type":"FeatureCollection","name":"standorts","crs":{"type" : "name", "properties" : {"name" : "urn:ogc:def:crs:OGC:1.3:CRS84"}},"features":[{"type": "Feature", "geometry": {"type": "Point", "coordinates": [11.886684554, 47.672030583]}, "properties": {"id": 0}},{"type": "Feature", "geometry": {"type": "Point", "coordinates": [11.896296029, 47.666357408]}, "properties": {"id": 1}}]} |