Pg_stat_monitor (2.1.0) having issues in Percona Postgres server 16.8

PostgreSQL
1

Dear Percona team

As per our Infosec team, Postgres 16.8 is not vulnerable and needs to be upgraded in all our Production servers however, we are having frequent crashes due to pg_stat_monitor version 2.1.0 which was reported earlier. We had tried installing 2.0 however still issue persist. Without pg_stat_monitor we cannot use QAN in PMM hence this is becoming a show stopper for implementing in our prod environments. Kindly provide a permanent solution for this.

2

@Mohan

Did you try with latest pg_stat_monitor v2.2 ? It should support fine with PG 16. Let us know if you still facing the issues.

bash-4.4$ psql
psql (16.7)
Type "help" for help.

postgres=# \dx pg_stat_monitor

      Name       | Version | Schema |                                                                                                                        Descripti
on                                                                                                                        
-----------------+---------+--------+---------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------
 pg_stat_monitor | 2.2     | public | The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg
_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
(1 row)

Moreover, are there any particular queries or operations where the crash usually triggers or it happens randomly ? Do you have the postgres error logs for a review ?

As far as QAN is concerned you can also rely on pg_stat_statements - PostgreSQL - Percona Monitoring and Management

Regards,
Anil