clickhouse.json
· 377 B · JSON
Raw
{
"params": {
"rounding": "120",
"seconds": "7200"
},
"queries": [
{
"title": "Request rate",
"query": "SELECT\n toStartOfInterval(ts, INTERVAL {rounding:UInt32} SECOND)::Int64 AS t,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ts >= now() - {seconds:UInt32}\nGROUP BY t\nORDER BY t\nWITH FILL STEP {rounding:UInt32}\n"
}
]
}
| 1 | { |
| 2 | "params": { |
| 3 | "rounding": "120", |
| 4 | "seconds": "7200" |
| 5 | }, |
| 6 | "queries": [ |
| 7 | { |
| 8 | "title": "Request rate", |
| 9 | "query": "SELECT\n toStartOfInterval(ts, INTERVAL {rounding:UInt32} SECOND)::Int64 AS t,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ts >= now() - {seconds:UInt32}\nGROUP BY t\nORDER BY t\nWITH FILL STEP {rounding:UInt32}\n" |
| 10 | } |
| 11 | ] |
| 12 | } |