PostgreSQL custom query is not working

Percona Monitoring and Management (PMM)
1

Hi Team,

I have configured the below custom query in the below path, but I am unable to see the metric in the Explore dashboard.

Path: /usr/local/percona/pmm2/collectors/custom-queries/postgresql/low-resolution/queries-lr.yaml

pg_user_process:
query: “SELECT usename as USER, client_addr as IP, COUNT(client_addr) as THREAD_COUNT FROM pg_stat_activity GROUP BY client_addr,usename ORDER BY usename, client_addr”
metrics:
- list:
usage: “GAUGE”
description: “Id details”
- USER:
usage: “LABEL”
description: “User Name”
- IP:
usage: “LABEL”
description: “User Client IP”
- THREAD_COUNT:
usage: “LABEL”
description: “no of connections per thread.”

2

Hi @Naresh9999 . do you see any errors on the PMM Client side in the logs?

3

@Roma_Novikov I see no problems in the log file, and in addition to this query, other custom queries that are PMM default queries are also not working.

4

@Roma_Novikov Can you please help me on this?

5

@Roma_Novikov @nurlan Can you please help me on this?

6

I see that value comes from list, but don’t see list in query

7

@nurlan Can i create a jira ticket on this?

8

Hi @Naresh9999
I mean that your custom query is incorrect,

- list:
usage: “GAUGE”
description: “Id details”

doesn’t exist in your query

query: “SELECT usename as USER, client_addr as IP, COUNT(client_addr) as THREAD_COUNT FROM pg_stat_activity GROUP BY client_addr,usename ORDER BY usename, client_addr”

so postgres_exporter can’t extract it from result and can’t create metric because of that.