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

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Laura Thomson :laura]

Sheila wants to know if the percentage is increasing.

Comment 1

[[:jberkus] Josh Berkus]

Attachment: Null Reports by version report

report

Comment 2

[[:jberkus] Josh Berkus]

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

Comment 3

[K Lars Lohn [:lars] [:klohn]]

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

Comment 4

[[:jberkus] Josh Berkus]

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;

Comment 5

[[:jberkus] Josh Berkus]

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.