Re: Check if installed extension is in use - Mailing list pgsql-admin

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