[Yandex Cloud documentation](../../../index.md) > [Yandex MPP Analytics for PostgreSQL](../../index.md) > [Step-by-step guides](../index.md) > Extensions > Managing extensions

# Managing extensions in Yandex MPP Analytics for PostgreSQL

Yandex MPP Analytics for PostgreSQL supports the following Greenplum® and PostgreSQL extensions:

#|
|| **Extension** | **Version for Greenplum®** | **Version for Apache Cloudberry™** ||
|| [autoinc](https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-AUTOINC)
Adds a trigger function to write the next value from a sequence into an integer field.
| 1.0 | 1.0 ||
|| [amcheck](https://www.postgresql.org/docs/current/amcheck.html)
Contains functions for verifying the logical integrity of index structures.
| 1.0 | 1.3 ||
|| [bloom](https://www.postgresql.org/docs/14/bloom.html)
Provides an index access method based on the Bloom filter.
| — | 1.0 ||
|| [bool_plperl](https://www.postgresql.org/docs/14/plperl-funcs.html)
Provides transformation for the `bool` type for the PL/Perl procedural language.
| — | 1.0 ||
|| [btree_gist](https://www.postgresql.org/docs/14/btree-gist.html)
Provides GiST operator classes with behavior similar to B-tree.
| — | 1.6 ||
|| [btree_gin](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-btree_gin.html)
Adds the ability to create GIN indexes for columns suitable for B-tree indexing.
| 1.0 | 1.3 ||
|| [citext](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-citext.html)
Adds a data type for case-insensitive string comparison.
| 1.0 | 1.6 ||
|| [dblink](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-dblink.html)
Enables support for connections to other Greenplum® databases within a session.
| 1.1  | 1.2 ||
|| [dict_int](https://www.postgresql.org/docs/current/dict-int.html)
Adds a dictionary template for full-text search for integers.
| 1.0 | 1.0 ||
|| [dict_xsyn](https://www.postgresql.org/docs/current/dict-xsyn.html)
Adds a dictionary template for full-text search with advanced synonym processing.
| 1.0 | 1.0 ||
|| [diskquota](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-diskquota.html)
Allows limiting the of disk space for schemas and roles in a database.
| 1.0 | 2.3 ||
|| [fuzzystrmatch](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-fuzzystrmatch.html)
Contains functions used to establish the degree of similarity and distance between any two strings.
| 1.0 | 1.1 ||
|| [gp_array_agg](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-gp_array_agg.html)
Adds a parallel implementation of the `array_agg` aggregate function.
| 1.0.0 | — ||
|| [gp_distribution_policy](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-system_catalogs-gp_distribution_policy.html)
Contains information about the table data distribution policy across cluster segments.
| 1.0 | 1.0 ||
|| [gp_debug_numsegments](https://github.com/apache/cloudberry/tree/main/gpcontrib/gp_debug_numsegments)
Provides functions for getting and setting the default number of segments when creating tables.
| — | 1.0 ||
|| [gp_exttable_fdw](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/admin_guide-external-map_ext_to_foreign.html)
Provides an external data wrapper for working with external tables.
| — | 1.0 ||
|| [gp_inject_fault](https://github.com/apache/cloudberry/tree/main/gpcontrib/gp_inject_fault)
Provides an interface for implementing predefined failure points in a running cluster.
| — | 1.0 ||
|| [gp_internal_tools](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/admin_guide-managing-monitor.html#creating-the-session_level_memory_consumption-view)
Contains various internal utilities.
| 1.0.0 | 1.0.0 ||
|| [gp_percentile_agg](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-gp_percentile_agg.html)
Adds an aggregate function for calculation of percentiles.
| 1.0.0 | — ||
|| [gp_relaccess_stats](https://github.com/open-gpdb/gp_relaccess_stats). Yandex Cloud extension

Collects the access statistics for tables and views. For more information, see [Using gp_relaccess_stats](gp_relaccess_stats.md).
| 1.1 | — ||
|| [gp_relsizes_stats](https://github.com/open-gpdb/gp_relsizes_stats). Yandex Cloud extension

Collects file and table size statistics. For more information, see [Using gp_relsizes_stats](gp-relsizes-stats.md).
| 1.0 | — ||
|| [gp_sparse_vector](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-gp_sparse_vector.html)
Adds sparse vectors and related functions.
| 1.0.1 | 1.0.1 ||
|| [gp_stats_collector](https://github.com/apache/cloudberry/blob/main/gpcontrib/gp_stats_collector)
Provides tools for collecting query execution metrics and forwarding them to an external agent.
| 1.1 | 1.1 ||
|| [gp_toolkit](https://cloudberry.apache.org/docs/sys-catalogs/gp_toolkit)
Provides a number of administrative views and functions.
| — | 1.6 ||
|| [gp_url_tools](https://github.com/open-gpdb/gp_url_tools). Yandex Cloud extension

Contains functions for working with URLs. For more information, see [Using gp_url_tools](gp-url-tools.md).
| 1.0 | — ||
|| [hstore](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-hstore.html)
Adds a data type to store key-value pairs in the same field.
| 1.3 | 1.8 ||
|| [hstore_plperl](https://www.postgresql.org/docs/14/hstore.html#id-1.11.7.25.11)
Provides transformation for the `hstore` type for the PL/Perl procedural language.
| — | 1.0 ||
|| [insert_username](https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-INSERT-USERNAME)
Adds a trigger function to write the current user name into a text field.
| 1.0 | 1.0 ||
|| [intagg](https://www.postgresql.org/docs/14/intagg.html). This extension is deprecated.
Adds an integer aggregator and enumerator.
| — | 1.1 ||
|| [intarray](https://www.postgresql.org/docs/current/intarray.html)
Adds functions, operators, and index support for one-dimensional arrays of integers.
| 1.0 | 1.5 ||
|| [isn](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-isn.html)
Adds a data type for working with international product identification standards.
| 1.0 | 1.2 ||
|| [jsonb_plperl](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/admin_guide-query-topics-json-data.html#topic_transforms)
Provides transformation for the `jsonb` type for the PL/Perl procedural language.
| — | 1.0 ||
|| [logerrors](https://github.com/munakoiso/logerrors)
Adds a function for collecting statistics about log messages.
| 2.1 | 2.1 ||
|| [ltree](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-ltree.html)
Adds a data type to represent data labels in a tree hierarchy.
| 1.0 | 1.2 ||
|| [moddatetime](https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-MODDATETIME)
Adds a trigger function to write the current time into the `timestamp` field.
| 1.0 | 1.0 ||
|| [old_snapshot](https://www.postgresql.org/docs/14/oldsnapshot.html)
Enables analysis of the `old_snapshot_threshold` state.
| — | 1.0 ||
|| [orafce](https://github.com/orafce/orafce)
Adds functions and operators that emulate Oracle functions and packages.
| 3.7 | 4.9 ||
|| [pageinspect](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-pageinspect.html)
Provides functions for low-level analysis of database page contents.
| 1.8 | 1.9 ||
|| [pgaudit](https://github.com/open-gpdb/gpdb/tree/OPENGPDB_STABLE/gpcontrib/pgaudit). Yandex Cloud extension.

Adds the ability to maintain audit logs of sessions and objects using the standard PostgreSQL logging system.
| 1.0.9 | — ||
|| [pgcrypto](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-pgcrypto.html)
Adds data encryption features. For more information, see [Using pgcrypto](pgcrypto.md).
| 1.1 | 1.3 ||
|| [pgrowlocks](https://www.postgresql.org/docs/current/pgrowlocks.html)
Provides a function for viewing table row lock details.
| 1.1 | 1.2 ||
|| [pgstattuple](https://www.postgresql.org/docs/current/pgstattuple.html)
Provides functions for retrieving tuple-level statistics.
| 1.2 | 1.5 ||
|| [pg_buffercache](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-modules-pg_buffercache.html)
Provides tools for real-time analysis of the shared buffer cache contents.
| 1.1 | 1.4.1 ||
|| [pg_freespacemap](https://www.postgresql.org/docs/current/pgfreespacemap.html)
Provides tools for analyzing the free space map (FSM).
| 1.0 | 1.2 ||
|| [pg_hint_plan](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-modules-pg_hint_plan.html)
Enables management of query execution plans using hints in SQL comments.
| — | 1.3.9 ||
|| [pg_prewarm](https://www.postgresql.org/docs/current/pgprewarm.html)
Provides a way to load relation data into the operating system cache or the PostgreSQL buffer cache.
| 1.0 | 1.2 ||
|| [pg_stat_statements](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-modules-pg_stat_statements.html)
Provides tools to track planning and execution statistics for SQL statements.
| 1.2 | 1.9 ||
|| [pg_surgery](https://www.postgresql.org/docs/14/pgsurgery.html)
Provides functions for repairing corrupted relations.
| — | 1.0 ||
|| [pg_trgm](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-pg_trgm.html)
Adds functions and operators for text similarity detection and indexing operators to search for similar strings.
| 1.1 | 1.6 ||
|| [pg_visibility](https://www.postgresql.org/docs/14/pgvisibility.html)
Provides tools for analyzing the visibility map and information about relation page visibility.
| — | 1.2 ||
|| [plperl](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/analytics-pl_perl.html)
Enables support for the PL/Perl procedural language.
| 1.0 | 1.0 ||
|| [plpgsql](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/analytics-pl_sql.html)
Enables support for the PL/pgSQL procedural language.
| 1.0 | 1.0 ||
|| [postgis](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/analytics-postGIS.html)
Enables storing and processing GIS (geographic information system) objects in PostgreSQL databases.
| 2.1.5 | — ||
|| [postgres_fdw](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-postgres_fdw.html)
Adds a wrapper for queries against remote PostgreSQL databases.
| 1.0 | 1.1 ||
|| [pxf](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum-platform-extension-framework/6-11/gp-pxf/intro_pxf.html)
Allows operating with heterogeneous data sources.
| 2.0 | 2.1 ||
|| [pxf_fdw](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum-platform-extension-framework/6-11/gp-pxf/intro_pxf.html)
Adds an external data wrapper for accessing heterogeneous data sources.
| — | 2.0 ||
|| [refint](https://www.postgresql.org/docs/current/contrib-spi.html#CONTRIB-SPI-REFINT)
Adds trigger functions for implementing referential integrity.
| 1.0 | 1.0 ||
|| [seg](https://www.postgresql.org/docs/current/seg.html)
Adds a data type for representing intervals or ranges with floating points.
| 1.0 | 1.4 ||
|| [sslinfo](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-sslinfo.html)
Obtains information about the connection's SSL certificate.
| 1.0 | 1.2 ||
|| [tablefunc](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/6/greenplum-database/ref_guide-modules-tablefunc.html)
Adds table functions that return sets of rows.
| 1.0 | 1.0 ||
|| [tcn](https://www.postgresql.org/docs/current/tcn.html)
Adds a trigger function to notify subscribers about changes in tables.
| 1.0 | 1.0 ||
|| [try_convert](https://github.com/open-gpdb/gpdb/tree/OPENGPDB_STABLE/contrib/try_convert). Yandex Cloud extension.

Adds a function to convert data from one type to another. For more information, see [Using try_convert](try_convert.md).
| 1.0 | — ||
|| [tsearch2](https://www.postgresql.org/docs/9.6/tsearch2.html)
Adds features compatible with the full-text search features PostgreSQL had prior to version `8.3`.
| 1.0 | — ||
|| [tsm_system_rows](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-modules-tsm_system_rows.html)
Provides the `SYSTEM_ROWS` table sampling method.
| — | 1.0 ||
|| [tsm_system_time](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-modules-tsm_system_time.html)
Provides the `SYSTEM_TIME` table sampling method.
| — | 1.0 ||
|| [unaccent](https://www.postgresql.org/docs/current/unaccent.html)
Adds a full-text search dictionary that removes diacritics.
| 1.0 | 1.1 ||
|| uuid-cb. Yandex Cloud extension.

Enables the generation and validation of unique IDs in compliance with the Russian Central Bank requirements. For more information, see [Using uuid-cb](uuid-cb.md).
| 1.0 | — ||
|| [uuid-ossp](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-modules-uuid-ossp.html)
Provides functions for generating universally unique identifiers (UUIDs).
| — | 1.1 ||
|| [yezzey](yezzey.md). Yandex Cloud extension.

Enables moving [AO and AOCO tables](../../concepts/tables.md) from cluster storage to cold storage and vice versa. To use this extension, enable [hybrid storage](../../concepts/hybrid-storage.md) in your Yandex MPP Analytics for PostgreSQL cluster.
| 1.8 | 1.8.8 ||
|| [xml2](https://www.postgresql.org/docs/current/xml2.html)
Adds functions for XPath queries and XSLT transformations.
| 1.0 | 1.1 ||
|#

## Retrieving a list of extensions available for installation {#available-extensions}

Connect to the selected database and run this command:

```sql
SELECT * FROM pg_available_extensions();
```

This will display a list of DB extensions available for installation:

```text
name                    | default_version | comment                            
------------------------+-----------------+------------------------------
 diskquota              | 1.0             | Disk Quota Main Program
...
```

## Retrieving a list of installed extensions {#list-extensions}

Connect to the selected database and run this command:

```sql
SELECT extname FROM pg_extension;
```

This will display a list of extensions installed in the DB:

```text
      extname
-------------------
 plpgsql
...
```

## Editing a list of installed extensions {#update-extensions}

Connect to the selected database and run this command:

```sql
CREATE EXTENSION <extension_name>;
```

For more information, see [this Greenplum® article](https://techdocs.broadcom.com/us/en/vmware-tanzu/data-solutions/tanzu-greenplum/7/greenplum-database/ref_guide-sql_commands-CREATE_EXTENSION.html).

_Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries._

_Apache® and Apache Cloudberry™ are registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries._