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?.
| json_agg |
|---|
| [[{"id" : "4", "type" : "B"}], [{"id" : "2", "type" : "A"},{"id" : "3", "type" : "A"}], [{"id" : "1", "type" : "A"}]] |
SELECT 1