Open-source status page, incident response and uptime monitoring
TypeScript alertingincident-managementmcpmcp-servermonitoringmonitoring-as-codeobservabilityon-callopen-sourcesrestatus-pagestatuspagesynthetic-monitoringterraformtinybirdtursouptimeuptime-checkeruptime-monitor
NODE aggregate
SQL >
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,
id
TYPE materialized
DATASOURCE mv__external_status_daily__v0