Trying to take a look at service worker usage by CDN provider, and ran the following queryy:
SELECT _cdn_provider, respSize FROM `httparchive.almanac.service_workers` JOIN `httparchive.almanac.requests` USING (page), UNNEST([10, 25, 50, 75, 90]) AS percentile ORDER BY _cdn_provider
Unfortunately, I’m having a hard time deciphering the results. It shows many different instances of each CDN with varying values, so I’m not sure how to handle that. Also, is each value the total amount of MB served over service workers by the given CDN?
Also, the USING… percentile portion is there unnecessarily, but I cannot find a substitute to put there so that it runs properly. I started with the PWA report’s query code for SW size by client (desktop or mobile) but I tried altering it to be by CDN here.