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?.
| daterange |
|---|
| {"[2018-03-19,2020-12-29)","[2018-06-21,2020-12-29)","[2018-07-17,2020-12-29)","[2018-04-18,2018-07-31)","[2019-08-01,2019-11-20)"} |
SELECT 1