PostgreSQL version 14.17, PMM 3.4.1., pg_stat_monitor 2.2 The server has 32GB RAM, 28% allocated for huge pages, shared_buffers size is 25%.
The PostgreSQL logs contain the following entries:
received immediate shutdown request
[pg_stat_monitor] pgsm_shmem_shutdown: Shutdown initiated.
pg_stat_monitor settings:
pg_stat_monitor.pgsm_enable_overflow: true
pg_stat_monitor.pgsm_enable_pgsm_query_id: true
pg_stat_monitor.pgsm_enable_query_plan: true
pg_stat_monitor.pgsm_histogram_max: 30000
pg_stat_monitor.pgsm_histogram_min: 50
pg_stat_monitor.pgsm_max: 256
pg_stat_monitor.pgsm_max_buckets: 20
pg_stat_monitor.pgsm_normalized_query: true
pg_stat_monitor.pgsm_query_shared_buffer: 192
pg_stat_monitor.pgsm_track_application_names: false
pg_stat_monitor.pgsm_track_planning: false
This is a serious bug. We caught it in the test environment.