# 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:

```bash
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                               |

{% hint style="info" %}
**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.
{% endhint %}