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?.
jsonb_pretty |
---|
[ { "skill_1": 4, "skill_2": 2, "skill_3": 5, "user_id": "123" }, { "skill_1": 1, "skill_2": 3, "skill_3": 4, "skill_4": 42, "user_id": "456" } ] |
SELECT 1