Skip to content

Instantly share code, notes, and snippets.

@andydavies

andydavies/resourcesperpage.sql

Created April 18, 2012 09:17
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 andydavies/2412258 to your computer and use it in GitHub Desktop.
Save andydavies/2412258 to your computer and use it in GitHub Desktop.
Download ZIP
Extracts data to plot a histogram of resources vs count of pages from HTTP Archive data
Raw
resourcesperpage.sql
-- Extracts data to plot histogram of resources vs count of pages from HTTP Archive data
-- For bigger groupings change ROUND(resources, 0): -1 = 10, -2 = 100
SELECT ROUND(resources, 0) AS ResourcesPerPage,
COUNT(*) AS Pages
FROM (select count(*) as resources from requests group by pageid) as temp
GROUP BY ResourcesPerPage;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment