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