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 TABLE
INSERT 0 8
| which |
|---|
| CAT1 |
| -> SUBCAT1 |
| -> DESC1 |
| -> DESC2 |
| -> SUBCAT2 |
| -> DESC3 |
| -> DESC4 |
| -> DESC5 |
| CAT2 |
| -> SUBCAT3 |
| -> DESC6 |
| -> DESC7 |
| -> SUBCAT4 |
| -> DESC8 |
SELECT 14