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?.
CREATE TABLE
INSERT 0 3
CREATE TABLE
INSERT 0 5
CREATE TABLE
INSERT 0 3
| json_agg |
|---|
| [{"id" : 1, "text" : "foo"}] |
| [{"id" : 1, "text" : "foo"}, {"id" : 2, "text" : "bar"}, {"id" : 3, "text" : "baz"}] |
SELECT 2