Skip to content

Instantly share code, notes, and snippets.

@aaronpeters
Created August 25, 2023 15:24
Show Gist options
  • Save aaronpeters/0810c1dfc43abe4d7e128f5f12faefe6 to your computer and use it in GitHub Desktop.
Save aaronpeters/0810c1dfc43abe4d7e128f5f12faefe6 to your computer and use it in GitHub Desktop.
HTTP Archive: number of pages with cache-control: no-store
SELECT
_TABLE_SUFFIX AS client,
count(DISTINCT pageid) AS pages,
pages_total,
count(DISTINCT pageid) / pages_total AS pages_pct,
FROM
`httparchive.summary_requests.2021_08_01_*`
JOIN
(SELECT _TABLE_SUFFIX, COUNT(DISTINCT pageid) AS pages_total FROM `httparchive.summary_requests.2021_08_01_*` GROUP BY _TABLE_SUFFIX)
USING (_TABLE_SUFFIX)
WHERE
LOWER(resp_cache_control) LIKE '%no-store%' AND
firstHTML
GROUP BY
_TABLE_SUFFIX,
pages_total
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment