Message-ID: <b0d10cdd0a9f473803b08c1a6c90e9998a43724d.camel@cybertec.at>
Subject: Re: AW: AW: Is it possible to turn on pg_stat_extensions at a
 database level
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>,
  "depesz@depesz.com"	 <depesz@depesz.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Date: Fri, 13 Mar 2026 07:58:39 +0100
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>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/b0d10cdd0a9f473803b08c1a6c90e9998a43724d.camel%40cybertec.at>
Precedence: bulk

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 Databas=
es.=20
>=20
> This is why I wanted the collection of the statitstics itself to be restr=
icted
> to just one Database.=20

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 statis=
tics
  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