public inbox for pgsql-novice@postgresql.org
help / color / mirror / Atom feedFrom: Laurenz Albe <laurenz.albe@cybertec.at>
To: Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
To: depesz@depesz.com <depesz@depesz.com>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: Re: AW: AW: Is it possible to turn on pg_stat_extensions at a database level
Date: Fri, 13 Mar 2026 07:58:39 +0100
Message-ID: <b0d10cdd0a9f473803b08c1a6c90e9998a43724d.camel@cybertec.at> (raw)
In-Reply-To: <13211e56510045839813da0fe9f1c5e8@alte-leipziger.de>
References: <c263728956fa4dc2b4c00bd3822d497b@alte-leipziger.de>
<abKHnbVxwkrGL1Fb@depesz.com>
<959ecf128e514007a7558febe8b76e35@alte-leipziger.de>
<abKJkKpLVRbApeRY@depesz.com>
<b6e9a932db4e280977db1888acfe03b1f182d8bb.camel@cybertec.at>
<13211e56510045839813da0fe9f1c5e8@alte-leipziger.de>
On Fri, 2026-03-13 at 05:54 +0000, Subramanian,Ramachandran wrote:
> Coming from the mainframe world, we always assume that there is a lot of
> CPU/IO expense to monitor and collect statistics from unnecessary Databases.
>
> This is why I wanted the collection of the statitstics itself to be restricted
> to just one Database.
Ok, now you know that you cannot get it.
I doubt that there are databases where monitoring is unnecessary:
- if there is nothing doing in that database, that won't be a lot of statistics
to collect
- if there is a lot going on in that database, the load will be noteworthy
and can affect your other, necessary, databases in the same cluster, so
you need the statistics to diagnose such problems
Yours,
Laurenz Albe
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-novice@postgresql.org
Cc: laurenz.albe@cybertec.at, ramachandran.subramanian@alte-leipziger.de, depesz@depesz.com, pgsql-novice@lists.postgresql.org
Subject: Re: AW: AW: Is it possible to turn on pg_stat_extensions at a database level
In-Reply-To: <b0d10cdd0a9f473803b08c1a6c90e9998a43724d.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox