# \[pg\_stat\_monitor\] pg\_stat\_monitor\_internal: API version not supported

**URL:** <https://forums.percona.com/t/pg-stat-monitor-pg-stat-monitor-internal-api-version-not-supported/24614>\
**Category:** pg\_stat\_monitor\
**Created:** [August 23, 2023, 8:47am UTC](https://forums.percona.com/t/pg-stat-monitor-pg-stat-monitor-internal-api-version-not-supported/24614 "2023-08-23T08:47:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashvin](https://avatars.discourse-cdn.com/v4/letter/a/ba8739/32.png) [@ashvin](https://forums.percona.com/u/ashvin)\
**Post date:** [August 23, 2023, 8:47am UTC](https://forums.percona.com/t/pg-stat-monitor-pg-stat-monitor-internal-api-version-not-supported/24614/1 "2023-08-23T08:47:50Z")

</div>

Hello Percona Team,

I am trying to integrate pg\_stat\_monitor with PMM2 Server (Docker Setup). Here are my installed PG packages via Yum.

```auto
Installed Packages
gnupg2.x86_64 2.0.22-5.el7_5 @base
gpgme.x86_64 1.3.2-5.el7 @base
libgpg-error.x86_64 1.12-3.el7 @base
pg_stat_monitor_12.x86_64 2.0.1-1PGDG.rhel7 @pgdg12
pganalyze-collector.x86_64 0.50.1-1 @pganalyze_collector
pgdg-redhat-repo.noarch 42.0-32 @/pgdg-redhat-repo-latest.noarch
postgresql12.x86_64 12.15-1PGDG.rhel7 @pgdg12
postgresql12-contrib.x86_64 12.15-1PGDG.rhel7 @pgdg12
postgresql12-devel.x86_64 12.15-1PGDG.rhel7 @pgdg12
postgresql12-libs.x86_64 12.15-1PGDG.rhel7 @pgdg12
postgresql12-server.x86_64 12.15-1PGDG.rhel7 @pgdg12
pygpgme.x86_64 0.3-9.el7 @base

```

Atleast, according to me - I am using the latest version of PMM Server and pg\_stat\_monitor, But I am getting error while querying pg\_stat\_monitor.

```auto
postgres=# SELECT pg_stat_monitor_version();
 pg_stat_monitor_version
-------------------------
 2.0.1
(1 row)

postgres=# select count(*) from pg_stat_monitor;
ERROR: [pg_stat_monitor] pg_stat_monitor_internal: API version not supported.
HINT: Upgrade pg_stat_monitor extension

```

Also, here is how its configured in postgresql.conf

```auto
shared_preload_libraries = 'pg_prewarm, timescaledb, auto_explain, pg_stat_statements, pg_stat_monitor'
auto_explain.log_min_duration = '0.5s'
auto_explain.log_format = 'json'
auto_explain.log_min_duration = '500'
auto_explain.log_analyze = 'on'
auto_explain.log_buffers = 'on'
auto_explain.log_timing = 'off'
auto_explain.log_triggers = 'on'
auto_explain.log_verbose = 'on'
auto_explain.log_nested_statements = 'on'
auto_explain.sample_rate= '1'

pg_stat_monitor.pgsm_query_max_len = 4096
pg_stat_monitor.pgsm_normalized_query = 0
pg_stat_monitor.pgsm_enable_query_plan = 1

```

Also, in case if this is useful, here is pmm-admin status:

```auto
pmm-admin status
Agent ID : /agent_id/4d8ed7c0-23db-4bad-9d34-b4a8a4d3a58a
Node ID : /node_id/e94a5f96-cc32-460a-add6-606bc4513c5b
Node name: xxxx

PMM Server:
	URL : https://xxx:443/
	Version: 2.39.0

PMM Client:
	Connected : true
	Time drift : 7.309169ms
	Latency : 7.56792ms
	Connection uptime: 100
	pmm-admin version: 2.37.0
	pmm-agent version: 2.37.0
Agents:
	/agent_id/0968c78a-fab2-41f6-ac9a-ac59ec5c503b vmagent Running 42000
	/agent_id/36ad5207-3c96-4c15-9d82-6790214ee137 postgresql_pgstatmonitor_agent Waiting 0
	/agent_id/38c5e31f-562f-4ab2-9e64-87dd6eed4ef9 postgres_exporter Running 42001
	/agent_id/9d53d8b5-f720-46ee-a523-01809d7749ef node_exporter Running 42002

```

Kindly help to find the issue and please share what I am missing here. Thank you for your time in advance.

---

<div class="post-metadata">

**Author:** ![ashvin](https://avatars.discourse-cdn.com/v4/letter/a/ba8739/32.png) [@ashvin](https://forums.percona.com/u/ashvin)\
**Post date:** [August 23, 2023, 6:53pm UTC](https://forums.percona.com/t/pg-stat-monitor-pg-stat-monitor-internal-api-version-not-supported/24614/2 "2023-08-23T18:53:57Z")

</div>

hello, anyone can help?

---

<div class="post-metadata">

**Author:** ![ashvin](https://avatars.discourse-cdn.com/v4/letter/a/ba8739/32.png) [@ashvin](https://forums.percona.com/u/ashvin)\
**Post date:** [September 3, 2023, 5:15pm UTC](https://forums.percona.com/t/pg-stat-monitor-pg-stat-monitor-internal-api-version-not-supported/24614/3 "2023-09-03T17:15:20Z")

</div>

Anyone can help … Please!!