# PMM QAN no example query

**URL:** https://forums.percona.com/t/pmm-qan-no-example-query/25511
**Category:** Percona Monitoring and Management (PMM)
**Tags:** pmm, mysql
**Created:** [September 28, 2023, 8:29am UTC](https://forums.percona.com/t/pmm-qan-no-example-query/25511 "2023-09-28T08:29:50Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![EricGpn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ericgpn/32/12984_2.png) [@EricGpn](https://forums.percona.com/u/EricGpn)
#### Post date: [September 28, 2023, 8:29am UTC](https://forums.percona.com/t/pmm-qan-no-example-query/25511/1 "2023-09-28T08:29:50Z")

</div>

## Description:

I work for multiple customers with all their own database- and monitoring-environment and with these customers I have the same issue regarding PMM QAN. I see the queries in QAN, I see the queries hovering over the ‘i’ symbol, the details tab is filled, but examples says: “Sorry, no examples found for this query”

I’ve seen just a few related topics but not a clear resolution or cause of this issue.

## Version:

**DATABASE SERVER**  
OS: Ubuntu 20.04.5 LTS  
DBMS: 10.4.27-MariaDB

ProjectName: pmm-admin  
Version: 2.38.1  
PMMVersion: 2.38.1

ProjectName: pmm-agent  
Version: 2.38.1  
PMMVersion: 2.38.1

**MONITORING SERVER**  
OS: Docker version 20.10.21, build 20.10.21-0ubuntu1~20.04.2

ProjectName: pmm-admin  
Version: 2.38.1  
PMMVersion: 2.38.1

ProjectName: pmm-agent  
Version: 2.38.1  
PMMVersion: 2.38.1

## Additional Information:

PMM is running in Docker on a machine which runs Zabbix. Difference in configuration/setup is that PMM goes to port 8080 instead of 80 since this is used by Zabbix.

PMM uses performance schema as a source

pmm-admin list on the a database services provide the following information

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/e/e018ddee00e9bb929ac7e410c3a94bd36d36427f.png)

And in PMM checking the PMM Inventory/Services I see a corresponding results to the image from above.

---

<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: [September 28, 2023, 5:53pm UTC](https://forums.percona.com/t/pmm-qan-no-example-query/25511/2 "2023-09-28T17:53:57Z")

</div>

I see you are using the performance\_schema as the source for QAN. Have you correctly configured the performance\_schema according to our documentation?

---

<div class="post-metadata">

### Author: ![EricGpn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ericgpn/32/12984_2.png) [@EricGpn](https://forums.percona.com/u/EricGpn)
#### Post date: [September 29, 2023, 7:17am UTC](https://forums.percona.com/t/pmm-qan-no-example-query/25511/3 "2023-09-29T07:17:02Z")

</div>

performance\_schema=ON  
performance-schema-instrument=‘statement/%=ON’  
performance-schema-consumer-statements-digest=ON  
innodb\_monitor\_enable=all

UPDATE performance\_schema.setup\_consumers  
SET ENABLED = ‘YES’ WHERE NAME LIKE ‘%statements%’;  
SET GLOBAL innodb\_monitor\_enable = all;

Missed this last bit of the configuration. Thanks! works perfectly now.