List installed extensions

Command

SELECT extname AS extension, extversion AS version FROM pg_extension ORDER BY extname;

What it does

Lists all extensions installed in the current database and their versions.

When to use it

To see which extensions are installed and whether an update is needed.

Caution

To see installable (but not yet installed) extensions: SELECT * FROM pg_available_extensions; Upgrade: ALTER EXTENSION pg_stat_statements UPDATE;