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?.
7 rows affected
fruit | color |
---|---|
banana | green |
banana | yellow |
apple | green |
apple | red |
apple | yellow |
strawberry | green |
strawberry | red |
fruit |
---|
banana |
fruit |
---|
apple |
fruit |
---|
strawberry |