Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F29639607
raw.txt
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
•
Gilles
Jun 25 2019, 8:27 AM
2019-06-25 08:27:51 (UTC+0)
Size
2 KB
Referenced Files
None
Subscribers
None
raw.txt
View Options
SELECT
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 = 24 AND hour >= 14)
OR
day = 25
)
AND
(
(INT(SUBSTR(recvfrom, 3, 4)) >= 5001 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5003)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 5007 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5009)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 1075 AND INT(SUBSTR(recvfrom, 3, 4)) <= 1082)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2001 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2002)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2008)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2010 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2011)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2014)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2017)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 3040 AND INT(SUBSTR(recvfrom, 3, 4)) <= 3047)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 3049)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4024 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4029)
);
SELECT
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 = 24 AND hour >= 14)
OR
day = 25
)
AND
(
(INT(SUBSTR(recvfrom, 3, 4)) >= 5004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5006)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 5010 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5012)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 1083 AND INT(SUBSTR(recvfrom, 3, 4)) <= 1090)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2012 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2013)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2008)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2018 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2026)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2016)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 3032 AND INT(SUBSTR(recvfrom, 3, 4)) <= 3039)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 3030)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4021 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4023)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4030 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4032)
);
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
7675484
Default Alt Text
raw.txt (2 KB)
Attached To
Mode
P8650 Hive queries to check results of SACK A/B test
Attached
Detach File
Event Timeline
Log In to Comment