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
INSERT 0 4
| id | date | issuer | index_code | opening_closing |
|---|---|---|---|---|
| 1393 | 2016-11-25 | cboe | buk350n | O |
| 1394 | 2016-11-25 | cboe | buk350n | O |
| 1395 | 2016-11-25 | cboe | buk350n | O |
| 1402 | 2016-11-25 | cboe | buk350n | O |
SELECT 4
| max |
|---|
| 2016-11-25 |
SELECT 1