1977639 - Design and instrument slow SQL reporting

Status: ASSIGNED

(Toolkit :: Telemetry, task, P1)

Description

[Chris H-C :chutten]

We can't (and don't want to) do a 1:1 reinstrumentation of slowSQL and slowSQLStartup, so this bug is about designing instrumentation that can serve the same analysis needs (per-db, per-statement performance regression catching and EDA) while also being open to being expanded from today's coverage of mozStorageConnection to tomorrow's SQL runners (say, Rusqlite).

:mak's comment on the subject is quite detailed and gives us a lot of things to consider. I think step 1 will be to see what existing metric types in Glean might fit the bill best. If it's obvious what'll best suit us, we can go ahead with impl. If it's non-obvious or would benefit from some conversation, we might want to draft a design proposal.