# Percona monitoring and management QAN

**URL:** <https://forums.percona.com/t/percona-monitoring-and-management-qan/20840>\
**Category:** PMM 2.x\
**Tags:** pmm, closed-no-reply\
**Created:** [March 21, 2023, 3:07pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-qan/20840 "2023-03-21T15:07:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shadi\_Abdulqader](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/shadi_abdulqader/32/9740_2.png) [@Shadi\_Abdulqader](https://forums.percona.com/u/Shadi_Abdulqader)\
**Post date:** [March 21, 2023, 3:07pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-qan/20840/1 "2023-03-21T15:07:51Z")

</div>

Hi, we’re using percona management and monitoring 2.35.0 version. The problem is that QAN dashboard does not show the SQL queries examples and explains.

for query examples pmm we are got this msg “Sorry, no examples found for this query”  
and for explain “no explain found”

mysql\> select \* from performance\_schema.setup\_consumers;  
±---------------------------------±--------+  
| NAME | ENABLED |  
±---------------------------------±--------+  
| events\_stages\_current | NO |  
| events\_stages\_history | NO |  
| events\_stages\_history\_long | NO |  
| events\_statements\_cpu | NO |  
| events\_statements\_current | YES |  
| events\_statements\_history | YES |  
| events\_statements\_history\_long | NO |  
| events\_transactions\_current | YES |  
| events\_transactions\_history | YES |  
| events\_transactions\_history\_long | NO |  
| events\_waits\_current | NO |  
| events\_waits\_history | NO |  
| events\_waits\_history\_long | NO |  
| global\_instrumentation | YES |  
| thread\_instrumentation | YES |  
| statements\_digest | YES |  
±---------------------------------±--------+  
16 rows in set (0.07 sec)

mysql\>

mysql\> show variables like “%performance\_schema%”;  
±---------------------------------------------------------±------+  
| Variable\_name | Value |  
±---------------------------------------------------------±------+  
| performance\_schema | ON |  
±---------------------------------------------------------±------+  
mysql configuration  
max\_digest\_length = 20240  
performance\_schema\_max\_digest\_length = 20240  
performance\_schema\_max\_sql\_text\_length = 20240

Data Source: Amazon RDS

Database engine: mysql 8