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?.
2 rows affected
| id | json_info |
|---|---|
| 0 | [{"name" : "john", "gender" : "m", "birth_date" : "25.01.1980"}, {"name" : "steve", "gender" : "m", "birth_date" : "12.12.1995"}, {"name" : "kate", "gender" : "f", "birth_date" : "17.04.1990"}] |
| 1 | [{"name" : "max", "gender" : "m", "birth_date" : "26.01.1980"}, {"name" : "sarah", "gender" : "f", "birth_date" : "18.04.1990"}] |