pmm3 docker not show any data of PostgreSQL Top Queries dashboard

[heroes1412]

Description

our env has 1 postgresql v18 running in ubuntu 24.04.

root@postgres18:~# pmm-admin list
Service type Service name Address and port Service ID
PostgreSQL postgres18-postgresql 127.0.0.1:5432 2caa3a93-7208-4f27-b4eb-b2adcd52e061

Agent type Status Metrics Mode Agent ID Service ID Port
pmm_agent Connected 1e30518f-b696-4e0e-8158-389949d9f11b 0
node_exporter Running push 1011863d-fbb4-42ff-964a-531663b646e4 42000
postgres_exporter Running push 473225d1-32fd-4c4c-be9b-4a5efd5254b9 2caa3a93-7208-4f27-b4eb-b2adcd52e061 42001
postgresql_pgstatmonitor_agent Running 93cceed4-cb5e-4a3d-89ab-85e30be185bc 2caa3a93-7208-4f27-b4eb-b2adcd52e061 0
vmagent Running push df5d53bd-c70d-4f5e-bd31-4f799f2cba32 42002

root@postgres18:~# pmm-admin status
Agent ID : 1e30518f-b696-4e0e-8158-389949d9f11b
Node ID : 11012f20-ef6a-4e9e-a769-957aae7480fb
Node name: postgres18

PMM Server:
URL : https://192.168.2.222:443/
Version: 3.5.0

PMM Client:
Connected : true
Time drift : 2.505515ms
Latency : 869.931µs
Connection uptime: 100
pmm-admin version: 3.5.0
pmm-agent version: 3.5.0
Agents:
1011863d-fbb4-42ff-964a-531663b646e4 node_exporter Running 42000
473225d1-32fd-4c4c-be9b-4a5efd5254b9 postgres_exporter Running 42001
93cceed4-cb5e-4a3d-89ab-85e30be185bc postgresql_pgstatmonitor_agent Running 0
df5d53bd-c70d-4f5e-bd31-4f799f2cba32 vmagent Running 42002

pmm3 in docker

Expected Results

can view Top Queries

Actual Results

Top Queries show empty

Version

PMM Server:
URL : https://192.168.2.222:443/
Version: 3.5.0

PMM Client:
Connected : true
Time drift : 2.505515ms
Latency : 869.931µs
Connection uptime: 100
pmm-admin version: 3.5.0
pmm-agent version: 3.5.0

Steps to reproduce

curl -fsSL https://www.percona.com/get/pmm | /bin/bash
guide from https://www.percona.com/software/pmm/quickstart

Relevant logs

Code of Conduct

• I agree to follow Percona Community Code of Conduct