Here's a dashboard I've created, using the data in `additional_properties`: https://sql.telemetry.mozilla.org/queries/65832 Defining a schema for `slowSQL` would go a long way toward making it easier to analyze. Something in the pipeline strips escape sequences from newlines, backslashes, and quotes, so we can't just pass `additional_properties.slowSQL` to `JSON.parse` in a SQL function. It would also be helpful to normalize statements before recording them (bug incoming), and record the DB name in a separate field, instead of a comment in the SQL string. I added some more notes at the top of the query.
Bug 1592263 Comment 3 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
Here's a query I've created, using the data in `additional_properties`: https://sql.telemetry.mozilla.org/queries/65832 Defining a schema for `slowSQL` would go a long way toward making it easier to analyze. Something in the pipeline strips escape sequences from newlines, backslashes, and quotes, so we can't just pass `additional_properties.slowSQL` to `JSON.parse` in a SQL function. It would also be helpful to normalize statements before recording them (bug incoming), and record the DB name in a separate field, instead of a comment in the SQL string. I added some more notes at the top of the query.