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 mytable (
id bigint NOT NULL
, numbers jsonb
);
INSERT INTO mytable VALUES
(1, '[1,8,3,4,56,6]')
, (2, '[1,2,7,4,24,5]')
;
CREATE TABLE
INSERT 0 2
SELECT *
FROM mytable
WHERE numbers @> '[56]';
| id | numbers |
|---|---|
| 1 | [1, 8, 3, 4, 56, 6] |
SELECT 1
SELECT *
FROM mytable
WHERE numbers @> '56';
| id | numbers |
|---|---|
| 1 | [1, 8, 3, 4, 56, 6] |
SELECT 1