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.
349 B 路 17 lines
123456789101112131415161718NODE aggregateSQL > SELECT toStartOfDay(toTimeZone(fromUnixTimestamp64Milli(cronTimestamp), 'UTC')) AS time, monitorId, countState() AS count, countState(if(error = 0, 1, NULL)) AS ok FROM ping_response__v8 GROUP BY time, monitorIdTYPE materializedDATASOURCE mv__http_status_7d__v0