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.
511 B · 19 lines
1234567891011121314151617181920NODE aggregateSQL > SELECT toStartOfDay(toTimeZone(fromUnixTimestamp64Milli(cronTimestamp), 'UTC')) AS time, monitorId, countState() AS count, countState(if(requestStatus = 'success', 1, NULL)) AS success, countState(if(requestStatus = 'error', 1, NULL)) AS error, countState(if(requestStatus = 'degraded', 1, NULL)) AS degraded FROM ping_response__v8 GROUP BY time, monitorIdTYPE materializedDATASOURCE mv__http_status_45d__v1