Updating the percentiles distribution for April 2019:
SELECT * FROM
(SELECT 'desktop' type,
round(avg(reqTotal)) average,
NTH(50, quantiles(reqTotal)) p50,
NTH(75, quantiles(reqTotal)) p75,
NTH(90, quantiles(reqTotal)) p90,
NTH(99, quantiles(reqTotal)) p99
FROM [httparchive:runs.latest_pages]),
(SELECT 'mobile' type,
round(avg(reqTotal)) average,
NTH(50, quantiles(reqTotal)) p50,
NTH(75, quantiles(reqTotal)) p75,
NTH(90, quantiles(reqTotal)) p90,
NTH(99, quantiles(reqTotal)) p99
FROM [httparchive:runs.latest_pages_mobile]);
Row | type | average | p50 | p75 | p90 | p99 | |
---|---|---|---|---|---|---|---|
1 | mobile | 98.0 | 77 | 126 | 190 | 377 | |
2 | desktop | 107.0 | 84 | 136 | 206 | 429 |