Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/openstatusHQ/openstatus. 馃珫 Status page with uptime monitoring & API monitoring as code 馃珫 openstatus.dev
bun drizzle-orm monitoring monitoring-as-code nextjs observability on-call open-source shadcn-ui status-page statuspage synthetic-monitoring tinybird turso uptime uptime-checker uptime-monitor
Something went wrong. Try again.
619 B 路 23 lines
123456789101112131415161718192021222324NODE aggregateSQL > WITH if(requestStatus = 'success', 1, NULL) AS is_success, if(requestStatus = 'degraded', 1, NULL) AS is_degraded, if(requestStatus = 'error', 1, NULL) AS is_error SELECT toStartOfDay(toTimeZone(fromUnixTimestamp64Milli(cronTimestamp), 'UTC')) AS time, monitorId, countState() AS total, countState(is_success) AS success, countState(is_degraded) AS degraded, countState(is_error) AS error FROM ping_response__v8 GROUP BY time, monitorIdTYPE materializedDATASOURCE mv__http_status_14d__v0