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
| arrive_date | arrive_location | jsonb_object_agg |
|---|---|---|
| 2018-05-31 00:00:00+01 | location_00 | {"2": 3, "4": 7} |
| 2018-05-30 00:00:00+01 | location_00 | {"1": 3, "3": 10, "5": 2} |