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 | created_at | business_hours |
---|---|---|
9d38ea6e-7077-400d-b310-cfc47b31d482 | 2021-04-21 07:56:36 | 6533:45:46.740648 |
9d38ea6e-7077-400d-b310-cfc47b31d481 | 2021-04-19 21:55:46 | 6541:45:46.740648 |
9d38ea6e-7077-400d-b310-cfc47b31d479 | 2021-04-18 22:43:44 | 6549:45:46.740648 |
9d38ea6e-7077-400d-b310-cfc47b31d480 | 2021-04-17 14:22:05 | 6549:45:46.740648 |
SELECT 4