701907 - Need Windows Breakdown by OS and day for explosive crash

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Marcia Knous [:marcia]]

For this signature - [@ js::Bindings::getLocalNameArray(JSContext*, js::Vector<JSAtom*, int, js::TempAllocPolicy>*) ]

We need a breakdown of crashes by Windows OS, and day if possible for this signature ASAP.

Comment 1

[Robert Helmer [:rhelmer]]

Attachment: breakdown by day, os_version

Query used:

select date_trunc('day', date_processed) as day, count(*), os_name, os_version 
from reports 
where signature = 'js::Bindings::getLocalNameArray(JSContext*, js::Vector<JSAtom*, int, js::TempAllocPolicy>*)' 
and os_name ilike 'windows%' 
group by day, os_name, os_version order by count(*) desc;

This is sorted by count (descending), let me know if you'd like any changes.