# Activate Extensions

Several PostgreSQL extensions are preinstalled and can be activated for your cluster. You can activate the extension by logging into your cluster and executing the following command:

```bash
create extension <EXTENSION> CASCADE;
```

The following table shows extensions available for PostgreSQL. Extensions marked with ✅ indicate that they are active by default. Other extensions need to be activated manually and apply to PostgreSQL clusters with version 15 and above.

| **Extension**        | **Activated** | **Version** | **Description**                                                              |
| -------------------- | :-----------: | :---------: | ---------------------------------------------------------------------------- |
| `pg_stat_statements` |       ✅       |     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.           |
| `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.                  |
| `plpgsql`            |       ✅       |     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.                                         |
| `btree_gin`          |               |     1.3     | Support for indexing standard datatypes in Generalized Inverted Index (GIN). |
| `pg_stat_kcache`     |       ✅       |    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.                        |
| `uuid_ossp`          |               |     1.1     | Generate Universally Unique Identifiers (UUIDs).                             |
| `hstore`             |               |     1.8     | Data type for storing sets of `key, value`.                                  |
| `btree_gist`         |               |     1.6     | Support indexing common datatypes in Generalized Search Tree (GiST).         |

{% hint style="info" %}
**Note:** With `select * from pg_available_extensions;` you will see more available extensions, but only those that can be activated or used with regular user rights are listed here.
{% endhint %}