Skip to content

Open-source status page, incident response and uptime monitoring

350 B
Raw Blame
NODE aggregate
SQL >

    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,
        monitorId

TYPE materialized
DATASOURCE mv__http_status_45d__v0