public inbox for pgsql-novice@postgresql.org
help / color / mirror / Atom feedFrom: Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: depesz@depesz.com <depesz@depesz.com>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: AW: AW: Is it possible to turn on pg_stat_extensions at a database level
Date: Fri, 13 Mar 2026 05:54:42 +0000
Message-ID: <13211e56510045839813da0fe9f1c5e8@alte-leipziger.de> (raw)
In-Reply-To: <b6e9a932db4e280977db1888acfe03b1f182d8bb.camel@cybertec.at>
References: <c263728956fa4dc2b4c00bd3822d497b@alte-leipziger.de>
<abKHnbVxwkrGL1Fb@depesz.com>
<959ecf128e514007a7558febe8b76e35@alte-leipziger.de>
<abKJkKpLVRbApeRY@depesz.com>
<b6e9a932db4e280977db1888acfe03b1f182d8bb.camel@cybertec.at>
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.
LG
Ram
Freundliche Grüße
i. A. Ramachandran Subramanian
Zentralbereich Informationstechnologie
Alte Leipziger Lebensversicherung a.G.
Hallesche Krankenversicherung a.G.
Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Oberursel
Vors. des Aufsichtsrats: Dr. Walter Botermann · Vorstand: Christoph Bohn (Vors.), Dr. Jürgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek
Sitz Oberursel (Taunus) · Rechtsform VVaG · Amtsgericht Bad Homburg v. d. H. HRB 1583 · USt.-IdNr. DE 114106814
Hallesche Krankenversicherung a.G., Löffelstraße 34-38, 70597 Stuttgart
Vors. des Aufsichtsrats: Dr. Walter Botermann · Vorstand: Christoph Bohn (Vors.), Dr. Jürgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape,
Wiltrud Pekarek, Udo Wilcsek
Sitz Stuttgart · Rechtsform VVaG · Amtsgericht Stuttgart HRB 2686 · USt.-IdNr. DE 147802285
Beiträge zu privaten Kranken- und Pflegekrankenversicherungen unterliegen nicht der Versicherungsteuer (§ 4 Nr. 5 VersStG) · Versicherungsleistungen sowie Umsätze aus Versicherungsvertreter-/Maklertätigkeiten sind umsatzsteuerfrei
Die Pflichtangaben der ALH Gruppe gemäß § 35a GmbHG bzw. § 80 AktG finden Sie hier: https://www.alte-leipziger.de/impressum
______________________
ALH Gruppe
Alte Leipziger-Platz 1, 61440 Oberursel
Tel.: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882
E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de
-----Ursprüngliche Nachricht-----
Von: Laurenz Albe <laurenz.albe@cybertec.at>
Gesendet: Donnerstag, 12. März 2026 21:00
An: depesz@depesz.com; Subramanian,Ramachandran IT-md-db <ramachandran.subramanian@alte-leipziger.de>
Cc: pgsql-novice@lists.postgresql.org
Betreff: Re: AW: Is it possible to turn on pg_stat_extensions at a database level
On Thu, 2026-03-12 at 10:38 +0100, hubert depesz lubaczewski wrote:
> On Thu, Mar 12, 2026 at 09:33:29AM +0000, Subramanian,Ramachandran wrote:
> > I meant to ask if the extension can be created only for one database, so that the details from the other databases are not recorded.
>
> So, no. You can't.
... but there is no need to do that.
If you are only interested in the statistics for statements on a single database, add a WHERE condition with the database's object ID, like
WHERE dbid = 47110815
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: ramachandran.subramanian@alte-leipziger.de, laurenz.albe@cybertec.at, 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: <13211e56510045839813da0fe9f1c5e8@alte-leipziger.de>
* 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