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?.
| created_at | latitude | longitude | trip_log_id |
|---|---|---|---|
| 2018-10-11T15:16:32.775 | 52.504873 | 13.396681 | 1 |
| 2018-10-11T15:16:32.807 | 52.505225 | 13.396976 | 1 |
| 2018-10-11T15:16:32.835 | 52.505372 | 13.397035 | 1 |
| 2018-10-11T11:22:54.666 | 52.5242370846803 | 13.3443558528637 | 2 |
| 2018-10-11T11:22:54.727 | 52.5242366166393 | 13.3443558656828 | 2 |
SELECT 5
| json_agg |
|---|
| [[{"recorded_at" : "2018-10-11T15:16:32.775", "latitude" : 52.504873, "longitude" : 13.396681}, {"recorded_at" : "2018-10-11T15:16:32.807", "latitude" : 52.505225, "longitude" : 13.396976}, {"recorded_at" : "2018-10-11T15:16:32.835", "latitude" : 52.505372, "longitude" : 13.397035}], [{"recorded_at" : "2018-10-11T11:22:54.666", "latitude" : 52.5242370846803, "longitude" : 13.3443558528637}, {"recorded_at" : "2018-10-11T11:22:54.727", "latitude" : 52.5242366166393, "longitude" : 13.3443558656828}]] |
SELECT 1