-- CreateIndex
CREATE INDEX "checkrun_service_metrics_comprehensive" ON "public"."CheckRun"("serviceId", "at", "status", "latencyMs");

-- CreateIndex
CREATE INDEX "checkrun_service_error_analysis" ON "public"."CheckRun"("serviceId", "status", "error", "at");

-- CreateIndex
CREATE INDEX "checkrun_service_http_analysis" ON "public"."CheckRun"("serviceId", "at", "httpCode");

-- CreateIndex
CREATE INDEX "checkrun_timerange_service_filter" ON "public"."CheckRun"("at", "serviceId", "status");

-- CreateIndex
CREATE INDEX "checkrun_service_recent_first" ON "public"."CheckRun"("serviceId", "at" DESC);

-- CreateIndex
CREATE INDEX "checkrun_service_failures_recent" ON "public"."CheckRun"("serviceId", "status", "at" DESC);
