Provide ability to tag queries in Query Analytics

Description

It would be great to be able to assign pre-generated as well as arbitrary tags to queries in Query Analytics. The point is to be able to quickly analyze a group of queries for review / sharing to colleagues when performing triage of a system.

  • Could then choose to view by selected tags, or exclude selected tags

  • Pre-generated would be those executed by pmm-agent, Custom Queries

  • Need to be able to be assigned by Custom Queries (each query should have a similar tag like mysql_custom_query as well as ability to add an arbitrary tag unique to the environment i.e. service_web_frontend_42 )

  • Additional "Queries to be reviewed" vs "Already Reviewed" so that setting up a query review process is simple, you don't need to look at certain queries you know have already been tuned and examined (PCT model)

  • Should be accessible via API so then programmatically an environment can be configured to tag queries based on digest

How to test

None

How to document

None

Attachments

1

Activity

Show:

duygu.aksoy February 10, 2023 at 7:10 AM

fyi  

Details

Assignee

Reporter

Priority

Components

Needs QA

Yes

Needs Doc

Yes

Affects versions

Smart Checklist

Created February 7, 2023 at 6:21 PM
Updated November 13, 2024 at 8:33 AM