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 json_example as
select '[{"a":1,"b":"foo"},{"a":"2","c":"bar"}]' ::json as value
SELECT 1
select j.* from json_example cross join
json_array_elements(value) as j
| value |
|---|
| {"a":1,"b":"foo"} |
| {"a":"2","c":"bar"} |
SELECT 2