# \[postgres\] \[QAN\] QAN examples not found

**URL:** <https://forums.percona.com/t/postgres-qan-qan-examples-not-found/24580>\
**Category:** PMM 2.x\
**Tags:** pmm, postgres\
**Created:** [August 21, 2023, 7:56pm UTC](https://forums.percona.com/t/postgres-qan-qan-examples-not-found/24580 "2023-08-21T19:56:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rizky\_Nur\_Zhafirah](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rizky_nur_zhafirah/32/11864_2.png) [@Rizky\_Nur\_Zhafirah](https://forums.percona.com/u/Rizky_Nur_Zhafirah)\
**Post date:** [August 21, 2023, 7:56pm UTC](https://forums.percona.com/t/postgres-qan-qan-examples-not-found/24580/1 "2023-08-21T19:56:44Z")

</div>

Hi Team, i am monitoring postgresql database using pmm. I have installed all requirement based on the document but in example tab i am not getting any information when I run the query several times.  
 ![Screenshot 2023-08-15 at 16.27.15](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2f15733ce6c837986c0269e47a1f7865da9cb887.png)  
what should i do to fix this?

I’m using pg\_stat\_monitor

thank you

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [August 31, 2023, 11:42am UTC](https://forums.percona.com/t/postgres-qan-qan-examples-not-found/24580/2 "2023-08-31T11:42:32Z")

</div>

@Rizky_Nur_Zhafirah , are you using the Percona Distributions for PostgreSQL or adding pg\_stat\_monitor on top of the community version of PG?  
What are the settings of PG\_stat\_monitor in your cases, and can you check agents (on the service page) related to the Service - what agents are running?  
As its very strange if you have other data for queries and no queries. It might be pg\_stat\_statement used in this case.

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

---

<div class="post-metadata">

**Author:** ![Rizky\_Nur\_Zhafirah](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rizky_nur_zhafirah/32/11864_2.png) [@Rizky\_Nur\_Zhafirah](https://forums.percona.com/u/Rizky_Nur_Zhafirah)\
**Post date:** [September 4, 2023, 3:29am UTC](https://forums.percona.com/t/postgres-qan-qan-examples-not-found/24580/3 "2023-09-04T03:29:15Z")

</div>

Hi Roma,

I’m installing Percona Monitoring and Management via [Setting up - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/index.html)

I have both the pg\_stat\_statement and pg\_stat\_monitor in my db. pg\_stat\_statement already exist in my db before i install percona. install and configure pg\_stat\_monitor via this link [Install - pg\_stat\_monitor Documentation](https://docs.percona.com/pg-stat-monitor/install.html)

 ![Screenshot 2023-09-04 at 10.28.07](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/3e068c7f49a9aaa16555a5c6bbe8b8325fb84696.png)

 ![Screenshot 2023-09-04 at 10.26.56](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/17b3680c1e28b4e9819ca49bdbc459873da9e644.png)

Is this the agent you mean?

 ![Screenshot 2023-09-04 at 09.51.50](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/189cb50d4211603760ad51d6728e188714742443.png)

How can i know if my PMM used pg\_stat\_monitor or pg\_stat\_statement?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [September 29, 2023, 8:28am UTC](https://forums.percona.com/t/postgres-qan-qan-examples-not-found/24580/4 "2023-09-29T08:28:28Z")

</div>

@Rizky_Nur_Zhafirah yes, it looks like you have everything installed and running correctly, so this is some PMM-related bug (maybe frontEnd-related)  
Can you submit a bug to [jira.percona.com](http://jira.percona.com) so our support/engineering team will do a closer look?
