-- SaferPage scan_results performance indexes
-- Version: scan-results-performance-indexes-2026-06-10
-- Scope: public report, monitoring, radar and benchmark read paths.

create index concurrently if not exists scan_results_lower_host_created_idx
    on scan_results (lower(host), created_at desc);

create index concurrently if not exists scan_results_created_idx
    on scan_results (created_at desc);
