SQLize Online / PHPize Online  /  SQLtest Online

create table tabl ( id serial, sort integer, pos_changed_at timestamp ); INSERT INTO tabl (sort, pos_changed_at) VALUES ( 1, CURRENT_TIMESTAMP + interval '1 hour' ), ( 2, CURRENT_TIMESTAMP + interval '2 hour' ), ( 3, CURRENT_TIMESTAMP + interval '3 hour' ), ( 3, CURRENT_TIMESTAMP + interval '2 hour' ), (1, '2022-09-14 05:31:30.42803'); EXPLAIN SELECT * FROM tabl ORDER BY sort, pos_changed_at; CREATE INDEX my_index ON tabl (sort, pos_changed_at); EXPLAIN SELECT * FROM tabl ORDER BY sort, pos_changed_at;