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 12):

Extension	Enabled	Version	Description
plpython3u	X	1.0	PL/Python3U untrusted procedural language
pg_stat_statements	X	1.7	track execution statistics of all SQL statements executed
intarray		1.2	functions, operators, and index support for 1-D arrays of integers
pg_trgm		1.4	text similarity measurement and index searching based on trigrams
pg_cron		1.3	Job scheduler for PostgreSQL
set_user		3.0	similar to SET ROLE but with added logging
timescaledb		2.4.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		4.5.1	Extension to manage partitioned tables by time or ID
hypopg		1.1.4	Hypothetical indexes for PostgreSQL
postgres_fdw	X	1.0	foreign-data wrapper for remote PostgreSQL servers
btree_gin		1.3	support for indexing common datatypes in GIN
pg_stat_kcache	X	2.2.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.2.1	PostGIS geometry and geography spatial types and functions
cube		1.4	data type for multidimensional cubes

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.