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?.
8 rows affected
file_date | amt | rollover |
---|---|---|
2019-01-01 | 75008.00 | 75008.00 |
2019-02-01 | 5008.00 | 80016.00 |
2019-03-01 | 93745.00 | 173761.00 |
2019-04-01 | 3745.00 | 177506.00 |
2019-05-01 | 2434047.00 | 2611553.00 |
2019-06-01 | 422922.15 | 3034475.15 |