Hi so 25. 1. 2025 v 12:23 odesÃlatel Frits Hoogland <frits.hoogl...@gmail.com> napsal:
> For monitoring database behaviour and trying to build an history of > activity, if I would create an application that creates a single connection > and execute something like: > select * from pg_stat_activity; > select * from pg_stat_database; > select * from pg_stat_bgwriter; > select * from pg_stat_wal; > select * from pg_settings; > select * from pg_database; > For which the query is prepared, and execute that every 1 second, would > there be any realistic danger or overhead that should be considered? > My thinking is that the data for these catalogs are all in shared memory > and when executed serially and do not cause any significant resources to be > taken? > The queries to all tables excluding pg_database every 1 sec will have probably zero impact to performance. I am not sure about pg_database - it is a very important table, and your query can block operations that need exclusive lock to this table. So theoretically, there can be some impact to performance. Regards Pavel > > Thanks, > > *Frits Hoogland* > > > > >
