Check if an extension is in use before dropping it in a postgres db

Question

I want to drop unnecessary extensions in my database. But before i do that , i want to make sure that they are not being used anywhere in the database. I have tried using the below query to find functions that make use of the extension like pgcrypto . Im not sure if this is enough

select proname,prosrc from pg_proc where prosrc ilike '% encrypt%'

Laurenz Albe · Accepted Answer · 2022-03-08 16:25:51Z

2

There is no good way to do that.

Your example shows that it is difficult to check if extensions are used in database functions, but you will never be able to tell if SQL statements sent from the client use the extension just by querying the database.

answered Mar 8, 2022 at 16:25

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check if an extension is in use before dropping it in a postgres db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related