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?.
| corona_country | corona_patient | corona_suspected | latest |
|---|---|---|---|
| Indonesia | Andy | 2020-03-05 | Y |
| Indonesia | Andy | 2020-03-01 | N |
| Italy | Michael | 2020-03-15 | Y |
| Italy | Michael | 2020-03-15 | Y |
| Italy | Michael | 2020-03-13 | N |
| Mexico | Teddy | 2020-03-01 | Y |
| corona_country | corona_patient | corona_suspected | latest |
|---|---|---|---|
| Indonesia | Andy | 2020-03-01 | N |
| Indonesia | Andy | 2020-03-05 | Y |
| Italy | Michael | 2020-03-13 | N |
| Italy | Michael | 2020-03-15 | Y |
| Italy | Michael | 2020-03-15 | Y |
| Mexico | Teddy | 2020-03-01 | Y |