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?.
2 rows affected
event_id | report_date | start_hour | end_hour | expected_hour | tz | start_utc | end_utc | expected_utc | start_minus_end |
---|---|---|---|---|---|---|---|---|---|
1 | 2018-03-25 | 01:00:00 | 03:00:00 | 02:00:00 | Europe/Vienna | 2018-03-25 00:00:00 | 2018-03-25 01:00:00 | 2018-03-25 01:00:00 | -01:00:00 |
2 | 2018-03-25 | 01:00:00 | 03:00:00 | 02:00:00 | Europe/Moscow | 2018-03-24 22:00:00 | 2018-03-25 00:00:00 | 2018-03-24 23:00:00 | -02:00:00 |