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?.
INSERT 0 4
| vendor_id | full_name | age | |
|---|---|---|---|
| 100 | jon | 10 | |
| 101 | JON | 11 | |
| 102 | j o n | 12 | |
| 103 | null | null |
SELECT 4