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?.
4 rows affected
| id | id2 | fname | lname | address1 | address2 | city | state | other ID |
|---|---|---|---|---|---|---|---|---|
| 124 | 124 | mary | jones | 15 main st | new york | NY | null | null |
| 123 | 123 | joe | smith | 12 main st | los angeles | CA | null | 3210 |
| 122 | 122 | james | jones | 13 main st | new york | NY | null | null |