# Postgresql\_pgstatmonitor\_agent running on port 0

**URL:** <https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061>\
**Category:** pg\_stat\_monitor\
**Tags:** pmm, percona, postgres\
**Created:** [August 6, 2024, 7:51am UTC](https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061 "2024-08-06T07:51:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mendbayar\_Alzakhgui](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mendbayar_alzakhgui/32/17558_2.png) [@Mendbayar\_Alzakhgui](https://forums.percona.com/u/Mendbayar_Alzakhgui)\
**Post date:** [August 6, 2024, 7:51am UTC](https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061/1 "2024-08-06T07:51:01Z")

</div>

Hi,  
I registered the postgres pmm-agent to percona server the system level information is okay but the service level data not received, then I checked the pmm-admin list then:

Agent type Status Metrics Mode Agent ID Service ID Port  
pmm\_agent Connected /agent\_id/7418d54d-ff15-4529-a87e-c09fcb267661 0  
node\_exporter Running push /agent\_id/78cd6287-c759-48d4-8d98-4e786932924f 42002  
postgres\_exporter Running push /agent\_id/53d85c0b-fdbb-4d9b-981e-e35e2cdf13e0 /service\_id/8eb2b4f4-82a9-4e6b-908f-41e75d9f4878 42001  
postgresql\_pgstatmonitor\_agent Running /agent\_id/a4b46c59-744d-450c-83de-542cfa43b7a1 /service\_id/8eb2b4f4-82a9-4e6b-908f-41e75d9f4878 0  
vmagent Running push /agent\_id/12c2e1d1-ed43-473c-a744-fee8afd1cbea 42000

pmm-agent and pg\_stat\_monitoring both are latest version. and  
journalctl -u pmm-agent:

pmm-agent[1007]: time=“\*\*\*\*\*\*\*\*\*\*\*\*” level=warning msg=“generating fingerprint failed for query with id -7850817464826231044: failed to normalize the query: syntax error at or near "lect"” agentID=/agent\_id/a4b46c59-744d-450c-83de-542cfa43b7a1 component=agent-builtin type=qan\_postgresql\_pgstatmonitor\_agent

is there any other way to troubleshoot?

---

<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:** [August 6, 2024, 8:56am UTC](https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061/2 "2024-08-06T08:56:54Z")

</div>

@Mendbayar_Alzakhgui please check that pg\_stat\_monitor is working correctly. For example by using query  
– Select some of the query information, like client\_ip, username and application\_name etc.

postgres=# SELECT application\_name, userid AS user\_name, datname AS database\_name, substr(query,0, 50) AS query, calls, client\_ip  
FROM pg\_stat\_monitor;  
application\_name | user\_name | database\_name | query | calls | client\_ip  
------------------±----------±--------------±--------------------------------------------------±------±----------  
psql | vagrant | postgres | SELECT application\_name, userid::regrole AS user\_ | 1 | 127.0.0.1  
psql | vagrant | postgres | SELECT application\_name, userid AS user\_name, dat | 3 | 127.0.0.1  
psql | vagrant | postgres | SELECT application\_name, userid AS user\_name, dat | 1 | 127.0.0.1  
psql | vagrant | postgres | SELECT application\_name, userid AS user\_name, dat | 8 | 127.0.0.1  
psql | vagrant | postgres | SELECT bucket, substr(query,$1, $2) AS query, cmd | 1 | 127.0.0.1  
(5 rows)

from [GitHub - percona/pg\_stat\_monitor: Query Performance Monitoring Tool for PostgreSQL](https://github.com/percona/pg_stat_monitor?tab=readme-ov-file#setup)  
The agent running on port 0 - it’s ok, as this is a part of pmm\_agent