838251 - Show a count of distinct install times per signature

Status: RESOLVED FIXED

(Socorro :: Webapp, task, P1)

Description

[Robert Kaiser]

As we (intentionally) don't have identifiers of users/installations in crash reports, we usually take distinct install times as an approximation of how many installations are seeing an issue.

We should expose a count of distinct install times per signature in the UI, one way I can imagine that is to have an additional column in the product/version section of the Signature Summary where we list how many distinct installation time stamps we're seeing for this signature and product version.


Laura, as this is a pretty common request we're getting from release management, can we have this scheduled in a way that we get it rather early after the new UI has been shipped?

Comment 1

[Laura Thomson :laura]

We should probably add this to the Signature Summary.

Comment 2

[Robert Kaiser]

FYI, I posted an SQL query of how I extracted that data for one case we had in bug 838603 comment #22 (I needed to use the reports table there as I actually wanted a match against app notes). One-off requests for that data can be done with queries like that until we get this implemented in the proper UI. :)

Comment 3

[Robert Kaiser]

One thing that might be a bit fiddly here is that this measure isn't fully additive between days, as if the same installation is crashing once every day, you get 1 installation counted if you analyze a 7-day example at once, but 7 if you add up per-day samples of the same data.

See below queries to see how this matters in practice:

breakpad=> SELECT version,COUNT(*) as crashes,COUNT(DISTINCT client_crash_date - install_age  * interval '1 second') as installations FROM reports WHERE product='Firefox' AND signature LIKE 'mozilla::dom::DocumentBinding::CreateInterfaceObjects%' AND utc_day_is(date_processed, '2013-04-28') GROUP BY version;
 version | crashes | installations 
---------+---------+---------------
 21.0    |   18377 |          7460
(1 row)

breakpad=> SELECT version,COUNT(*) as crashes,COUNT(DISTINCT client_crash_date - install_age  * interval '1 second') as installations FROM reports WHERE product='Firefox' AND signature LIKE 'mozilla::dom::DocumentBinding::CreateInterfaceObjects%' AND date_processed BETWEEN '2013-04-24' AND '2013-04-29' GROUP BY version;
 version | crashes | installations 
---------+---------+---------------
 21.0    |   44123 |         12495
(1 row)

Comment 4

[Brandon Savage [:brandon]]

After talking with KaiRo and espressive, we're going to meet to discuss the best way to proceed on displaying useful data for Crashkill. Meeting scheduled for next Tuesday.

Comment 5

[[github robot]]

Commit pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/7d57ed74b54b1f0739efa3e388222763df0ea119
Merge pull request #1258 from brandonsavage/bugzilla-upgrade

Updating the Bugzilla API from 1.1 to 1.3 in the default configuration. (Fixes Bug 838251)

Comment 6

[Brandon Savage [:brandon]]

Wrong bug mentioned in the commit message. :(

Comment 7

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/ffd23c8452d6f660169531dc4955380af81ec18b
Adding middleware required for bug 838251.

https://github.com/mozilla/socorro/commit/7ed5d9f68f5f2dc7c8b1abbe413d7b979ece5331
Merge pull request #1267 from brandonsavage/bug838251-middleware

Adding middleware required for bug 838251.

Comment 8

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro-crashstats

https://github.com/mozilla/socorro-crashstats/commit/f0c64c0db13f56e4fad8b5856da9217386d98cef
Fixes Bug 838251 - Adds distinct install per signature to signature summary.

https://github.com/mozilla/socorro-crashstats/commit/0bcb38a7771ebc7c9f181a2f48c4c93a7e2350b0
Merge pull request #353 from brandonsavage/bug838251

Fixes Bug 838251 - Adds distinct install per signature to signature summary