# Query Analytics doesn't works with pg\_stat\_monitor

**URL:** <https://forums.percona.com/t/query-analytics-doesnt-works-with-pg-stat-monitor/20800>\
**Category:** Percona Monitoring and Management (PMM)\
**Created:** [March 21, 2023, 3:41am UTC](https://forums.percona.com/t/query-analytics-doesnt-works-with-pg-stat-monitor/20800 "2023-03-21T03:41:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jyoti\_Rajai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jyoti_rajai/32/4482_2.png) [@Jyoti\_Rajai](https://forums.percona.com/u/Jyoti_Rajai)\
**Post date:** [March 21, 2023, 3:41am UTC](https://forums.percona.com/t/query-analytics-doesnt-works-with-pg-stat-monitor/20800/1 "2023-03-21T03:41:36Z")

</div>

Hi Team,

I have remotely add PostgreSQL service on PMM with Stat\_tracking\_options : pg\_stat\_monitor.

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

Service name : postgres\_ubuntu\_pg\_stat\_monitor

Here you can see it’s enabled on server:

```auto
postgres=# show shared_preload_libraries ;
      shared_preload_libraries
------------------------------------
 pg_stat_statements,pg_stat_monitor
(1 row)

```

HEre is the screenshot of PMM → Query Analytics :

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

There is no service found with postgres\_ubuntu\_pg\_stat\_monitor.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![lalit.choudhary](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lalit.choudhary/32/51_2.png) [@lalit.choudhary](https://forums.percona.com/u/lalit.choudhary)\
**Post date:** [March 21, 2023, 2:05pm UTC](https://forums.percona.com/t/query-analytics-doesnt-works-with-pg-stat-monitor/20800/2 "2023-03-21T14:05:51Z")

</div>

Hello @Jyoti_Rajai

Do you see postgresql service “postgres\_ubuntu\_pg\_stat\_monitor” on other pmm dashboards, for example on “PostgreSQL/PostgreSQL Instances Overview” ?

If no, I would suggest checking pmm-agent logs which you will find inside pmm-server logs.

You can get PMM Server logs with either of these methods:

**Direct download**

In a browser, visit `https://<address-of-your-pmm-server>/logs.zip`.

**From Help menu**

1. Select _Help_ → _PMM Logs_.
2. Click _PMM Logs_ to retrieve PMM diagnostics data which can be examined and shared with our support team should you need help.

---

<div class="post-metadata">

**Author:** ![Jyoti\_Rajai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jyoti_rajai/32/4482_2.png) [@Jyoti\_Rajai](https://forums.percona.com/u/Jyoti_Rajai)\
**Post date:** [March 21, 2023, 8:08pm UTC](https://forums.percona.com/t/query-analytics-doesnt-works-with-pg-stat-monitor/20800/3 "2023-03-21T20:08:49Z")

</div>

> [@lalit.choudhary](#):
>
> Do you see postgresql service “postgres\_ubuntu\_pg\_stat\_monitor” on other pmm dashboards, for example on “PostgreSQL/PostgreSQL Instances Overview” ?

I can see all other graph for postgres\_ubuntu\_pg\_stat\_monitor.

Only I can’t see it on Query Analytics as shown in snapshot.  
Whereas the same server I have configured it with pg\_stat\_statement then it’s showing in Query Analytics as you can see it in snapshot as well.

---

<div class="post-metadata">

**Author:** ![lalit.choudhary](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lalit.choudhary/32/51_2.png) [@lalit.choudhary](https://forums.percona.com/u/lalit.choudhary)\
**Post date:** [March 22, 2023, 5:05am UTC](https://forums.percona.com/t/query-analytics-doesnt-works-with-pg-stat-monitor/20800/4 "2023-03-22T05:05:52Z")

</div>

Hello @Jyoti_Rajai

To check what the issue I would suggest checking pmm-agent logs which you will find inside pmm-server logs.

You can get PMM Server logs with either of these methods:

**Direct download**

In a browser, visit `https://<address-of-your-pmm-server>/logs.zip`.

**From Help menu**

1. Select _Help_ → _PMM Logs_.
2. Click _PMM Logs_ to retrieve PMM diagnostics data which can be examined and shared with our support team should you need help.

Here reference of similar issue [PostgreSQL Server not visible in QAN](https://forums.percona.com/t/postgresql-server-not-visible-in-qan/18936)

Also please make sure following steps configured for pg\_stat\_monitor configuration.

> **[PostgreSQL - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/postgresql.html#configure_1)**
>
> Documentation