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