How can I enable top waits metrics on postgres over percona monitoring

Percona Monitoring and Management (PMM) PMM 2.x
1

Description:

how can I enable top waits metrics on postgres over percona monitoring like we do in AWS RDS?

Steps to Reproduce:

Not able to see waits metrics on postgres over PMM.

Version:

PMM 2.42
Pgcluster 2.4.2

Logs:

Didn’t find any thing. You can find sample logs over AWS RDS.

Screenshot 2024-07-05 at 1.37.55 PM
Screenshot 2024-07-05 at 1.37.55 PM2550×1526 284 KB

2

@Raj_Burnwal

It looks like we don’t have any such currently and you have to rely on the custom metrics/dashboard for the same.

Let me add some references for the custom dashboard.

  • List item
  • List item
  • List item

You can use the queries based on the tables/view like pg_stat_activity/pg_stat_statements/pg_locks etc to generate the queries. Let’s check the blogpost and let us know if you having any further queries.

3

@anil.joshi - Do you have any documentation or examples of custom queries for Postgres to create a dashboard similar to Performance Insights for wait events?