1563276 - consider reducing testing on 32 bit devedition builds

Status: NEW

(DevTools :: General, task, P3)

Description

[Joel Maher ( :jmaher ) (UTC -8)]

we currently build and test devedition builds from mozilla-beta for these platforms:
linux32
linux64
macosx64
windows7-32
windows10-64

I got to thinking, why do we test on linux32 and windows7-32, so I looked into redash a bit [1] which has a link to a sample query [2]. In doing this I found that a few variables need to change in the sample query [3]:
WHERE
submission_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 5 WEEK) ),

changes to:
WHERE
submission_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 5 WEEK) AND
normalized_channel = 'aurora' AND
env_build_arch = 'x86' AND
os in ('Windows_NT', 'Linux') ),

this basically limits to 'aurora' which I believe is devedition. There is a pending question, is there other stuff on the 'aurora' build tag that isn't devedition?

since we are talking 32 bit, I see 'x86' as needed vs x86_64 or aarch64.

In doing this I see various OS entries:
Darwin (14 users),
Windows_95 (1 user),
Windows_NT (60-100K users),
Linux (550-600 users)

Windows seems to have a lot of 32 bit users, they are on these versions:
5.0 (~5 users - ?)
5.1 (~25K users - this is xp)
5.2 (~40 users - this is xp)
6.1 (~40K users - this is win7)
6.2 (~1300 users - this is winn8)
6.3 (~5300 users - ?)
10.0 (~20K users - this is win10)

overall there seem to be many users on 32 bit, I am not sure if we have a need to continue special 32 bit devedition builds, or require the full set of tests for them. Possibly we can deprecate the 32 bit linux, but maybe windows needs to stick around.

1: https://docs.telemetry.mozilla.org/datasets/bigquery/clients_last_seen/reference.html#compute-wau-by-channel-for-the-last-week
2: https://sql.telemetry.mozilla.org/queries/62029/source#159510
3: WITH
inactive_days AS (
SELECT
*,
scalar_parent_browser_engagement_total_uri_count_sum >= 5 AS active
FROM
telemetry.clients_last_seen_v1
WHERE
submission_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 5 WEEK) AND
normalized_channel = 'aurora' AND
env_build_arch = 'x86' AND
os in ('Windows_NT') ),
counts AS (
SELECT
submission_date,
normalized_os_version,
COUNTIF(days_since_seen < 28) AS mau,
COUNTIF(days_since_seen < 28
AND active) AS active_mau,
COUNTIF(days_since_seen < 7) AS wau,
COUNTIF(days_since_seen < 7
AND active) AS active_wau,
COUNTIF(days_since_seen < 1) AS dau,
COUNTIF(days_since_seen < 1
AND active) AS active_dau
FROM
inactive_days
GROUP BY
submission_date, normalized_os_version),
smooth AS (
SELECT
*,
AVG(dau) OVER smooth AS smooth_dau,
AVG(active_dau) OVER smooth AS smooth_active_dau
FROM
counts
WINDOW
smooth AS (
ORDER BY
submission_date ROWS 6 PRECEDING))
SELECT
*,
mau/smooth_dau AS er,
active_mau/smooth_active_dau AS active_er
FROM
smooth
WHERE
submission_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK)