Re: Any risk or overhead considerations for frequently executing queries against catalog tables?

Hi

so 25. 1. 2025 v 12:23 odesílatel Frits Hoogland <frits.hoogland@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*
>
>
>
>
>