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
| id | jsonb_pretty |
|---|---|
| 1 | { "foo": 1, "persons": [ { "name": "2fdsdsd", "test": { "id": "123", "age": 32 } } ], "some_prop": "123" } |
| 2 | { "foo": 2, "persons": [ { "test": null } ], "some_prop": "124" } |
| 3 | { "foo": 3, "persons": [ { "name": "3asd", "test": { "id": "125", "age": 55 } }, { "name": "4asd", "test": { "id": "126", "age": 66 } } ], "some_prop": "125" } |
| 4 | { "foo": 4, "persons": [ { "name": "3asd", "test": { "id": "123", "age": 55 } }, { "name": "4asd", "test": { "id": "126", "age": 66 } } ], "some_prop": "129" } |
INSERT 0 4
| id | jsonb_pretty |
|---|---|
| 1 | { "foo": 1, "persons": [ { "name": "2fdsdsd", "test": { "id": "123", "age": 32 } } ], "some_prop": "123" } |
| 2 | { "foo": 2, "persons": [ { "test": null } ], "some_prop": "124" } |
| 4 | { "foo": 4, "persons": [ { "name": "3asd", "test": { "id": "123", "age": 55 } }, { "name": "4asd", "test": { "id": "126", "age": 66 } } ], "some_prop": "129" } |
SELECT 3