Selectivity Sweep

kselavg_time
70.00020.1721
70.14290.1749
70.16670.1745
70.20000.1747
70.25000.1744
70.33330.1753
70.50000.1747
71.00000.1699
80.00000.1965
80.12500.1970
80.14290.1963
80.16670.1965
80.20000.1969
80.25000.1965
80.33330.1970
80.50000.1977
81.00000.1962
90.00000.2368
90.11110.2396
90.12500.2391
90.14290.2397
90.16670.2392
90.20000.2394
90.25000.2385
90.33330.2390
90.50000.2393
91.00000.2383
100.00000.3817
100.10000.3831
100.11110.3821
100.12500.3845
100.14290.3818
100.16670.3827
100.20000.3822
100.25000.3832
100.33330.3837
100.50000.3821
101.00000.3958
download as csv
SELECT d_k AS k, d_sel AS sel, AVG(1000*d_time/(d_decisions/2)) AS avg_time
FROM exp_data_22
GROUP BY d_k, d_sel
ORDER BY d_k ASC, d_sel ASC