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.
434 B 路 20 lines
at incident-api
123456789101112131415161718192021NODE endpointSQL >% SELECT time as day, countMerge(count) as count, countMerge(ok) as ok FROM mv__http_status_7d__v0 WHERE monitorId = {{ String(monitorId, '1', required=True) }} GROUP BY day ORDER BY day DESC WITH FILL FROM toStartOfDay(toStartOfDay(toTimeZone(now(), 'UTC'))) TO toStartOfDay( date_sub(DAY, 7, now()) ) STEP INTERVAL -1 DAYTYPE endpoint