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?.
| dob | n_days |
|---|---|
| 1980-08-09 13:34:10+01 | 29442.52372685185 |
| 2005-12-15 23:10:00+00 | 38701.965277777774 |
| 2020-02-26 15:56:00+00 | 43887.66388888889 |