# Clickhouse query plugin question

**URL:** <https://forums.percona.com/t/clickhouse-query-plugin-question/25268>\
**Category:** PMM 2.x\
**Tags:** mysql\
**Created:** [September 19, 2023, 9:17am UTC](https://forums.percona.com/t/clickhouse-query-plugin-question/25268 "2023-09-19T09:17:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shshwe2](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shshwe2/32/10086_2.png) [@shshwe2](https://forums.percona.com/u/shshwe2)\
**Post date:** [September 19, 2023, 9:17am UTC](https://forums.percona.com/t/clickhouse-query-plugin-question/25268/1 "2023-09-19T09:17:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [September 19, 2023, 11:14am UTC](https://forums.percona.com/t/clickhouse-query-plugin-question/25268/2 "2023-09-19T11:14:21Z")

</div>

@shshwe2 you can check the dashboard [Grafana](https://pmmdemo.dev.percona.net/graph/d/environments-overview/environments-overview-designed-for-pmm?orgId=1&refresh=1m) 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