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 2
| uuid | txt | bigint1 | bigint2 |
|---|---|---|---|
| 14607158-d3b1-4ac0-b0d8-2a9a5a9e8f6e | 24607158d3b14ac0b0d82a9a5a9e8f6e | 1468298104845454016 | 2621219609452300992 |
| 14607158-d3b1-4ac0-b0d8-2a9a5a9e8f6e | 24607158-d3b1-4ac0-b0d8-2a9a5a9e8f6e | 1468298104845454016 | 2621219609452300992 |
SELECT 2