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

     1  select name, detail, mean_mult
     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      detail,
     7      round(avg / lead(avg) over w, 2) as mean_mult,
     8      round(median / lead(median) over w, 2) as med_mult,
     9      round(sqrt(power(first_value(stdd) over w, 2) + power(last_value(stdd) over w, 2)), 3) as stdd,
    10      row_number() over w     as rn
    11    from sysbench_results
    12    having mod(rn,2) = 1
    13    window w as (order by test_name, detail rows between CURRENT ROW and 1 following)
    14  ) sq;