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?.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
| fromdate | todate_raw | todate_new |
|---|---|---|
| 2016-02-15 | 2016-04-30 | 2016-04-30 |
| 2016-05-01 | null | 2016-06-02 |
| 2016-06-02 | 2016-10-16 | 2016-10-16 |
| 2016-10-17 | 2016-12-31 | 2016-12-31 |
| 2017-01-01 | 2017-02-14 | 2017-02-14 |
| 2017-02-15 | 2017-12-31 | 2017-12-31 |
| 2018-01-01 | 2018-02-14 | 2018-02-14 |
| 2018-02-15 | 2018-02-20 | 2018-02-20 |
| 2018-02-21 | 2018-03-31 | 2018-03-31 |
| 2018-04-01 | 2018-12-31 | 2018-12-31 |
| 2019-01-01 | 2019-03-31 | 2019-03-31 |
| 2019-04-01 | 2019-12-31 | 2019-12-31 |
| 2020-01-01 | null | null |