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
| id | ingdt | code | gender | address |
|---|---|---|---|---|
| 1 | 2018-10-27 | null | null | street1 |
| 1 | 2018-10-24 | 1234 | null | street2 |
| 1 | 2017-08-20 | 3245 | M | street2 |
| 2 | 2018-09-24 | null | F | Astreet |
| 2 | 2018-10-24 | 2857 | F | Bstreet |
| 3 | 2018-08-24 | 3489 | M | null |
| 3 | 2018-08-22 | 5802 | M | Cstreet |
| id | max | code | gender | address |
|---|---|---|---|---|
| 1 | 2018-10-27 | 1234 | M | street1 |
| 2 | 2018-10-24 | 2857 | F | Bstreet |
| 3 | 2018-08-24 | 3489 | M | Cstreet |