# QAN not displaying explain/tables (MySQL 8)

**URL:** <https://forums.percona.com/t/qan-not-displaying-explain-tables-mysql-8/20520>\
**Category:** PMM 2.x\
**Tags:** pmm, mysql\
**Created:** [March 10, 2023, 2:51pm UTC](https://forums.percona.com/t/qan-not-displaying-explain-tables-mysql-8/20520 "2023-03-10T14:51:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![voarsh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/voarsh/32/6577_2.png) [@voarsh](https://forums.percona.com/u/voarsh)\
**Post date:** [March 10, 2023, 2:51pm UTC](https://forums.percona.com/t/qan-not-displaying-explain-tables-mysql-8/20520/1 "2023-03-10T14:51:44Z")

</div>

Hi.  
Running PMM 2.35.0 via Helm Chart.  
Using Percona XtraDB Cluster 8 - MySQL 8.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/6ecec429389d1051dcd3f1aa5e584f5276e62651.png)  
I can see examples of a query, but explain and tables returns errors:  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a3d42b104b82ffc992206181a104b7a4d182fca2.png)  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/039d97a49a6960ace8ce5802565b3ba77fa34e44.png)

Am I missing something here?

---

<div class="post-metadata">

**Author:** ![romber](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/romber/32/36_2.png) [@romber](https://forums.percona.com/u/romber)\
**Post date:** [March 14, 2023, 1:51am UTC](https://forums.percona.com/t/qan-not-displaying-explain-tables-mysql-8/20520/2 "2023-03-14T01:51:16Z")

</div>

same here, It’s been a long time, that explain function doesn’t work properly.

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [March 14, 2023, 7:34am UTC](https://forums.percona.com/t/qan-not-displaying-explain-tables-mysql-8/20520/3 "2023-03-14T07:34:53Z")

</div>

Even, for me its not working. Both explain plan and table details are not working properly.

---

<div class="post-metadata">

**Author:** ![Jiri\_Ctvrtka](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jiri_ctvrtka/32/8302_2.png) [@Jiri\_Ctvrtka](https://forums.percona.com/u/Jiri_Ctvrtka)\
**Post date:** [March 14, 2023, 1:44pm UTC](https://forums.percona.com/t/qan-not-displaying-explain-tables-mysql-8/20520/4 "2023-03-14T13:44:35Z")

</div>

Hi @voarsh, is your PMM client also 2.35? Like if you have client and server both on 2.35. Thank you.

---

<div class="post-metadata">

**Author:** ![voarsh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/voarsh/32/6577_2.png) [@voarsh](https://forums.percona.com/u/voarsh)\
**Post date:** [March 15, 2023, 3:12pm UTC](https://forums.percona.com/t/qan-not-displaying-explain-tables-mysql-8/20520/5 "2023-03-15T15:12:45Z")

</div>

Hmm.  
I’m using the Helm Chart for Percona XtraDB Cluster:  
pmm:  
image:  
repository: percona/pmm-client  
tag: 2.32.0

ProxySQL is uing: percona/pmm-client:2.32.0  
And the database: percona/pmm-client:2.32.0  
pmm server: percona/pmm-server:2.35.0