mirror of
https://github.com/vladtrc/iw4L
synced 2026-10-26 02:11:39 -04:00
vtroc
11 lines
278 B
SQL
11 lines
278 B
SQL
-- All duration slices. Agents start here; order is total time, not name.
|
|
SELECT
|
|
name,
|
|
COUNT(*) AS n,
|
|
CAST(AVG(dur) / 1e6 AS REAL) AS avg_ms,
|
|
CAST(MAX(dur) / 1e6 AS REAL) AS max_ms,
|
|
CAST(SUM(dur) / 1e6 AS REAL) AS sum_ms
|
|
FROM slice
|
|
GROUP BY name
|
|
ORDER BY sum_ms DESC;
|