data input:
List of Product Versions
nightly aurora beta release 29.0a1 28.0a2 27.0b 26.0
ADI
select date, sum(adu_count), product_version from raw_adu where product_name = 'Firefox' and product_version = '29.0a1' and
date = '2014-01-21' group by product_version, date ;
\pset fieldsep ,
\pset format unaligned
\t
\o /tmp/adi.csv
select
date,
sum(adu_count) as adu_count,
product_version
from raw_adu
where product_name = 'Firefox' and
product_version IN ('29.0a1', '28.0a2')
and date BETWEEN '2013-10-01' and '2014-01-21'
group by product_version, date
order by date
;
\o
crash hadu
SELECT product_name, version_string, report_date, report_count, adu, crash_hadu FROM home_page_graph_view
WHERE product_name='Firefox' AND version_string IN ('29.0a1') AND report_date BETWEEN '2014-01-15'::date AND '2014-01-22'::date
;
\o /tmp/crash_hadu.csv
SELECT version_string,
report_date,
report_count,
adu,
crash_hadu
FROM home_page_graph_view
WHERE product_name ='Firefox' and version_string IN ('29.0a1')
and report_date BETWEEN '2013-10-01' and '2014-01-21'
order by report_date;
\o
startup crashes
\o /tmp/startup_crashes.csv
select count(*), version_string, date_processed::date as report_date
from reports_clean
JOIN product_versions USING (product_version_id)
where uptime < INTERVAL '1 minute'
and date_processed between '2013-10-1 00:00:00+00' and '2014-01-21 00:00:00+00'
and product_name = 'Firefox'
and version_string IN ('29.0a1', '28.0a2')
group by date_processed::date, version_string
order by report_date;
\o
flash hang reports
select count(*) from reports_clean where flash_version_id is not null and date_processed between '2014-01-20 00:00:00+00' and '2014-01-21 00:00:00+00' and product_version_id = 2040 and hang_id is not null;
\o flash_hang.csv
select count(flash_version_id), version_string, date_processed::date as report_date
from reports_clean
JOIN product_versions USING (product_version_id)
where flash_version_id is not null
and hang_id is not null
and date_processed between '2013-10-1 00:00:00+00' and '2014-01-21 00:00:00+00'
and product_name = 'Firefox'
and version_string IN ('29.0a1', '28.0a2')
group by date_processed::date, version_string
order by report_date
;
\o
flash crash reports
select count(*) from reports_clean where flash_version_id is not null and date_processed between '2014-01-20 00:00:00+00' and '2014-01-21 00:00:00+00' and product_version_id = 2040 and hang_id is null;
\o /tmp/flash_crash.csv
select count(flash_version_id), version_string, date_processed::date as report_date
from reports_clean
JOIN product_versions USING (product_version_id)
where flash_version_id is not null
and date_processed between '2013-10-1 00:00:00+00' and '2014-01-21 00:00:00+00'
and product_name = 'Firefox'
and version_string IN ('29.0a1', '28.0a2')
group by date_processed::date, version_string
order by report_date
;
\o
and then a bugzilla query for finding tracking+ bugs for a release