Latency stats per log level

Latency stats per log level

From logs(level, latency_ms) compute the average and maximum latency for each log level. Return columns level, avg_latency (average latency_ms rounded to 2 decimals) and max_latency (max latency_ms). Order by level ascending.

Expected output sample

levelavg_latencymax_latency
ERROR813.331200
INFO21.250
WARN22.530
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid