# PostgreSQL custom query is not working

**URL:** <https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390>\
**Category:** Percona Monitoring and Management (PMM)\
**Created:** [October 15, 2024, 2:18pm UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390 "2024-10-15T14:18:28Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [October 15, 2024, 2:18pm UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/1 "2024-10-15T14:18:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [October 16, 2024, 9:16am UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/2 "2024-10-16T09:16:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [October 16, 2024, 9:20am UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/3 "2024-10-16T09:20:03Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [October 21, 2024, 11:30am UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/4 "2024-10-21T11:30:31Z")

</div>

@Roma_Novikov Can you please help me on this?

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [November 5, 2024, 4:53pm UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/5 "2024-11-05T16:53:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [November 6, 2024, 7:49am UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/6 "2024-11-06T07:49:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [November 6, 2024, 10:40am UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/7 "2024-11-06T10:40:19Z")

</div>

@nurlan Can i create a jira ticket on this?

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [November 8, 2024, 9:27am UTC](https://forums.percona.com/t/postgresql-custom-query-is-not-working/34390/8 "2024-11-08T09:27:31Z")

</div>

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

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

```

doesn’t exist in your query

```auto
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.