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 15
traj_id | timestamp | height | lat | lon | ct0 |
---|---|---|---|---|---|
1 | 2006-01-01 | 10 | 34.55 | -70.8 | 0 |
1 | 2006-01-02 | 9 | 34.56 | -70.88 | 0 |
2 | 2006-01-01 | 10 | 34.55 | -70.8 | 0 |
2 | 2006-01-02 | 5 | 34.55 | -70.82 | 0 |
2 | 2006-01-03 | 3 | 34.54 | -70.89 | 0 |
3 | 2006-01-01 | 10 | 34.55 | -70.8 | 0 |
3 | 2006-01-01 | 9 | 34.56 | -70.75 | 0 |
3 | 2006-01-01 | 11 | 34.54 | -70.9 | 0 |
3 | 2006-01-01 | 15 | 34.6 | -70.95 | 0 |
3 | 2006-01-01 | 30 | 34.67 | -70.9 | 0 |
SELECT 10