Postgres 14

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?.

SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$')

jsonb_path_query

[1, 2, 3]

SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$[*]')

jsonb_path_query

1

2

3

SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$[*] ? (@ <> null)')

jsonb_path_query

1

2

3

SELECT jsonb_path_query('[1,2,3]' :: jsonb, '$ ? (@ <> null)')

jsonb_path_query

1

2

3