Performance issue

[kayform]

I recently installed pg_stat_monitor to find top queries,
and after executing 'create extension pg_stat_monitor;' and then running 'select * from pg_stat_monitor;', I
noticed that the DBMS became significantly slower, with all sessions appearing to be affected.
The parameters of pg_stat_monitor are in their default state.

environment

OS : aws amazon linux
RAM : 64GB
CPU : 32 core
postgresql 14.5
pg_stat_monitor 2.0.2
parameter : pg_stat_monitor default
The data capacity is approximately 7TB
500 TPS based on the pg_stat_database

[unikzforce]

so in the end was that really a performance issue created by pg_stat_monitor, or it was something else?

[MichaelDBA]

Also interested in reply...

[artemgavrilov]

Hello @kayform , one of the things that can cause performance degradation for setups with big number of connections is application name tracking. We just released PGSM v2.1.0 that allows to disable app name tracking, see docs: https://docs.percona.com/pg-stat-monitor/configuration.html#pg_stat_monitorpgsm_track_application_names