Error running query on database cprt_dba_pgsql_cpu_mem_cal_per_query pq: relation pg_activity_with_cpu_mem does not exist

Percona Monitoring and Management (PMM)
1

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
2

Can someone please help me with the above issue?

3

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

4

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?

5

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

6

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

7

Got it, @nurlan

Thanks for all the help and support.