trend.sql


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

.mode column
.header on
.nullvalue NULL
.separator "|"
.width 6 -10 -10 -10 -10

select jvm_type as JVM,
       min(elapsed_time) as 'Min(s)',
       max(elapsed_time) as 'Max(s)',
       avg(elapsed_time) as 'Avg(s)'
       from results
       group by JVM;