Skip to content

Instantly share code, notes, and snippets.

@asvinours

asvinours/dom_content_loaded PH

Last active February 13, 2018 02:42
Show Gist options
  • Save asvinours/0cc9d1cc919e184d3eb9fdb3bf60e8f9 to your computer and use it in GitHub Desktop.
Save asvinours/0cc9d1cc919e184d3eb9fdb3bf60e8f9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dom_content_loaded PH
# DOMContentLoaded
# Defined by the HTML specification:
#
# "The DOMContentLoaded reports the time when the initial HTML document has been completely loaded and parsed,
# without waiting for stylesheets, images, and subframes to finish loading." - MDN.
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "3G"
==>>> 0.11580000000000001
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "3G"
AND fcp.END <= 3000
==>>> 0.0818
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "4G"
==>>> 0.8830999999999994
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "4G"
AND fcp.END <= 3000
==>>> 0.7888000000000001
Raw
dom_content_loaded YP
# DOMContentLoaded
# Defined by the HTML specification:
#
# "The DOMContentLoaded reports the time when the initial HTML document has been completely loaded and parsed,
# without waiting for stylesheets, images, and subframes to finish loading." - MDN.
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "3G"
==>>> 2017-10: 0.16770000000000004
==>>> 2017-11: 0.18839999999999996
==>>> 2017-12: 0.1833
==>>> 2018-01: 0.19579999999999995
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "3G"
AND fcp.END <= 3000
==>>> 2017-10: 0.13040000000000004
==>>> 2017-11: 0.14459999999999998
==>>> 2017-12: 0.1414
==>>> 2018-01: 0.15280000000000002
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "4G"
==>>> 2017-10: 0.8320999999999995
==>>> 2017-11: 0.8113999999999997
==>>> 2017-12: 0.8170999999999998
==>>> 2018-01: 0.8042999999999998
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(dom_content_loaded.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "4G"
AND fcp.END <= 3000
==>>> 2017-10: 0.7696
==>>> 2017-11: 0.7472
==>>> 2017-12: 0.7646
==>>> 2018-01: 0.7503999999999998
Raw
first_contentful_paint PH
# First Contentful Paint
# Defined by the Paint Timing API and available in Chrome M60+:
#
# "First Contentful Paint reports the time when the browser first rendered any text, image (including background images),
# non-white canvas or SVG. This includes text with pending webfonts. This is the first time users could start consuming
# page content."
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "3G"
==>>> 0.1176
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "3G"
AND fcp.END <= 1000
==>>> 0.0334
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "3G"
AND fcp.END <= 2000
==>>> 0.0731
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "4G"
==>>> 0.8819999999999992
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "4G"
AND fcp.END <= 1000
==>>> 0.4594000000000001
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.pornhub.com"
AND effective_connection_type.name = "4G"
AND fcp.END <= 2000
==>>> 0.7767999999999999
Raw
first_contentful_paint YP
# First Contentful Paint
# Defined by the Paint Timing API and available in Chrome M60+:
#
# "First Contentful Paint reports the time when the browser first rendered any text, image (including background images),
# non-white canvas or SVG. This includes text with pending webfonts. This is the first time users could start consuming
# page content."
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "3G"
==>>> 2017-10: 0.17109999999999997
==>>> 2017-11: 0.19090000000000001
==>>> 2017-12: 0.1829
==>>> 2018-01: 0.19520000000000004
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "3G"
AND fcp.END <= 1000
==>>> 2017-10: 0.0571
==>>> 2017-11: 0.06219999999999999
==>>> 2017-12: 0.0645
==>>> 2018-01: 0.0708
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "3G"
AND fcp.END <= 2000
==>>> 2017-10: 0.1158
==>>> 2017-11: 0.12689999999999999
==>>> 2017-12: 0.12489999999999998
==>>> 2018-01: 0.1342
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "4G"
==>>> 2017-10: 0.82849999999999957
==>>> 2017-11: 0.8088999999999995
==>>> 2017-12: 0.8171999999999997
==>>> 2018-01: 0.8039
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "4G"
AND fcp.END <= 1000
==>>> 2017-10: 0.5163000000000001
==>>> 2017-11: 0.49169999999999997
==>>> 2017-12: 0.5317
==>>> 2018-01: 0.5215000000000001
----------
SELECT
SUM(fcp.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
origin = "https://www.youporn.com"
AND effective_connection_type.name = "4G"
AND fcp.END <= 2000
==>>> 2017-10: 0.7442000000000001
==>>> 2017-11: 0.7225999999999999
==>>> 2017-12: 0.7426999999999999
==>>> 2018-01: 0.7291000000000001
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment