From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Christian Lehmann <info@chlehmann.ch>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Check if installed extension is in use
Date: Wed, 30 Jun 2021 16:27:49 +0200
Message-ID: <a3f28b14e95be6472dfd81eb5b9a475d2cd2c36f.camel@cybertec.at> (raw)
In-Reply-To: <CAEh-Kgu5MD2XD3bfMrBojAHMbPG3uTbkSR4BtoDYSQJh+YnLBA@mail.gmail.com>
References: <CAEh-Kgu5MD2XD3bfMrBojAHMbPG3uTbkSR4BtoDYSQJh+YnLBA@mail.gmail.com>
On Wed, 2021-06-30 at 16:14 +0200, Christian Lehmann wrote:
> Now my question: Is it possible to see if a certain extension is in
> active use?
BEGIN;
DROP EXTENSION plpython3u;
ROLLBACK;
If you can drop the extension, no objects depend on it.
For example, that will show if there are any PL/Python functions defined.
If you want to know if PL/Python functions are used, monitor
"pg_stat_user_functions" (after enabling "track_functions") and see if
the number of calls is growing.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
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-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, info@chlehmann.ch, pgsql-admin@lists.postgresql.org
Subject: Re: Check if installed extension is in use
In-Reply-To: <a3f28b14e95be6472dfd81eb5b9a475d2cd2c36f.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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox