summary.sql


1
2
3
4
5
6
7
8
9
10
11
12

SELECT
  set,scale,
  pg_size_pretty(avg(dbsize)::int8) AS db_size,
  clients,
  round(avg(tps)) as tps,
  round(1000 * avg(avg_latency))/1000 AS avg_latency,
  round(1000 * avg(max_latency))/1000 AS max_latency ,
  round(1000 * avg(percentile_90_latency))/1000 AS "90%<",
  to_char(avg(end_time -  start_time),'HH24:MI:SS') AS runtime
FROM tests 
GROUP BY set,scale,clients 
ORDER BY set,scale,clients;