-
-
Notifications
You must be signed in to change notification settings - Fork 209
Expand file tree
/
Copy pathsizes_and_savings.sql
More file actions
27 lines (26 loc) · 2.04 KB
/
sizes_and_savings.sql
File metadata and controls
27 lines (26 loc) · 2.04 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
# Query to get raw size, striped and optimized size distribution by client and percentile
SELECT
percentile,
client,
APPROX_QUANTILES(SAFE_CAST(JSON_VALUE(payload._wasm_stats.raw_size) AS INT64), 1000)[OFFSET(percentile * 10)] AS raw_size,
APPROX_QUANTILES(SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total) AS INT64), 1000)[OFFSET(percentile * 10)] AS size_total,
APPROX_QUANTILES(SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_br) AS INT64), 1000)[OFFSET(percentile * 10)] AS size_total_br,
APPROX_QUANTILES(SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_strip) AS INT64), 1000)[OFFSET(percentile * 10)] AS size_total_strip,
APPROX_QUANTILES(SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_strip_br) AS INT64), 1000)[OFFSET(percentile * 10)] AS size_total_strip_br,
APPROX_QUANTILES(SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_opt) AS INT64), 1000)[OFFSET(percentile * 10)] AS size_total_opt,
APPROX_QUANTILES(SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_opt_br) AS INT64), 1000)[OFFSET(percentile * 10)] AS size_total_opt_br,
APPROX_QUANTILES((SAFE_CAST(JSON_VALUE(payload._wasm_stats.raw_size) AS INT64) - SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_br) AS INT64)), 1000)[OFFSET(percentile * 10)] AS br_savings,
APPROX_QUANTILES((SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_br) AS INT64) - SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_strip_br) AS INT64)), 1000)[OFFSET(percentile * 10)] AS strip_br_savings,
APPROX_QUANTILES((SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_strip_br) AS INT64) - SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_opt_br) AS INT64)), 1000)[OFFSET(percentile * 10)] AS opt_br_savings,
APPROX_QUANTILES((SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_strip) AS INT64) - SAFE_CAST(JSON_VALUE(payload._wasm_stats.size.total_opt) AS INT64)), 1000)[OFFSET(percentile * 10)] AS opt_savings
FROM
`httparchive.crawl.requests`,
UNNEST([0, 10, 25, 50, 75, 90, 100]) AS percentile
WHERE
date = '2025-07-01'
GROUP BY
percentile,
client
ORDER BY
percentile,
client