# Error running query on database cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation pg\_activity\_with\_cpu\_mem does not exist

**URL:** <https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174>\
**Category:** Percona Monitoring and Management (PMM)\
**Created:** [March 13, 2025, 6:45pm UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174 "2025-03-13T18:45:18Z")\
**Posts on this page:** 7\
**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:** [March 13, 2025, 6:45pm UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174/1 "2025-03-13T18:45:18Z")

</div>

## Description:

We are trying to call the Postgresql view from the pmm agent custom query, but which is actually throwing the errors. But when we login with pmm user, we are able to execute the view. Why is pmm-agent failing? Why are we not able to execute the view from the cutom queries yaml file?

Database: postgres  
schema: public

We have created the view inside the public shcema in the postgres database.

## Steps to Reproduce:

We have created the below custom query.  
cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query:  
query: “select age,datname,usename,state,client\_addr,pid,query\_start,query,cpu\_perc,mem\_perc,stats from pg\_activity\_with\_cpu\_mem”  
metrics:  
- age:  
usage: “LABEL”  
description: “age”  
- datname:  
usage: “LABEL”  
description: “datname Name”  
- usename:  
usage: “LABEL”  
description: “usename Name”  
- state:  
usage: “LABEL”  
description: “state”  
- client\_addr:  
usage: “LABEL”  
description: “client\_addr”  
- pid:  
usage: “LABEL”  
description: “pid”  
- query\_start:  
usage: “LABEL”  
description: “query\_start”  
- query:  
usage: “LABEL”  
description: “query”  
- cpu\_perc:  
usage: “LABEL”  
description: “cpu usage”  
- mem\_perc:  
usage: “LABEL”  
description: “Memory Usage”  
- stats:  
usage: “GAUGE”  
description: “Client Connection”

## Version:

PMM 2.44.0

## Logs:

Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.348+00:00” level=error msg=“ts=2025-03-13T18:36:50.348Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.349+00:00” level=error msg=“ts=2025-03-13T18:36:50.349Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.350+00:00” level=error msg=“ts=2025-03-13T18:36:50.350Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.350+00:00” level=error msg=“ts=2025-03-13T18:36:50.350Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.352+00:00” level=error msg=“ts=2025-03-13T18:36:50.351Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.356+00:00” level=error msg=“ts=2025-03-13T18:36:50.355Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.356+00:00” level=error msg=“ts=2025-03-13T18:36:50.355Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.356+00:00” level=error msg=“ts=2025-03-13T18:36:50.356Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.357+00:00” level=error msg=“ts=2025-03-13T18:36:50.357Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.357+00:00” level=error msg=“ts=2025-03-13T18:36:50.357Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.358+00:00” level=error msg=“ts=2025-03-13T18:36:50.358Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.364+00:00” level=error msg=“ts=2025-03-13T18:36:50.364Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.365+00:00” level=error msg=“ts=2025-03-13T18:36:50.365Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.365+00:00” level=error msg=“ts=2025-03-13T18:36:50.365Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.365+00:00” level=error msg=“ts=2025-03-13T18:36:50.365Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.366+00:00” level=error msg=“ts=2025-03-13T18:36:50.366Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.369+00:00” level=error msg=“ts=2025-03-13T18:36:50.369Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.369+00:00” level=error msg=“ts=2025-03-13T18:36:50.369Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.369+00:00” level=error msg=“ts=2025-03-13T18:36:50.369Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.372+00:00” level=error msg=“ts=2025-03-13T18:36:50.372Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.372+00:00” level=error msg=“ts=2025-03-13T18:36:50.372Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.372+00:00” level=error msg=“ts=2025-03-13T18:36:50.372Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.374+00:00” level=error msg=“ts=2025-03-13T18:36:50.373Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.374+00:00” level=error msg=“ts=2025-03-13T18:36:50.373Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.374+00:00” level=error msg=“ts=2025-03-13T18:36:50.374Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.377+00:00” level=error msg=“ts=2025-03-13T18:36:50.376Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.377+00:00” level=error msg=“ts=2025-03-13T18:36:50.376Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.377+00:00” level=error msg=“ts=2025-03-13T18:36:50.377Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.377+00:00” level=error msg=“ts=2025-03-13T18:36:50.377Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.381+00:00” level=error msg=“ts=2025-03-13T18:36:50.381Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.383+00:00” level=error msg=“ts=2025-03-13T18:36:50.383Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.383+00:00” level=error msg=“ts=2025-03-13T18:36:50.383Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.383+00:00” level=error msg=“ts=2025-03-13T18:36:50.383Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.384+00:00” level=error msg=“ts=2025-03-13T18:36:50.384Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.385+00:00” level=error msg=“ts=2025-03-13T18:36:50.385Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.392+00:00” level=error msg=“ts=2025-03-13T18:36:50.390Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.392+00:00” level=error msg=“ts=2025-03-13T18:36:50.390Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.392+00:00” level=error msg=“ts=2025-03-13T18:36:50.390Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.398+00:00” level=error msg=“ts=2025-03-13T18:36:50.397Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.398+00:00” level=error msg=“ts=2025-03-13T18:36:50.397Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.398+00:00” level=error msg=“ts=2025-03-13T18:36:50.398Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.403+00:00” level=error msg=“ts=2025-03-13T18:36:50.401Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.403+00:00” level=error msg=“ts=2025-03-13T18:36:50.401Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.403+00:00” level=error msg=“ts=2025-03-13T18:36:50.403Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.404+00:00” level=error msg=“ts=2025-03-13T18:36:50.403Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.405+00:00” level=error msg=“ts=2025-03-13T18:36:50.405Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.407+00:00” level=error msg=“ts=2025-03-13T18:36:50.407Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.407+00:00” level=error msg=“ts=2025-03-13T18:36:50.407Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.407+00:00” level=error msg=“ts=2025-03-13T18:36:50.407Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.411+00:00” level=error msg=“ts=2025-03-13T18:36:50.411Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.414+00:00” level=error msg=“ts=2025-03-13T18:36:50.414Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.415+00:00” level=error msg=“ts=2025-03-13T18:36:50.414Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.419+00:00” level=error msg=“ts=2025-03-13T18:36:50.419Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.419+00:00” level=error msg=“ts=2025-03-13T18:36:50.419Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.420+00:00” level=error msg=“ts=2025-03-13T18:36:50.419Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.420+00:00” level=error msg=“ts=2025-03-13T18:36:50.420Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.420+00:00” level=error msg=“ts=2025-03-13T18:36:50.420Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.420+00:00” level=error msg=“ts=2025-03-13T18:36:50.420Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.432+00:00” level=error msg=“ts=2025-03-13T18:36:50.431Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.432+00:00” level=error msg=“ts=2025-03-13T18:36:50.431Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.433+00:00” level=error msg=“ts=2025-03-13T18:36:50.433Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.437+00:00” level=error msg=“ts=2025-03-13T18:36:50.433Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.437+00:00” level=error msg=“ts=2025-03-13T18:36:50.433Z caller=namespace.go:236 level=error err="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.437+00:00” level=error msg=“ts=2025-03-13T18:36:50.435Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.437+00:00” level=error msg=“ts=2025-03-13T18:36:50.435Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.437+00:00” level=error msg=“ts=2025-03-13T18:36:50.437Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.443+00:00” level=error msg=“ts=2025-03-13T18:36:50.443Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.443+00:00” level=error msg=“ts=2025-03-13T18:36:50.443Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.443+00:00” level=error msg=“ts=2025-03-13T18:36:50.443Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.445+00:00” level=error msg=“ts=2025-03-13T18:36:50.445Z caller=server.go:130 level=error msg="NAMESPACE ERRORS FOUND"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.445+00:00” level=error msg=“ts=2025-03-13T18:36:50.445Z caller=server.go:132 level=error namespace=cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query msg="Error running query on database \"10.120.1.12:5432\": cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query pq: relation \"pg\_activity\_with\_cpu\_mem\" does not exist"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter  
Mar 13 18:36:50 tppmm101 pmm-agent[2198229]: time=“2025-03-13T18:36:50.445+00:00” level=error msg=“ts=2025-03-13T18:36:50.445Z caller=postgres\_exporter.go:769 level=error err="queryNamespaceMappings returned 1 errors"” agentID=/agent\_id/88456a5b-80c0-4de2-aebb-0bc2b2200c85 component=agent-process type=postgres\_exporter

## Expected Result:

[What the user expected to see or happen before the issue occurred]

## Actual Result:

[What actually happened when the user encountered the issue]

## Additional Information:

When we diretcly run the query its running fine with the pmm user.

## postgres=# select age,datname,usename,state,client\_addr,pid,query\_start,query,cpu\_perc,mem\_perc,stats from pg\_activity\_with\_cpu\_mem; age | datname | usename | state | client\_addr | pid | query\_start | query | cpu\_perc | mem\_perc | stats -----------------±------------------------±-------------------±------±---------------±--------±------------------------------±----------

---------------------------------------------------±---------±---------±----------------------------------------  
| otlb | do\_mt\_usr | idle | 10.1.170.227 | 2179464 | |

```
                                               | 0 | 0.1 | PostgreSQL JDBC Driver
             | bdb | postgres | idle | | 1264894 | |

                                               | 0.1 | 0.9 | TimescaleDB Background Worker Scheduler
             | lds | postgres | idle | | 1264895 | |

                                               | 0 | 0.6 | TimescaleDB Background Worker Scheduler
             | coai | postgres | idle | | 1264896 | |

                                               | 0 | 0.6 | TimescaleDB Background Worker Scheduler
             | otb | do_mt_usr | idle | 10.1.170.227 | 2181527 | |

                                               | 0 | 0.1 | PostgreSQL JDBC Driver

```

---

<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:** [March 14, 2025, 4:30am UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174/2 "2025-03-14T04:30:53Z")

</div>

Can someone please help me with the above issue?

---

<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:** [March 14, 2025, 9:13am UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174/3 "2025-03-14T09:13:19Z")

</div>

try to add `master: true`, by default it goes through all databases.

---

<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:** [March 14, 2025, 11:54am UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174/4 "2025-03-14T11:54:21Z")

</div>

Hi @nurlan

Thanks for the help.

If we want to use different schemas from different databases, then how can we accommodate this scenario?

Ex:  
database: test  
Schema: test123  
table: t1

How can I use the schema name in the custom query file?

---

<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:** [March 14, 2025, 3:15pm UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174/5 "2025-03-14T15:15:41Z")

</div>

@nurlan

I have tried the master option this time with no errors, but I am not able to see the metric in the advanced data explorer dashboard. Can you please help? anything i missing here or syntax issue?

cprt\_dba\_pgsql\_cpu\_mem\_cal\_per\_query:  
query: “select age,datname,usename,state,client\_addr,pid,query\_start,query,cpu\_perc,mem\_perc,stats from pg\_activity\_with\_cpu\_mem”  
master: true  
metrics:  
- age:  
usage: “LABEL”  
description: “age”  
- datname:  
usage: “LABEL”  
description: “datname Name”  
- usename:  
usage: “LABEL”  
description: “usename Name”  
- state:  
usage: “LABEL”  
description: “state”  
- client\_addr:  
usage: “LABEL”  
description: “client\_addr”  
- pid:  
usage: “LABEL”  
description: “pid”  
- query\_start:  
usage: “LABEL”  
description: “query\_start”  
- query:  
usage: “LABEL”  
description: “query”  
- cpu\_perc:  
usage: “LABEL”  
description: “cpu usage”  
- mem\_perc:  
usage: “LABEL”  
description: “Memory Usage”  
- stats:  
usage: “LABEL”  
description: “Client Connection”

---

<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:** [March 14, 2025, 3:44pm UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174/6 "2025-03-14T15:44:39Z")

</div>

All fields has usage set as “LABEL”, so it doesn’t know what to use as value.

---

<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:** [March 14, 2025, 7:30pm UTC](https://forums.percona.com/t/error-running-query-on-database-cprt-dba-pgsql-cpu-mem-cal-per-query-pq-relation-pg-activity-with-cpu-mem-does-not-exist/37174/7 "2025-03-14T19:30:28Z")

</div>

Got it, @nurlan

Thanks for all the help and support.
