When e.g. android has a ton of crash pings, the LIMIT without an ordering seems to take only those (with the UNION ALL that's currently done in the query). We need to change the query to randomly sample among all results.
Bug 1938151 Comment 0 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
When e.g. android has a ton of crash pings, the LIMIT without an ordering seems to take only those (with the UNION ALL that's currently done in the query). We need to change the query to randomly sample among all results. Alternatively, we could facet on OS to guarantee results (if they exist). This may not accurately depict the top crashers across all platforms (if the volume is saturated with relation to the limit, the relative volumes will disappear), however typically we are interested in per-os statistics anyway.