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.
762 B ยท 28 lines
at incident-api
1234567891011121314151617181920212223242526272829NODE aggregateSQL > SELECT toDate(toTimeZone(fromUnixTimestamp64Milli(fetched_at), 'UTC')) AS day, id, argMaxState( indicator, toUInt8( multiIf( indicator = 'critical', 3, indicator = 'major', 2, indicator = 'minor', 1, 0 ) ) ) AS worst_indicator, maxState(toUInt8(status = 'under_maintenance')) AS had_maintenance, sumState(toUInt32(1)) AS snapshot_count FROM external_status__v1 GROUP BY day, idTYPE materializedDATASOURCE mv__external_status_daily__v0