add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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