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 x AS( SELECT
'{
"1": {
"sum": 5
},
"2": {
"sum": 10
},
"2728": {
"sum": 30
},
"2729": {
"sum": 5
}
}'::jsonB as y)
SELECT SUM((v.value::jsonb->'sum')::INT)
FROM x
CROSS JOIN LATERAL jsonb_each_text(x.y) v
| sum |
|---|
| 50 |
SELECT 1