Activate Extensions

Available PostgreSQL extensions

There are several PostgreSQL extensions preinstalled, that you can enable for your cluster. You can enable the extension by logging into your cluster and executing:

create extension <EXTENSION> CASCADE;

The following table shows which extensions are enabled by default and which can be enabled (PostgreSQL version 15):

Extension	Enabled	Version	Description
plpython3u	X	1.0	PL/Python3U untrusted procedural language
pg_stat_statements	X	1.10	track execution statistics of all SQL statements executed
intarray		1.5	functions, operators, and index support for 1-D arrays of integers
pg_trgm		1.6	text similarity measurement and index searching based on trigrams
pg_cron		1.6	Job scheduler for PostgreSQL
set_user		4.0.1	similar to SET ROLE but with added logging
timescaledb		2.14.2	Enables scalable inserts and complex queries for time-series data
tablefunc		1.0	functions that manipulate whole tables, including crosstab
pg_auth_mon	X	1.1	monitor connection attempts per user
plpgsql	X	1.0	PL/pgSQL procedural language
pg_partman		5.1.0	Extension to manage partitioned tables by time or ID
hypopg		1.4.1	Hypothetical indexes for PostgreSQL
postgres_fdw	X	1.1	foreign-data wrapper for remote PostgreSQL servers
btree_gin		1.3	support for indexing common datatypes in GIN
pg_stat_kcache	X	2.3.0	Kernel statistics gathering
citext		1.6	data type for case-insensitive character strings
pgcrypto		1.3	cryptographic functions
earthdistance		1.1	calculate great-circle distances on the surface of the Earth
postgis		3.5.0	PostGIS geometry and geography spatial types and functions
cube		1.5	data type for multidimensional cubes
vector		0.8	vector data type and ivfflat and hnsw access methods

Note: With select * from pg_available_extensions; you will see more available extensions, but many of them can't be enabled or used without superuser rights and thus aren't listed here.