Add fastest results report.

Cleanup SQL formatting in existing report code too.

3 files changed, 23 insertions, 10 deletions

diff --git a/fastest.sql b/fastest.sql
new file mode 100644
index 0000000..ddda640
--- /dev/null
+++ b/fastest.sql
@@ -0,0 +1,5 @@
+SELECT
+  set,script,scale,clients,workers,
+  round(tps) as tps
+FROM tests
+ORDER BY tps DESC LIMIT 20;
diff --git a/report.sql b/report.sql
index 9dd2065..0504799 100644
--- a/report.sql
+++ b/report.sql
@@ -1 +1,9 @@
-select set,scale,test,script,clients,workers,round(tps) as tps,round(1000*avg_latency)/1000 as avg_latency,round(1000*percentile_90_latency)/1000 as "90%<",1000*round(max_latency)/1000 as max_latency,trans from tests order by set,scale,script,clients,test; 
+SELECT
+  set,scale,test,script,clients,workers,
+  round(tps) AS tps,
+  round(1000*avg_latency)/1000 AS avg_latency,
+  round(1000*percentile_90_latency)/1000 AS "90%<",
+  1000*round(max_latency)/1000 AS max_latency,
+  trans
+FROM tests
+ORDER BY set,scale,script,clients,test; 
diff --git a/summary.sql b/summary.sql
index 80aa8ed..e74d4d0 100644
--- a/summary.sql
+++ b/summary.sql
@@ -1,12 +1,12 @@
-select 
+SELECT
   set,scale,
-  pg_size_pretty(avg(dbsize)::int8) as db_size,
+  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; 
+  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;