# PMM - Query Analitics: does not display the query completely in Example

**URL:** https://forums.percona.com/t/pmm-query-analitics-does-not-display-the-query-completely-in-example/20459
**Category:** PMM 2.x
**Tags:** pmm
**Created:** [March 7, 2023, 2:34pm UTC](https://forums.percona.com/t/pmm-query-analitics-does-not-display-the-query-completely-in-example/20459 "2023-03-07T14:34:37Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Pavel\_Linenco](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavel_linenco/32/9647_2.png) [@Pavel\_Linenco](https://forums.percona.com/u/Pavel_Linenco)
#### Post date: [March 7, 2023, 2:34pm UTC](https://forums.percona.com/t/pmm-query-analitics-does-not-display-the-query-completely-in-example/20459/1 "2023-03-07T14:34:37Z")

</div>

Hello, please help me solve the problem with displaying the query in Example, everything I found on the forums I tried to do everything, it didn’t help me, maybe I’m doing something wrong?

To display the entire query, I added 3 parameters to MySQL:  
**max\_digest\_length=8000**  
**performance\_schema\_max\_digest\_length=8000**  
**performance\_schema\_max\_sql\_text\_length=8000**

and it did not give any result.

**pmm-client version 2.35.0**  
**pmm-server version 2.35.0**  
**MySQL Percona version 8.0.25**

Please tell me what else can I try to do?

 ![pmm-Query_an](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/0ec4393f4415e75b9010476589f3442809ba2ea7.png)

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 7, 2023, 6:19pm UTC](https://forums.percona.com/t/pmm-query-analitics-does-not-display-the-query-completely-in-example/20459/2 "2023-03-07T18:19:14Z")

</div>

Keep in mind that these changes wont affect already collected data. Your parameter changes will only affect newly captured examples.

---

<div class="post-metadata">

### Author: ![Yiyao\_Wei](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yiyao_wei/32/9674_2.png) [@Yiyao\_Wei](https://forums.percona.com/u/Yiyao_Wei)
#### Post date: [March 9, 2023, 12:55pm UTC](https://forums.percona.com/t/pmm-query-analitics-does-not-display-the-query-completely-in-example/20459/3 "2023-03-09T12:55:13Z")

</div>

Hey, have you solved the problem?

I have observed the same behavior - no matter how high I set those three parameters, the length of queries in the Example tab is always 2048.

**performance\_schema\_max\_digest\_length=4000**  
**performance\_schema\_max\_sql\_text\_length=4000**  
**performance\_schema\_consumer\_statements\_digest=1**

Note that I have rebooted the DB instance to make parameter changes take effect and re-added the DB instance to PMM with `max-query-length=-1`, and waited for one hour selecting the last 10 min queries.

**pmm-client version 2.35.0**  
**pmm-server version 2.35.0**  
**AWS RDS engine 8.0.mysql\_aurora.3.02.2**

@matthewb is there anything else we could do on the MySQL side?