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?.
WITH cte AS ( SELECT '[1,2,3,10,55]'::jsonb json_array
UNION ALL
SELECT '[11,2,3,10,55]' )
SELECT json_array, json_array @> '1'::jsonb test FROM cte;
| json_array | test |
|---|---|
| [1, 2, 3, 10, 55] | t |
| [11, 2, 3, 10, 55] | f |