# Custom-Query not enabled into percona dashboard

**URL:** <https://forums.percona.com/t/custom-query-not-enabled-into-percona-dashboard/29975>\
**Category:** Percona Distribution for PostgreSQL\
**Tags:** pmm, percona\
**Created:** [April 30, 2024, 2:51pm UTC](https://forums.percona.com/t/custom-query-not-enabled-into-percona-dashboard/29975 "2024-04-30T14:51:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prvn\_3005](https://avatars.discourse-cdn.com/v4/letter/p/ba9def/32.png) [@Prvn\_3005](https://forums.percona.com/u/Prvn_3005)\
**Post date:** [April 30, 2024, 2:51pm UTC](https://forums.percona.com/t/custom-query-not-enabled-into-percona-dashboard/29975/1 "2024-04-30T14:51:24Z")

</div>

1. I have created a simple custom query in the path: /usr/local/percona/pmm2/collectors/custom-queries/postgresql/low-resolution.
2. Then restarted PMM\_server.
3. Then verified with percona dashboard [Insight][Advanced Data Exploration]—customized metrics not enabled into Percona Dashboard.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/a/b/ab5ebd4855a8b473a52b52a847b742e8892e6bed.png)

- Did I miss anything? Kindly help me with 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:** [April 30, 2024, 4:22pm UTC](https://forums.percona.com/t/custom-query-not-enabled-into-percona-dashboard/29975/2 "2024-04-30T16:22:48Z")

</div>

Hi, did you restart PMM Client?

---

<div class="post-metadata">

**Author:** ![Prvn\_3005](https://avatars.discourse-cdn.com/v4/letter/p/ba9def/32.png) [@Prvn\_3005](https://forums.percona.com/u/Prvn_3005)\
**Post date:** [April 30, 2024, 5:21pm UTC](https://forums.percona.com/t/custom-query-not-enabled-into-percona-dashboard/29975/3 "2024-04-30T17:21:13Z")

</div>

Hi Nurlan,

Thank you for your response.

- Yes, I have restarted the PMM client.

---

<div class="post-metadata">

**Author:** ![Prvn\_3005](https://avatars.discourse-cdn.com/v4/letter/p/ba9def/32.png) [@Prvn\_3005](https://forums.percona.com/u/Prvn_3005)\
**Post date:** [May 2, 2024, 6:24am UTC](https://forums.percona.com/t/custom-query-not-enabled-into-percona-dashboard/29975/4 "2024-05-02T06:24:02Z")

</div>

Hi Nurlan,  
In the Percona Dashboard, custom queries are still not enabled.

FYI.

1. I have installed PMM-Server as docker image.
2. Set-up PMM-Client as Package manager.
3. Registered node with PMM-Server.
4. Set-up Completed to monitor postgresql.
5. Verified with Dashboard, all metrics has been monitored as per documentation.
6. But tried to create custom queries to create custom metrics in percona dashboard using YAML file into the path : /usr/local/percona/pmm2/collectors/custom-queries/postgresql/low-resolution and also restarted both pmm-server and pmm-client. but customized metrics not enabled into Percona Dashboard.

- Kindly help me with this.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/2/5/25536982165333143258ff17c1c2254b28378438.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/0/a/0a450747797ba99247b00fa44051008c4db880e8.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/a/b/ab5ebd4855a8b473a52b52a847b742e8892e6bed.png)

---

<div class="post-metadata">

**Author:** ![mateusz.henicz](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mateusz.henicz/32/6935_2.png) [@mateusz.henicz](https://forums.percona.com/u/mateusz.henicz)\
**Post date:** [May 6, 2024, 11:28am UTC](https://forums.percona.com/t/custom-query-not-enabled-into-percona-dashboard/29975/5 "2024-05-06T11:28:33Z")

</div>

Hey,  
Your query definition seems to be invalid.  
In “metrics” section you have to include all values that will be returned by the query.  
For example:

```auto
metrics:
  - database_name:
      usage: "LABEL"
      description: "Database name"
  - size:
      usage: "GAUGE"
      description: "Size of the database"

```

Also try to match your metric name with the output of query, so use  
`datname as database_name` etc.

Hope it helps!