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?.
id | year |
---|---|
01 | 2016 |
01 | 2017 |
02 | 2017 |
02 | 2018 |
03 | 2015 |
03 | 2016 |
03 | 2017 |
03 | 2018 |
04 | 2018 |
05 | 2014 |
05 | 2015 |
05 | 2016 |
05 | 2017 |
05 | 2018 |