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 3
| subject |
|---|
| {"team": "1234", "user": 5678} |
| {"org": 123} |
| {"team": 1234} |
SELECT 3
UPDATE 2
| subject |
|---|
| {"org": 123} |
| {"team": 1234, "user": 5678} |
| {"team": 1234} |
SELECT 3