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?.
current_timestamp | timezone | timezone | timezone | timezone |
---|---|---|---|---|
2023-08-10 11:58:57.965426+01 | 2023-08-10 23:43:57.965426 | 2023-08-10 | 2023-08-10 00:58:57.965426 | 2023-08-10 |
SELECT 1