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 mytable(v_info) as (
values ('{
"id": 1406711300166,
"abc": [
{
"am": "1.74",
"am_set": {
"sh_mon": {
"am": "1.74",
"cur_code": "ABC"
},
"pre_money": {
"amount": "1.74",
"code": "ABC"
}
},
"app_index": 0
},
{
"am": "1.74",
"am_set": {
"sh_mon": {
"am": "1.74",
"cur_code": "ABC"
},
"pre_money": {
"amount": "1.74",
"code": "ABC"
}
},
"app_index": 1
}
],
"xyx": 0,
"zyx": "random var"
}'::jsonb)
| abc_index |
|---|
| 0 |
| 1 |
SELECT 2