Hive queries to investigate Chrome 74 vs 75 RUM metrics
ActivePublic
Actions

Authored by • Gilles on Jun 25 2019, 9:02 AM.

Tags

Referenced Files

	F29639739: raw.txt
	Jun 25 2019, 9:02 AM

Subscribers

None

	SELECT
	useragent.browser_family,
	useragent.browser_major,
	PERCENTILE(event.loadEventEnd, 0.5) AS median,
	PERCENTILE(event.loadEventEnd, 0.9) AS p90,
	PERCENTILE(event.loadEventEnd, 0.95) AS p95,
	COUNT(*) AS count
	FROM event.navigationtiming
	WHERE year = 2019
	AND month = 6
	AND day > 15
	AND useragent.browser_family IN ("Chrome", "Chrome Mobile")
	AND useragent.browser_major IN ("74", "75")
	GROUP BY useragent.browser_family, useragent.browser_major;

	SELECT
	useragent.browser_family,
	useragent.browser_major,
	PERCENTILE(event.startTime, 0.5) AS median,
	PERCENTILE(event.startTime, 0.9) AS p90,
	PERCENTILE(event.startTime, 0.95) AS p95,
	COUNT(*) AS count
	FROM event.painttiming
	WHERE year = 2019
	AND month = 6
	AND day > 15
	AND useragent.browser_family IN ("Chrome", "Chrome Mobile")
	AND useragent.browser_major IN ("74", "75")
	AND event.name = 'first-paint'
	GROUP BY useragent.browser_family, useragent.browser_major;

Hive queries to investigate Chrome 74 vs 75 RUM metricsActivePublicActions