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 2
| json_object_agg |
|---|
| { "xxx" : ["2018-07-26T11:42:04.514", "2018-07-26T11:52:04.514"], "yyy" : ["2018-07-26T05:42:09.21", "2018-07-26T07:22:04.024"] } |
SELECT 1