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
CREATE TABLE
INSERT 0 3
CREATE TABLE
INSERT 0 3
| id | name | uploads |
|---|---|---|
| 2 | Bar | [{"cover": true, "title": "baz", "profile": true, "versions": [42], "upload_id": 2}] |
| 1 | Foo | [{"cover": true, "title": "foobar", "profile": false, "versions": [1, 2, 3], "upload_id": 1}, {"cover": false, "title": "foofoo", "profile": false, "versions": [], "upload_id": 3}] |
SELECT 2