# pg\_stat\_monitor **URL:** https://forums.percona.com/c/postgresql/pg-stat-monitor/69.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [About the pg\_stat\_monitor category](https://forums.percona.com/t/about-the-pg-stat-monitor-category/13989)
**Author:** [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\ **Replies:** 0
pg\_stat\_monitor is a Query Performance Monitoring tool for PostgreSQL. It attempts to provide a more holistic picture by providing much-needed query performance insights in a single view. --- ## [Pg\_stat\_monitor 2.1 causes PG17.6 to segfault](https://forums.percona.com/t/pg-stat-monitor-2-1-causes-pg17-6-to-segfault/39523)
**Author:** [@pduchon](https://forums.percona.com/u/pduchon)\ **Replies:** 4\ **Last updated:** [October 24, 2025, 1:58pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-1-causes-pg17-6-to-segfault/39523 "2025-10-24T13:58:58Z")
(gdb) f #0 0x00007f2fd416ea7c in \_\_strlen\_evex () from /lib64/libc.so.6 (gdb) bt full #0 0x00007f2fd416ea7c in \_\_strlen\_evex () from /lib64/libc.so.6 No symbol table info available. #1 0x00000000007b8300 in CleanQuery… --- ## [Pg\_stat\_monitor 2.1.0 - Segmentation fault](https://forums.percona.com/t/pg-stat-monitor-2-1-0-segmentation-fault/36247)
**Author:** [@shigaev.s](https://forums.percona.com/u/shigaev.s)\ **Replies:** 11\ **Last updated:** [April 17, 2025, 2:52pm UTC](https://forums.percona.com/t/pg-stat-monitor-2-1-0-segmentation-fault/36247 "2025-04-17T14:52:01Z")
Hello! There is a PostgreSQL 15.4 cluster with Patroni. Installed packages: percona-haproxy/unknown,now 2:2.8.1-1.jammy amd64 \[installed, can be upgraded to: 2:2.8.11-1.jammy\] percona-patroni/unknown,now 1:3.1.0-1.jamm… --- ## [Minimum grant that PMM requires for monitoring postgres with pg\_stat\_monitor](https://forums.percona.com/t/minimum-grant-that-pmm-requires-for-monitoring-postgres-with-pg-stat-monitor/28637)
**Author:** [@Rithesh\_Sellercraft](https://forums.percona.com/u/Rithesh_Sellercraft)\ **Replies:** 3\ **Last updated:** [February 3, 2025, 12:49pm UTC](https://forums.percona.com/t/minimum-grant-that-pmm-requires-for-monitoring-postgres-with-pg-stat-monitor/28637 "2025-02-03T12:49:50Z")
Description: What are the minimum GRANTs required for the PMM database account? The docs don’t seem to mention this anywhere --- ## [Why are the queryid different?](https://forums.percona.com/t/why-are-the-queryid-different/35979)
**Author:** [@ysh648](https://forums.percona.com/u/ysh648)\ **Replies:** 6\ **Last updated:** [January 8, 2025, 8:43am UTC](https://forums.percona.com/t/why-are-the-queryid-different/35979 "2025-01-08T08:43:41Z")
Hello, I am using pg\_stat\_statements and pg\_stat\_activity and pg\_stat\_monitor. I am curious why the query id is different in the three views. --- ## [Pg\_stat\_monitor paln option guc registration](https://forums.percona.com/t/pg-stat-monitor-paln-option-guc-registration/33311)
**Author:** [@ysh648](https://forums.percona.com/u/ysh648)\ **Replies:** 0\ **Last updated:** [September 24, 2024, 6:04am UTC](https://forums.percona.com/t/pg-stat-monitor-paln-option-guc-registration/33311 "2024-09-24T06:04:27Z")
Hello, I am using pg\_stat\_monitor. I need explain information, so I am using it after activating the option. I would like to register guc to activate the general plaintext part with various options. Is there a reason … --- ## [Postgresql\_pgstatmonitor\_agent running on port 0](https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061)
**Author:** [@Mendbayar\_Alzakhgui](https://forums.percona.com/u/Mendbayar_Alzakhgui)\ **Replies:** 1\ **Last updated:** [August 6, 2024, 8:56am UTC](https://forums.percona.com/t/postgresql-pgstatmonitor-agent-running-on-port-0/32061 "2024-08-06T08:56:54Z")
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 Stat… --- ## [QAN and query plan](https://forums.percona.com/t/qan-and-query-plan/29281)
**Author:** [@lanselot](https://forums.percona.com/u/lanselot)\ **Replies:** 4\ **Last updated:** [April 10, 2024, 8:31am UTC](https://forums.percona.com/t/qan-and-query-plan/29281 "2024-04-10T08:31:31Z")
Hi. Please help. Cant understand where I’ve mistaken. Enabled plan analytics for pg stat monitor: pg\_stat\_monitor.pgsm\_enable\_query\_plan = on It’s even shown in pg\_settings (checked by query). But in grafana shows “No… --- ## [QAN PostgresSQL pg\_stat\_monitor not working](https://forums.percona.com/t/qan-postgressql-pg-stat-monitor-not-working/21447)
**Author:** [@Luke\_Miller](https://forums.percona.com/u/Luke_Miller)\ **Replies:** 2\ **Last updated:** [January 27, 2024, 6:51pm UTC](https://forums.percona.com/t/qan-postgressql-pg-stat-monitor-not-working/21447 "2024-01-27T18:51:07Z")
I am trying to get QAN monitoring for my Postgres database. I have the Postgres server talking to PMM and I am getting OS and Postgres metrics but not QAN. database version: PostgreSQL 12.14 pmm-admin list Service type… --- ## [\[pg\_stat\_monitor\] pg\_stat\_monitor\_internal: API version not supported](https://forums.percona.com/t/pg-stat-monitor-pg-stat-monitor-internal-api-version-not-supported/24614)
**Author:** [@ashvin](https://forums.percona.com/u/ashvin)\ **Replies:** 2\ **Last updated:** [September 3, 2023, 5:15pm UTC](https://forums.percona.com/t/pg-stat-monitor-pg-stat-monitor-internal-api-version-not-supported/24614 "2023-09-03T17:15:20Z")
Hello Percona Team, I am trying to integrate pg\_stat\_monitor with PMM2 Server (Docker Setup). Here are my installed PG packages via Yum. Installed Packages gnupg2.x86\_64 2.0.22-5.el7\_5… --- ## [Cannot request additional shared memory outside shmem\_request\_hook](https://forums.percona.com/t/cannot-request-additional-shared-memory-outside-shmem-request-hook/23444)
**Author:** [@khaled\_ghazy](https://forums.percona.com/u/khaled_ghazy)\ **Replies:** 3\ **Last updated:** [July 21, 2023, 1:36pm UTC](https://forums.percona.com/t/cannot-request-additional-shared-memory-outside-shmem-request-hook/23444 "2023-07-21T13:36:02Z")
I have PostgreSQL 15.3. Then I install pg\_stat\_monitor. Then when I restart the database, it can’t start with this error: -- Unit postgresql-15.service has begun starting up. Jun 20 13:58:12 PostgresqlDB01 postmaster\[18… --- ## [QAN PostgreSQL PgStatements Agent](https://forums.percona.com/t/qan-postgresql-pgstatements-agent/20803)
**Author:** [@Luis\_Carlos\_Badilla](https://forums.percona.com/u/Luis_Carlos_Badilla)\ **Replies:** 2\ **Last updated:** [March 24, 2023, 2:11pm UTC](https://forums.percona.com/t/qan-postgresql-pgstatements-agent/20803 "2023-03-24T14:11:44Z")
I am monitoring an Amazon Aurora Postgresql cluster with Percona and the QA related agents show the status: waiting, what could be the error? --- ## [Pg\_stat\_monitor readiness for PostgreSQL v15](https://forums.percona.com/t/pg-stat-monitor-readiness-for-postgresql-v15/19780)
**Author:** [@VenkataP](https://forums.percona.com/u/VenkataP)\ **Replies:** 5\ **Last updated:** [February 14, 2023, 1:09am UTC](https://forums.percona.com/t/pg-stat-monitor-readiness-for-postgresql-v15/19780 "2023-02-14T01:09:18Z")
Any date by when pg\_stat\_monitor will be certified for PostgreSQL v15? Thanks for the fantastic extension. If ready for v15, would be fantastic to have the documentation updated with this info. Thanks so much --- ## [PostgreSQL Server not visible in QAN](https://forums.percona.com/t/postgresql-server-not-visible-in-qan/18936)
**Author:** [@nikode](https://forums.percona.com/u/nikode)\ **Replies:** 6\ **Last updated:** [December 30, 2022, 9:08pm UTC](https://forums.percona.com/t/postgresql-server-not-visible-in-qan/18936 "2022-12-30T21:08:11Z")
Hi to all. I’m new in PMM2 and I’ve recently installed PMM2 and added the PostgreSQL 11 server. I’ve installed pg\_stat\_monitor. I’ve done it as it mentioned in this document (PostgreSQL - Percona Monitoring and Managemen… --- ## [\[QAN\] - Query Analytics configuration for PostgreSQL](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677)
**Author:** [@waly\_ferreira](https://forums.percona.com/u/waly_ferreira)\ **Replies:** 8\ **Last updated:** [December 5, 2022, 3:23pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677 "2022-12-05T15:23:56Z")
Hello, I have implemented Percona in my environment for PostgreSQL monitoring. All monitoring is happening normally, however when I check in the Query Analytics dashboard, I can only view system queries and not my datab… --- ## [Announcing the release of pg\_stat\_monitor 1.1.0](https://forums.percona.com/t/announcing-the-release-of-pg-stat-monitor-1-1-0/17876)
**Author:** [@Lenz\_Grimmer](https://forums.percona.com/u/Lenz_Grimmer)\ **Replies:** 0\ **Last updated:** [October 6, 2022, 9:48am UTC](https://forums.percona.com/t/announcing-the-release-of-pg-stat-monitor-1-1-0/17876 "2022-10-06T09:48:10Z")
Blog post here: PostgreSQL: Announcing the release of pg\_stat\_monitor 1.1.0 --- ## [New blog post: Understand Your PostgreSQL Workloads Better with pg\_stat\_monitor](https://forums.percona.com/t/new-blog-post-understand-your-postgresql-workloads-better-with-pg-stat-monitor/15618)
**Author:** [@Lenz\_Grimmer](https://forums.percona.com/u/Lenz_Grimmer)\ **Replies:** 0\ **Last updated:** [May 9, 2022, 2:32pm UTC](https://forums.percona.com/t/new-blog-post-understand-your-postgresql-workloads-better-with-pg-stat-monitor/15618 "2022-05-09T14:32:50Z")
Percona’s @Matt\_Yonkovit has written an excellent overview about pg\_stat\_monitor here: Understand Your PostgreSQL Workloads Better with pg\_stat\_monitor - Percona Database Performance Blog