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.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid