What percentage of crashes are (null signature) by version?

RESOLVED FIXED

Status

Socorro
General
--
critical
RESOLVED FIXED
7 years ago
6 years ago

People

(Reporter: laura, Assigned: lars)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

Attachments

(1 attachment)

(Reporter)

Description

7 years ago
Sheila wants to know if the percentage is increasing.
Created attachment 511138 [details]
Null Reports by version report

report
I've attached a report as an Openoffice Spreadsheet.  Hopefully you find it enlightening; looks like a random distribution to me.
(Assignee)

Comment 3

7 years ago
josh, please paste your process to produce these numbers so that we may both audit them now and reproduce them in the future.
Lars,

Oh, right, it's a fun query:

select version, total_reports, null_reports,
	round(( null_reports::numeric/total_reports::numeric ) * 100, 2) as null_percentage
from (
	select productdims_id, version,
		sum (case when signature IS NULL then count else 0 end ) as null_reports,
		coalesce(sum (count),0) as total_reports
		from top_crashes_by_signature tcbs
		join productdims on tcbs.productdims_id = productdims.id
	where product ilike 'firefox'
	group by productdims_id, version
) as countit
order by version;
Oh, and if you do \x in psql, that gives you unaligned output, which then pastes pretty easily into an OOo spreadsheet.  Less work than COPY to CSV, and then scp'ing the files around the network.
(Reporter)

Updated

7 years ago
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.