github.com/dolthub/dolt/go@v0.40.5-0.20240520175717-68db7794bea6/performance/sysbench/reporting/systab_summary.sql (about)

     1  select round(avg(mean_mult),2) as avg
     2  from (
     3    select
     4      round(first_value(avg) over w, 2) as mean,
     5      trim(TRAILING '.gen.lua' FROM trim(LEADING 'gen/' FROM test_name)) as name,
     6      round(avg / lead(avg) over w, 2) as mean_mult,
     7      round(median / lead(median) over w, 2) as med_mult,
     8      round(sqrt(power(first_value(stdd) over w, 2) + power(last_value(stdd) over w, 2)), 3) as stdd,
     9      row_number() over w     as rn
    10    from sysbench_results
    11    having mod(rn,2) = 1
    12    window w as (order by test_name rows between CURRENT ROW and 1 following)
    13  ) sq;