-- Composite index untuk getRecentFailures & query (connection_status, attempt_timestamp).
-- Jalankan sekali. Jika error "Duplicate key name", indeks sudah ada — abaikan.

CREATE INDEX idx_connection_attempts_status_timestamp ON connection_attempts (connection_status, attempt_timestamp);