Skip to content

Instantly share code, notes, and snippets.

@hellais
Created November 11, 2016 13:47
Show Gist options
  • Save hellais/ba6c5743ba3f7e78e2ca1193055ec2e8 to your computer and use it in GitHub Desktop.
Save hellais/ba6c5743ba3f7e78e2ca1193055ec2e8 to your computer and use it in GitHub Desktop.
find anomalies for web_connectivity
SELECT
id,
input,
probe_cc,
probe_asn,
report_id,
measurement_start_time,
test_start_time,
test_runtime,
test_keys->'blocking' AS blocking,
test_keys->'accessible' AS accessible
FROM metrics
WHERE test_name='web_connectivity' AND
test_start_time >= TIMESTAMP '2016-01-01';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment