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
id | st_length | flipped_ends_length | shortest | the_longer_way_around | st_intersects |
---|---|---|---|---|---|
1 | 1113194.907932742 | 1113194.907932742 | 1113194.907932742 | 38961821.777645744 | t |
SELECT 1