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