Check if installed extension is in use

From: Christian Lehmann <info(at)chlehmann(dot)ch>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Check if installed extension is in use
Date: 2021-06-30 14:14:34
Message-ID: CAEh-Kgu5MD2XD3bfMrBojAHMbPG3uTbkSR4BtoDYSQJh+YnLBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-06-30 14:27:49 Re: Check if installed extension is in use
Previous Message heiko.onnebrink 2021-06-30 11:22:51 Re: [EXT] FK to partitioned table