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 6
arrive_date | arrive_timeday | arrive_location | jsonb_object_agg |
---|---|---|---|
2018-05-30 00:00:00 | 0 | location_00 | {"3": 10} |
2018-05-30 00:00:00 | 2 | location_00 | {"1": 3, "5": 2} |
2018-05-31 00:00:00 | 2 | location_00 | {"4": 7} |
2018-05-31 00:00:00 | 4 | location_00 | {"2": 3} |
SELECT 4
CREATE TABLE
INSERT 0 6
arrive_date | arrive_timeday | arrive_location | jsonb_object_agg |
---|---|---|---|
2018-05-30 00:00:00 | 0 | location_00 | {"3": 8} |
2018-05-30 00:00:00 | 2 | location_00 | {"1": 3, "5": 2} |
2018-05-31 00:00:00 | 2 | location_00 | {"4": 7} |
2018-05-31 00:00:00 | 4 | location_00 | {"2": 3} |
SELECT 4