Clickhouse query plugin question

[shshwe2]

hi. I’m trying to ask a question

Currently, it is not possible to change the digest column length in the DB Config in QAN, so I am trying to separately accumulate logs on the pmm server and analyze the query.

So I installed the Clickhouse plugin.

Values ​​specified in quotation marks for the relevant column are entered as ?.

ex)
select * from table where ID = ‘1’
→
select * from table where ID = ?

Is there a way to store logs with these values ​​intact?

When I installed Clickhouse, a table called pmm.metrics was automatically created.

[Roma_Novikov]

@shshwe2 you can check the dashboard Grafana on your installation and there is a panel “Query Latency per Environment” - you can check it for the example of Clickhouse plugin usage in PMM