oott/backend/database_migrations/07-add_devices_indexes/up.sql

CREATE INDEX idx_devices_is_registered ON devices (is_registered);
CREATE INDEX idx_devices_last_seen_is_registered ON devices (last_seen, is_registered);