Query Analytics doesn't works with pg_stat_monitor

Percona Monitoring and Management (PMM)
1

Hi Team,

I have remotely add PostgreSQL service on PMM with Stat_tracking_options : pg_stat_monitor.

image
image1815×854 51.3 KB

Service name : postgres_ubuntu_pg_stat_monitor

Here you can see it’s enabled on server:

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
image1859×529 32.9 KB

There is no service found with postgres_ubuntu_pg_stat_monitor.

Thank you in advance.

2

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.
3

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.

4

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

Also please make sure following steps configured for pg_stat_monitor configuration.