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?.
| gendates |
|---|
| 2021-08-29 |
| 2021-08-30 |
| 2021-08-31 |
| 2021-09-01 |
| 2021-09-02 |
| 2021-09-05 |
| 2021-09-06 |
| 2021-09-07 |
| 2021-09-08 |
| 2021-09-09 |
| 2021-09-12 |
| 2021-09-13 |
| 2021-09-14 |
| 2021-09-15 |
| 2021-09-16 |
| 2021-09-19 |
| 2021-09-20 |
| 2021-09-21 |
| 2021-09-22 |
| 2021-09-23 |
| 2021-09-26 |
| 2021-09-27 |
| 2021-09-28 |
| 2021-09-29 |