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?.
CREATE TABLE
| store_code | certificate_id | audit_ending |
|---|---|---|
| K010 | vwv | 2023-12-10 |
| K010 | cert1 | 2023-12-12 |
| K054 | vwv | 2023-12-14 |
| K054 | cert1 | 2024-01-20 |
INSERT 0 4
| store_code | certificate_id | audit_ending |
|---|---|---|
| K010 | vwv | 2023-12-10 |
| K054 | vwv | 2023-12-14 |
SELECT 2