Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P8651
Hive queries to investigate Chrome 74 vs 75 RUM metrics
Active
Public
Actions
Authored by
•
Gilles
on Jun 25 2019, 9:02 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
Performance-Team
Referenced Files
F29639739: raw.txt
Jun 25 2019, 9:02 AM
2019-06-25 09:02:42 (UTC+0)
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
;
Event Timeline
•
Gilles
created this paste.
Jun 25 2019, 9:02 AM
2019-06-25 09:02:42 (UTC+0)
•
Gilles
mentioned this in
T225403: Investigate increase in First Visual Change mobile enwiki
.
Log In to Comment