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?.
1 rows affected
| id | jsoncolumn |
|---|---|
| ID1123312 | {"a": [{"a1": "2022-01-01", "a2": "2026-01-31", "a3": 1}], "b": [{"b1": "J", "b2": "1231342138adc2fehj3j21321321321kjk1423j32k9"}], "c": [{"c1-1": "2021-02-01", "c1-2": "2021-01-01"}, {"c2-1": "2021-04-01", "c2-2": "2021-03-01"}]} |