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?.
6 rows affected
| json_agg |
|---|
| [{"id" : "a0", "children" : [{"id" : "b0", "children" : [{"id" : "c0", "items" : [1]}, {"id" : "c1", "items" : [2, 3]}]}, {"id" : "b1", "children" : [{"id" : "c2", "items" : [4]}]}]}, {"id" : "a1", "children" : [{"id" : "b1", "children" : [{"id" : "c3", "items" : [5]}]}, {"id" : "b2", "children" : [{"id" : "c0", "items" : [6]}]}]}] |