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...