Openstatus
www.openstatus.dev
1TAGS "http"
2
3NODE endpoint
4SQL >
5
6 %
7 SELECT
8 toStartOfInterval(time, INTERVAL {{ String(interval, '30', required=True) }} minute) AS interval,
9 countIf(requestStatus = 'success') AS success,
10 countIf(requestStatus = 'degraded') AS degraded,
11 countIf(requestStatus = 'error') AS error
12 FROM mv__http_uptime_7d__v1
13 WHERE
14 monitorId = {{ String(monitorId, '1', required=True) }}
15 {% if fromDate %} AND time >= parseDateTimeBestEffortOrNull({{ String(fromDate) }}) {% end %}
16 {% if toDate %} AND time <= parseDateTimeBestEffortOrNull({{ String(toDate) }}) {% end %}
17 {% if regions %} AND region IN {{ Array(regions, 'String', 'ams,fra') }} {% end %}
18 GROUP BY interval
19 ORDER BY interval DESC
20
21
22TYPE ENDPOINT