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?.
4 rows affected
| customer_id | hour |
|---|---|
| X | 2019-04-01 13:00:00 |
| X | 2019-04-01 14:00:00 |
| X | 2019-04-01 15:00:00 |
| X | 2019-04-01 16:00:00 |
| X | 2019-04-01 17:00:00 |
| Y | 2019-04-01 17:00:00 |
| Y | 2019-04-01 18:00:00 |
| Y | 2019-04-01 19:00:00 |