PostgreSQL list installed extensions

SELECT * FROM pg extension;
extname       | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
--------------+----------+--------------+----------------+------------+-----------+--------------
plpgsql            |       10 |           11 | f              | 1.0        |           |
pg_stat_statements |       10 |         2200 | t              | 1.6        |           |
(2 rows)

\dx
                                    List of installed extensions
       Name        | Version |   Schema   |                        Description
--------------------+---------+------------+-----------------------------------------------------------
pg_stat_statements | 1.6     | public     | track execution statistics of all SQL statements executed
plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)

your-db=# \dx
                 List of installed extensions
  Name   | Version |   Schema   |         Description
---------+---------+------------+------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
(1 row)

\dx
                                            List of installed extensions
        Name        | Version |   Schema   |                              Description
--------------------+---------+------------+------------------------------------------------------------------------
 pg_stat_statements | 1.11    | public     | track planning and execution statistics of all SQL statements executed
 plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)

Related

• CREATE EXTENSION

See also

• CREATE EXTENSION pg_stat_statements, ~/brew/share/postgresql@17/extension/
• PostgreSQL, PostgreSQL extensions, CREATE EXTENSION, List extensions (\dx)