openstatus.dev
Openstatus
www.openstatus.dev
1VERSION 0
2
3TAGS http
4
5NODE endpoint
6SQL >
7
8 %
9 SELECT time as day, countMerge(count) as count, countMerge(ok) as ok
10 FROM mv__http_status_45d__v0
11 WHERE
12 monitorId = {{ String(monitorId, '1', required=True) }}
13 GROUP BY day
14 ORDER BY day DESC
15 WITH FILL
16 FROM
17 toStartOfDay(toStartOfDay(toTimeZone(now(), 'UTC')))
18 TO toStartOfDay(
19 date_sub(DAY, 45, now())
20 ) STEP INTERVAL -1 DAY
21 LIMIT {{ Int16(days, 45) }}
22
23
24TYPE ENDPOINT