Toot-Worker/migrations/0003_perf_indexes.sql

CREATE INDEX IF NOT EXISTS idx_statuses_visibility_time ON statuses(visibility, created_at DESC);
CREATE INDEX IF NOT EXISTS idx_statuses_reply_time ON statuses(in_reply_to_id, created_at ASC);
CREATE INDEX IF NOT EXISTS idx_media_status_time ON media(status_id, created_at ASC);