jmaher

{'06a61ba9c44415c7e84eb2c1548f53a95bd651e0': ['test-linux64-shippable-qr/opt-raptor-tp6-28-firefox-cold-e10s', 'test-linux64-shippable/opt-raptor-tp6-28-firefox-cold-e10s', 'test-macosx1014-64-shippable/opt-raptor-tp6-28-firefox-cold-e10s'], 'd28ceb16f6839c79662e1eb355584d87a9810d60': ['test-linux64-shippable-qr/opt-raptor-ares6-firefox-e10s', 'test-linux64-shippable-qr/opt-raptor-speedometer-firefox-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-13-firefox-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-25-firefox-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-webaudio-firefox-e10s', 'test-linux64-shippable/opt-raptor-motionmark-htmlsuite-firefox-e10s', 'test-linux64-shippable/opt-raptor-speedometer-firefox-e10s', 'test-linux64-shippable/opt-raptor-stylebench-firefox-e10s', 'test-linux64-shippable/opt-raptor-tp6-13-firefox-cold-e10s', 'test-linux64-shippable/opt-raptor-webaudio-firefox-e10s', 'test-macosx1014-64-shippable/opt-raptor-webaudio-firefox-e10s', 'test-windows10-64-shippable-qr/opt-rapto

jmaher

{'dbaa47665f9a2693efa9bbafef7133f6c8278ee0': ['test-linux64-shippable-qr/opt-raptor-tp6-18-firefox-cold-e10s', 'test-windows7-32-shippable/opt-raptor-tp6-24-firefox-cold-e10s', 'test-windows7-32-shippable/opt-raptor-tp6-27-firefox-cold-e10s'], '06a61ba9c44415c7e84eb2c1548f53a95bd651e0': ['test-linux64-shippable-qr/opt-raptor-tp6-28-firefox-cold-e10s', 'test-linux64-shippable/opt-raptor-tp6-28-firefox-cold-e10s', 'test-macosx1014-64-shippable/opt-raptor-tp6-28-firefox-cold-e10s'], '45c58c03f69e7cf6f9bb567bdcc0580b31d92ce5': ['test-android-hw-p2-8-0-android-aarch64/pgo-raptor-tp6m-23-geckoview-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-11-firefox-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-17-firefox-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-22-firefox-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-3-firefox-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-30-firefox-cold-e10s', 'test-linux64-shippable-qr/opt-raptor-tp6-7-firefox-cold-e10s', 'test-linux64-shippable/o

jmaher

SET @frameworks = 'raptor,browsertime,talos,awsy';

select
    perf_summary.revision,
    job_type.name
FROM (
  select
    distinct push.revision as revision,
    summary.push_id as push_id,
    summary.repository_id as repository_id,

jmaher

DECLARE start_date DATE DEFAULT "2020-01-01";
DECLARE end_date DATE DEFAULT "2020-06-01";
-- granularity is date_part: ideally 'day' or 'month', could be 'week'
DECLARE granularity STRING DEFAULT "month";
DECLARE types ARRAY <STRING>;
set types = ['t-linux-large', 't-linux-xlarge', 'gecko-t/t-linux-xlarge', 'gecko-t/t-linux-large', 'gecko-t/t-win10-64', 'gecko-t/t-win10-64-gpu-s', 'gecko-t/t-win7-32', 'gecko-t/t-win7-32-gpu'];
-- set types = ['gecko-t/t-linux-large', 't-linux-large'];

SELECT
    CASE

jmaher

DECLARE start_date DATE DEFAULT "2020-01-01";
DECLARE end_date DATE DEFAULT "2020-06-01";
-- granularity is date_part: ideally 'day' or 'month', could be 'week'
DECLARE granularity STRING DEFAULT "month";
DECLARE types ARRAY <STRING>;
set types = ['t-linux-large', 't-linux-xlarge', 'gecko-t/t-linux-xlarge', 'gecko-t/t-linux-large', 'gecko-t/t-win10-64', 'gecko-t/t-win10-64-gpu-s', 'gecko-t/t-win7-32', 'gecko-t/t-win7-32-gpu'];

CREATE TEMP FUNCTION
  summary(a ARRAY<STRUCT<timestamp TIMESTAMP,
    eventType STRING>>)

jmaher

DECLARE start_date DATE DEFAULT "2020-01-01";
DECLARE end_date DATE DEFAULT "2020-06-01";
-- granularity is date_part: ideally 'day' or 'month', could be 'week'
DECLARE granularity STRING DEFAULT "month";
DECLARE types ARRAY <STRING>;
set types = ['t-linux-large', 't-linux-xlarge', 'gecko-t/t-linux-xlarge', 'gecko-t/t-linux-large', 'gecko-t/t-win10-64', 'gecko-t/t-win10-64-gpu-s', 'gecko-t/t-win7-32', 'gecko-t/t-win7-32-gpu'];

CREATE TEMP FUNCTION
  summary(a ARRAY<STRUCT<timestamp TIMESTAMP,
    eventType STRING>>)

jmaher

SET @frameworks = 'raptor,browsertime,talos,awsy';

SELECT summary.bug_number AS bug_number,
    alert.created,
    alert.is_regression,
    commit.revision,
    job_type.name
FROM performance_alert AS alert
INNER JOIN performance_alert_summary AS summary ON ((alert.related_summary_id IS NULL AND summary.id = alert.summary_id) OR summary.id = alert.related_summary_id)
INNER JOIN performance_alert_summary AS original_summary ON original_summary.id = alert.summary_id

jmaher

DECLARE start_date DATE DEFAULT "2020-01-01";
DECLARE end_date DATE DEFAULT "2020-06-01";
-- granularity is date_part: ideally 'day' or 'month', could be 'week'
DECLARE granularity STRING DEFAULT "month";
DECLARE types ARRAY <STRING>;
set types = ['t-linux-large', 't-linux-xlarge', 'gecko-t/t-linux-xlarge', 'gecko-t/t-linux-large', 'gecko-t/t-win10-64', 'gecko-t/t-win10-64-gpu-s', 'gecko-t/t-win7-32', 'gecko-t/t-win7-32-gpu'];

CREATE TEMP FUNCTION
  summary(a ARRAY<STRUCT<timestamp TIMESTAMP,
    eventType STRING>>)

jmaher

BUILD SUCCESSFUL in 27s
47 actionable tasks: 3 executed, 44 up-to-date
 0:48.57 adb INFO Using adb 1.0.41
 0:49.02 adb INFO adbd not restarted as root
 0:49.23 adb INFO su -c setenforce 0 exitcode 0, stdout: None
 0:50.07 adb INFO /system/bin/ls -1A supported
 0:50.29 adb INFO Native cp support: True
 0:50.50 adb INFO Native chmod -R support: True
 0:50.71 adb INFO Native chown -R support: True
 0:50.93 adb INFO Setting SELinux Permissive

jmaher

DECLARE start_date DATE DEFAULT "2020-04-20";
DECLARE end_date DATE DEFAULT "2020-04-24";
-- granularity is date_part: ideally 'day' or 'month', could be 'week'
DECLARE granularity STRING DEFAULT "day";
DECLARE types ARRAY <STRING>;
set types = ['gecko-t/t-linux-xlarge', 'gecko-t/t-linux-large', 'gecko-t/t-win10-64', 'gecko-t/t-win10-64-gpu-s', 'gecko-t/t-win7-32', 'gecko-t/t-win7-32-gpu'];
set types = ['gecko-t/t-win10-64-gpu-s'];

SELECT 
  orphaned.date,