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?.
5 rows affected
| coalesce | id | dt |
|---|---|---|
| 90 | 123 | 2019-07-09 00:00:00 |
| 100 | 123 | 2019-07-10 00:00:00 |
| 0 | 123 | 2019-07-11 00:00:00 |
| 0 | 123 | 2019-07-12 00:00:00 |
| 50 | 123 | 2019-07-13 00:00:00 |
| 0 | 123 | 2019-07-14 00:00:00 |
| 30 | 123 | 2019-07-15 00:00:00 |
| 0 | 123 | 2019-07-16 00:00:00 |