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

From Christian Lehmann
Subject Check if installed extension is in use
Date
Msg-id CAEh-Kgu5MD2XD3bfMrBojAHMbPG3uTbkSR4BtoDYSQJh+YnLBA@mail.gmail.com
Whole thread Raw
Responses Re: Check if installed extension is in use
List pgsql-admin
Hi List
I am currently building a new postgresql-13 (maybe 14, if release is
on time) cluster which will replace the currently running 9.6
instances. I don't know much about the data(bases) which are on these
clusters.

I saw that plpythonu is installed on all instances. As I understand,
the only version of plpython is version 3 and existing scripts may no
longer work with python3.

Now my question: Is it possible to see if a certain extension is in
active use? Do I have to switch on statement-logs to see it?
Unfortunately even (some) application-owners cannot answer if I ask
them if the python is used.

I hope my question is clear enough.
Chris



pgsql-admin by date:

Previous
From: Piotr Włodarczyk
Date:
Subject: Re: [EXT] FK to partitioned table
Next
From: Laurenz Albe
Date:
Subject: Re: Check if installed extension is in use