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?.
| gid | v1 | v2 | fv | lv |
|---|---|---|---|---|
| 1 | d | 1 | d | b |
| 1 | a | 2 | d | b |
| 1 | b | 3 | d | b |
| 2 | x | 7 | x | v |
| 2 | z | 8 | x | v |
| 2 | y | 9 | x | v |
| 2 | v | 9 | x | v |