# Query not showing properly in examples tab in qan

**URL:** <https://forums.percona.com/t/query-not-showing-properly-in-examples-tab-in-qan/21321>\
**Category:** PMM 2.x\
**Created:** [April 11, 2023, 8:08am UTC](https://forums.percona.com/t/query-not-showing-properly-in-examples-tab-in-qan/21321 "2023-04-11T08:08:36Z")\
**Posts on this page:** 3\
**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:** [April 11, 2023, 8:08am UTC](https://forums.percona.com/t/query-not-showing-properly-in-examples-tab-in-qan/21321/1 "2023-04-11T08:08:36Z")

</div>

hello.  
Current I am using pmm version 2.36, grafana 9.2.13.

mysql config setting

max\_digest\_length = 50000  
performance\_schema.max\_digest\_length = 50000  
performance\_schema.max\_sql\_text\_length = 50000

The change was also confirmed in show global status.

However, in the examples tab, only about 3500 bytes of query sentences appear.

Is there any way to solve this problem?

---

<div class="post-metadata">

**Author:** ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)\
**Post date:** [April 11, 2023, 5:46pm UTC](https://forums.percona.com/t/query-not-showing-properly-in-examples-tab-in-qan/21321/2 "2023-04-11T17:46:32Z")

</div>

Yes! By default PMM limits itself to 2048 characters of the query. you can tune this using the `--max-query-length=NUMBER` when you register the client to PMM server with the `pmm-admin add mysql...` command. This means you’ll first have to unregister this client using `pmm-admin remove...`. If you add it back using the same nodename it was registered with in the first place it will simply append metrics to the graphs as it has been (`history | grep 'pmm-admin add'` will hopefully save a few steps trying to figure out how you registered it in the first place.

your options for NUMBER are:  
-1: unlimited  
0: default (2048)  
1-X: whatever number here is where the query truncation will happen

---

<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:** [April 12, 2023, 5:06am UTC](https://forums.percona.com/t/query-not-showing-properly-in-examples-tab-in-qan/21321/3 "2023-04-12T05:06:32Z")

</div>

Thanks.

it was solved thanks