How to match query report with the exact sql query?

Hello dear Percona support,

We have queries that differ from each other only with the SQL comment, e.g.

/* service: a */
SELECT 1 FROM table;

/* service: b */
SELECT 1 FROM table;

Is it possible to match PMM query metrics received from the /v0/qan/GetReport with the exact query (including the SQL comment) somehow?


Hi @andrei.troskov welcome to the Percona forums!
At this time the code for query analytics strips comments prior to generating the query fingerprint. If this is something that is of interest to you, may I recommend you file a feature request in JIRA so that Engineering may consider it for a subsequent release.


Sounds good, thank you @Michael_Coburn!

1 Like