Skip to content

Instantly share code, notes, and snippets.

@micmro

micmro/third-party-calls.sql

Last active August 29, 2015 14:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save micmro/c029cdaf78055abca02b to your computer and use it in GitHub Desktop.
Save micmro/c029cdaf78055abca02b to your computer and use it in GitHub Desktop.
Download ZIP
bigQuery HTTP Archive - requests
Raw
third-party-calls.sql
/* WIP - not working yet */
SELECT
NTH(10, num_requests) thenth,
NTH(25, num_requests) twenty_fifth,
NTH(50, num_requests) median,
NTH(75, num_requests) seventy_fifth,
NTH(90, num_requests) ninetieth
FROM(
SELECT COUNT(*) num_requests
FROM [httparchive:runs.latest_requests] as req JOIN (
SELECT DOMAIN(url) self
FROM [httparchive:runs.latest_pages]
) as pages ON pages.self = req.req_host
WHERE DOMAIN(req.url) != pages.self
GROUP BY pages.self
ORDER BY num_requests asc
)
Raw
total-domains.sql
SELECT
NTH(25, quantiles(numDomains,100)) twenty_fifth,
NTH(50, quantiles(numDomains,100)) median,
NTH(75, quantiles(numDomains,100)) seventy_fifth,
NTH(90, quantiles(numDomains,100)) ninetieth
FROM [httparchive:runs.latest_pages]
Raw
total-requests.sql
SELECT
NTH(25, quantiles(reqTotal,100)) twenty_fifth,
NTH(50, quantiles(reqTotal,100)) median,
NTH(75, quantiles(reqTotal,100)) seventy_fifth,
NTH(90, quantiles(reqTotal,100)) ninetieth
FROM [httparchive:runs.latest_pages]
@micmro
Copy link
Author

micmro commented Oct 10, 2014

https://bigquery.cloud.google.com/

Full description:
https://www.igvita.com/2013/06/20/http-archive-bigquery-web-performance-answers
Some inspiration:
https://gist.github.com/igrigorik/5801492

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment