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.
520 B · 17 lines
123456789101112131415161718NODE aggregateSQL > SELECT toStartOfFifteenMinutes(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_15m__v0