Sheila wants to know if the percentage is increasing.
I've attached a report as an Openoffice Spreadsheet. Hopefully you find it enlightening; looks like a random distribution to me.
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.