openstatus.dev
Openstatus
www.openstatus.dev
1TAGS "dns"
2
3NODE endpoint
4SQL >
5
6 %
7 SELECT
8 toStartOfInterval(
9 toDateTime(cronTimestamp / 1000), INTERVAL {{ Int64(interval, 30) }} MINUTE
10 ) as h,
11 monitorId,
12 toUnixTimestamp64Milli(toDateTime64(h, 3)) as timestamp,
13 round(quantile(0.50)(latency)) as p50Latency,
14 round(quantile(0.75)(latency)) as p75Latency,
15 round(quantile(0.90)(latency)) as p90Latency,
16 round(quantile(0.95)(latency)) as p95Latency,
17 round(quantile(0.99)(latency)) as p99Latency
18 FROM dns_response__v0
19 WHERE
20 monitorId IN {{ Array(monitorIds, 'String', '7417') }}
21 AND timestamp >= toUnixTimestamp64Milli(toDateTime64(now() - INTERVAL 1 DAY, 3))
22 GROUP BY h, monitorId
23 ORDER BY h ASC
24
25
26TYPE ENDPOINT