All Products
Search

This Product

    ApsaraDB RDS:Extensions supported by ApsaraDB RDS for PostgreSQL

    Document Center

    ApsaraDB RDS:Extensions supported by ApsaraDB RDS for PostgreSQL

    Last Updated:Jul 25, 2023

    This topic provides an overview of the extensions and extension versions that are supported by ApsaraDB RDS for PostgreSQL instances.

    Note

    • If your RDS instance does not support a few extensions that are described in the following table, you must update the minor engine version of your RDS instance to the latest version. For more information, see Update the minor engine version of an ApsaraDB RDS for PostgreSQL instance.

    • The following table describes only common extensions. If you want to query the extensions that are supported by your RDS instance, you can run the SELECT * FROM pg_available_extensions; command.

    • Before you use some extensions, you must add the names of the extensions to the value of the shared_preload_libraries parameter of your RDS instance. Otherwise, you cannot create the extensions.

      • The extensions include pg_stat_statements, auth_delay, passwordcheck, auto_explain, pg_pathman, orafce, pgaudit, pglogical, pg_bigm, pg_cron, pg_hint_plan, pg_prewarm, zhparser, timescaledb, pldebugger, and pg_jieba.

      • If you want to use the pldebugger extension, you must add plugin_debugger to the value of the shared_preload_libraries parameter of your RDS instance.

    • For more information about how to modify the shared_preload_libraries parameter, see Manage the parameters of an ApsaraDB RDS for PostgreSQL instance.

    The following tables describe the extensions that are supported by the x86 architecture and the ARM architecture. For more information about the x86 architecture and the ARM architecture, see Architectures.

    Important

    The extensions that are supported for ApsaraDB RDS for PostgreSQL instances are changed. Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run minor engine versions earlier than 20230330. The existing extensions are not affected. For more information, see [Notice] Starting April 17, 2023, some extensions can no longer be created for ApsaraDB RDS for PostgreSQL instances that run earlier minor engine versions.

    x86

    Extension

    15

    14

    13

    12

    11

    10

    Description

    address_standardizer

    3.3.2

    3.1.4

    3.1.4

    3.1.4

    3.1.4

    3.1.4

    This extension is used to standardize the names of geographical locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer.

    address_standardizer_data_us

    3.3.2

    3.1.4

    3.1.4

    3.1.4

    3.1.4

    3.1.4

    This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer.

    aggs_for_arrays

    Not supported

    Not supported

    Not supported

    Not supported

    Not supported

    1.3.1

    This extension provides an extension function that is used to compute the statistics of numeric arrays.

    bloom

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension provides an index access method that is based on Bloom filters.

    btree_gin

    1.3

    1.3

    1.3

    1.3

    1.3

    1.2

    This extension provides sample Generalized Inverted Index (GIN) operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

    btree_gist

    1.7

    1.6

    1.5

    1.5

    1.5

    1.5

    This extension provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

    chkpass

    Not supported

    Not supported

    Not supported

    Not supported

    Not supported

    1.0

    This extension provides a data type that is used to store encrypted passwords.

    citext

    1.6

    1.6

    1.6

    1.6

    1.5

    1.4

    This extension provides a string type that is not case-sensitive.

    cube

    1.5

    1.5

    1.4

    1.4

    1.4

    1.2

    This extension provides a data type that is used to represent multidimensional cubes.

    dblink

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    This extension is used to manage tables across databases.

    decoderbufs

    Not supported

    Not supported

    0.1.0

    0.1.0

    0.1.0

    0.1.0

    This extension is used to generate data that is compatible with the Debezium platform based on the Protocol Buffers protocol.

    dict_int

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension provides a sample add-on dictionary template that is used to run full-text searches.

    earthdistance

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension provides two different methods that are used to compute great-circle distances on the surface of the Earth.

    encdb

    1.1.12

    1.1.12

    1.1.12

    1.1.12

    1.1.12

    1.1.12

    This extension is used to support fully encrypted databases.

    fuzzystrmatch

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension is used to compute the similarity and distance between strings.

    ganos_address_standardizer

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to standardize the names of geographical locations based on PAGC. For more information, see Tuning the Standardizer.

    ganos_address_standardizer_data_us

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer.

    ganos_geometry

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to compute and analyze spatial geometries.

    ganos_geometry_pyramid

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to display 2D geometric big data at high speeds.

    ganos_geometry_sfcgal

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is an extension of the SFCGAL extension and is used to process spatial geometries.

    ganos_geometry_topology

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to compute and analyze spatial geometries.

    ganos_networking

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to compute and analyze spatial network geometries.

    ganos_pointcloud

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to store, compute, and analyze point clouds.

    ganos_pointcloud_geometry

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to store, compute, and analyze point clouds.

    ganos_raster

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to store, compute, and analyze spatial rasters.

    ganos_spatialref

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to compute and analyze spatial references.

    ganos_tiger_geocoder

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to support the TIGER data format that is used by the USCB.

    ganos_trajectory

    5.6

    5.6

    5.6

    5.6

    5.6

    5.5

    This extension is used to compute and analyze objects in the MOD system of Ganos.

    hll

    2.16

    2.16

    2.15

    2.14

    2.14

    Not supported

    This extension is used to estimate business metrics, such as page views (PV) and unique visitors (UV), in an efficient manner.

    hstore

    1.8

    1.8

    1.7

    1.6

    1.5

    1.4

    This extension is used to store key-value pairs within a single PostgreSQL value.

    hypopg

    1.3.1

    1.3.1

    1.3.1

    1.3.1

    1.3.1

    1.3.1

    This extension is used to create virtual indexes.

    index_adviser

    2.0

    2.0

    2.0

    2.0

    2.0

    2.0

    This extension provides index recommendations.

    intagg

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension provides an integer aggregator and an enumerator.

    intarray

    1.5

    1.5

    1.3

    1.2

    1.2

    1.2

    This extension provides functions and operators that are used to manage null-free arrays of integers.

    ip4r

    2.4

    2.4

    2.4

    Not supported

    Not supported

    Not supported

    This extension is used to store IPv4 and IPv6 addresses in PostgreSQL.

    isn

    1.2

    1.2

    1.2

    1.2

    1.2

    1.1

    This extension is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes.

    ltree

    1.2

    1.2

    1.2

    1.1

    1.1

    1.1

    This extension is used to label the data that is stored in a hierarchical tree structure.

    log_fdw

    Not supported

    Not supported

    Not supported

    Not supported

    1.0

    Not supported

    This extension is used to query logs.

    madlib

    Not supported

    Not supported

    Not supported

    1.18.0

    1.18.0

    Not supported

    This extension is an open source library that is used for machine learning and graph computing models.

    mysql_fdw

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension is used to read and write data to an ApsaraDB RDS for MySQL instance or a self-managed MySQL database.

    oracle_fdw

    Not supported

    Not supported

    Not supported

    1.1

    Not supported

    Not supported

    This extension is used to synchronize the update operations on the tables of an ApsaraDB RDS for PostgreSQL instance to the tables of an Oracle database.

    orafce

    3.17

    3.17

    Not supported

    Not supported

    3.8

    3.6

    This extension provides functions that are compatible with Oracle.

    oss_fdw

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension is used to read data from and write data to an OSS bucket.

    pase

    0.0.1

    0.0.1

    0.0.1

    0.0.1

    0.0.1

    Not supported

    This extension is used to search for vectors in an efficient manner.

    pg_bigm

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    This extension is used to create a 2-gram Generalized Inverted Index (GIN) that is used to accelerate full-text searches.

    pg_buffercache

    1.3

    1.3

    1.3

    1.3

    1.3

    1.3

    This extension is used to examine shared buffers in real time.

    pg_concurrency_control

    Not supported

    Not supported

    Not supported

    Not supported

    1.0

    1.0

    This extension is used to control the concurrency of SQL statements.

    pg_cron

    1.5

    1.5

    1.5

    1.1

    1.1

    1.1

    This extension is used to configure scheduled tasks.

    pg_freespacemap

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    This extension is used to examine the free space map (FSM).

    pg_jieba

    1.2.0

    1.2.0

    1.1.0

    1.1.0

    1.1.0

    1.1.0

    This extension is used to segment Chinese text.

    pg_hint_plan

    1.5.0

    1.4.0

    1.3.7

    1.3.7

    1.3.7

    1.3.0

    This extension is used to add hints to SQL statements. The hints are used to change the execution plans of SQL statements.

    pg_partman

    4.7.3

    4.7.3

    4.7.3

    4.7.3

    Not supported

    Not supported

    This extension is used to create and manage time-based and sequence-based table partition sets.

    pg_pathman

    Not supported

    Not supported

    1.5

    1.5

    1.5

    1.5

    This extension is used to partition tables at high performance.

    pg_prewarm

    1.2

    1.2

    1.2

    1.2

    1.2

    1.1

    This extension is used to load data to the buffer of the operating system or PostgreSQL database engine.

    pg_profile

    4.1

    4.1

    4.1

    4.1

    4.1

    4.1

    This extension is used to collect statistics on resource-intensive activities.

    pg_repack

    1.4.8

    1.4.7

    1.4.6

    1.4.6

    1.4.6

    1.4.6

    This extension is used to clear tablespaces that stay online.

    pg_sphere

    Not supported

    Not supported

    Not supported

    Not supported

    Not supported

    1.0

    This extension provides spherical data types, functions, operators, and indexes for PostgreSQL.

    pg_stat_kcache

    2.2.1

    2.2.1

    2.2.1

    2.2.1

    2.2.1

    2.2.1

    This extension is used to collect statistics on read and write operations in file systems.

    pg_stat_statements

    1.10

    1.9

    1.8

    1.7

    1.6

    1.6

    This extension is used to track the statistics of all SQL statements that are executed on a specific server.

    pg_trgm

    1.6

    1.6

    1.5

    1.4

    1.4

    1.3

    This extension provides functions and operators that are used to compute the similarity between alphanumeric texts. This extension also provides index operator classes that are used to search for similar strings in an efficient manner.

    pgaudit

    1.6.1

    1.6.1

    1.5

    1.4.1

    1.3.2

    1.2.2

    This extension is used to generate audit logs that contain the details about sessions and objects.

    pgcrypto

    1.3

    1.3

    1.3

    1.3

    1.3

    1.3

    This extension provides cryptographic functions for PostgreSQL.

    pgl_ddl_deploy

    2.1

    2.1

    2.1

    Not supported

    Not supported

    Not supported

    This extension supports transparent DDL replication.

    pglogical

    2.4.2

    2.4.2

    2.4.2

    2.4.2

    2.4.0

    2.4.0

    This extension provides the logical streaming replication feature by using a publish/subscribe pattern.

    pgrouting

    3.4.2

    3.4.2

    3.4.2

    3.4.2

    3.4.2

    3.4.2

    This extension is used to compute and analyze spatial network geometries.

    pgrowlocks

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    This extension provides a function that is used to display the row lock information about a specific table.

    pgstattuple

    1.5

    1.5

    1.5

    1.5

    1.5

    1.5

    This extension provides various functions that are used to obtain tuple-level statistics.

    pgvector

    0.4.1

    0.4.1

    Not supported

    Not supported

    Not supported

    Not supported

    This extension is used for high-dimensional vector similarity search.

    pldebugger

    Not supported

    Not supported

    1.1

    1.1

    1.1

    1.1

    This extension is used to debug the stored procedures of an ApsaraDB RDS for PostgreSQL instance.

    plperl

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension is used to support the Perl procedural language.

    plpgsql

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension is used to support the SQL procedural language.

    plproxy

    2.10.0

    2.10.0

    2.10.0

    2.9.0

    2.9.0

    2.8.0

    This extension provides the CLUSTER and CONNECT modes in which an ApsaraDB RDS for PostgreSQL instance can be accessed.

    pltcl

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension is used to support the TCL procedural language.

    plv8

    Not supported

    2.3.15

    2.3.15

    2.3.15

    2.3.15

    2.3.15

    This extension is a trusted JavaScript language extension.

    postgis

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    This extension is used to process and store the information about spatial geographical locations in PostGIS.

    postgis_sfcgal

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    This extension is an extension that is used to manage spatial geographic information in PostGIS.

    postgis_tiger_geocoder

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    This extension is used to manage PostGIS data in the TIGER format.

    postgis_topology

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    3.3.2

    This extension is used to manage topological objects in PostGIS.

    postgres_fdw

    1.1

    1.1

    1.0

    1.0

    1.0

    1.0

    This extension is used to manage tables across databases.

    q3c

    Not supported

    Not supported

    Not supported

    Not supported

    Not supported

    1.5.0

    This extension is used to create spatial indexes on a sphere.

    rdkit

    Not supported

    Not supported

    Not supported

    3.8

    Not supported

    Not supported

    This extension is used to support features such as molecular computing and search.

    rds_ccl

    1.0

    1.0

    Not supported

    Not supported

    Not supported

    Not supported

    This extension is used for SQL throttling.

    rds_tde_utils

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension is used to encrypt and decrypt tables and indexes at a time by using TDE.

    roaringbitmap

    0.5

    0.5

    0.5

    0.5

    Not supported

    Not supported

    This extension is used to compute bitmaps to increase query performance.

    rum

    1.3

    1.3

    1.3

    1.3

    1.3

    1.3

    This extension is used to efficiently run full-text searches.

    sequential-uuids

    1.0.2

    1.0.2

    1.0.2

    1.0.2

    1.0.2

    1.0.2

    This extension is used to generate sequential UUIDs.

    smlar

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension is used to compute the similarity between two arrays of the same data type.

    sslinfo

    1.2

    1.2

    1.2

    1.2

    1.2

    1.2

    This extension is used to obtain information about the SSL certificate that is provided by the connected client.

    tablefunc

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension provides functions that are used to return tables.

    tds_fdw

    2.0.3

    2.0.3

    2.0.3

    2.0.1

    2.0.1

    Not supported

    This extension is used to query data from an ApsaraDB RDS instance that does not run PostgreSQL.

    timescaledb

    2.9.2

    2.9.2

    2.5.0

    1.7.1

    1.7.1

    1.3.0

    This extension is used to support features such as automatic sharding, efficient writes, retrieval, and near real-time aggregation of time series data.

    tsm_system_rows

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension provides the table sampling method SYSTEM_ROWS.

    tsm_system_time

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension provides the table sampling method SYSTEM_TIME.

    unaccent

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension provides a text search dictionary that is used to remove accent marks or diacritic signs from lexemes.

    uuid-ossp

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension provides functions that use a standard algorithm to generate UUIDs.

    varbitx

    Not supported

    Not supported

    Not supported

    Not supported

    1.0

    1.0

    This extension is used to support various BIT-type operations.

    wal2json

    2.3

    2.3

    2.3

    2.3

    2.2

    2.2

    This extension is used to export logical log records as a file in the JSON format.

    xml2

    1.1

    1.1

    1.1

    1.1

    1.1

    1.1

    This extension provides XPath query and XSLT functionality.

    zhparser

    1.0

    1.0

    1.0

    1.0

    1.0

    1.0

    This extension is used to support full-text searches in Chinese.

    zombodb

    Not supported

    Not supported

    Not supported

    Not supported

    4.0

    Not supported

    This extension provides text indexing and analytics features.

    ARM

    Extension

    15

    14

    13

    Description

    address_standardizer

    3.3.2

    3.1.4

    3.1.4

    This extension is used to standardize the names of geographical locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer.

    address_standardizer_data_us

    3.3.2

    3.1.4

    3.1.4

    This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer.

    aggs_for_arrays

    Not supported

    Not supported

    Not supported

    This extension provides an extension function that is used to compute the statistics of numeric arrays.

    bloom

    1.0

    1.0

    1.0

    This extension provides an index access method that is based on Bloom filters.

    btree_gin

    1.3

    1.3

    1.3

    This extension provides sample GIN operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

    btree_gist

    1.7

    1.6

    1.5

    This extension provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types or all enumerated data types.

    chkpass

    Not supported

    Not supported

    Not supported

    This extension provides a data type that is used to store encrypted passwords.

    citext

    1.6

    1.6

    1.6

    This extension provides a string type that is not case-sensitive.

    cube

    1.5

    1.5

    1.4

    This extension provides a data type that is used to represent multidimensional cubes.

    dblink

    1.2

    1.2

    1.2

    This extension is used to manage tables across databases.

    decoderbufs

    Not supported

    Not supported

    0.1.0

    This extension is used to generate data that is compatible with the Debezium platform based on the Protocol Buffers protocol.

    dict_int

    1.0

    1.0

    1.0

    This extension provides a sample add-on dictionary template that is used to run full-text searches.

    earthdistance

    1.1

    1.1

    1.1

    This extension provides two different methods that are used to compute great-circle distances on the surface of the Earth.

    encdb

    Not supported

    Not supported

    Not supported

    This extension is used to support fully encrypted databases.

    fuzzystrmatch

    1.1

    1.1

    1.1

    This extension is used to compute the similarity and distance between strings.

    ganos_address_standardizer

    5.6

    5.6

    5.6

    This extension is used to standardize the names of geographical locations based on PAGC. For more information, see Tuning the Standardizer.

    ganos_address_standardizer_data_us

    5.6

    5.6

    5.6

    This extension is used to standardize the names of the geographical locations in the United States based on PAGC. For more information, see Tuning the Standardizer.

    ganos_geometry

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial geometries.

    ganos_geometry_pyramid

    5.6

    5.6

    5.6

    This extension is used to display 2D geometric big data at high speeds.

    ganos_geometry_sfcgal

    5.6

    5.6

    5.6

    This extension is an extension of the SFCGAL extension and is used to process spatial geometries.

    ganos_geometry_topology

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial geometries.

    ganos_networking

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial network geometries.

    ganos_pointcloud

    5.6

    5.6

    5.6

    This extension is used to store, compute, and analyze point clouds.

    ganos_pointcloud_geometry

    5.6

    5.6

    5.6

    This extension is used to store, compute, and analyze point clouds.

    ganos_raster

    5.6

    5.6

    5.6

    This extension is used to store, compute, and analyze spatial rasters.

    ganos_spatialref

    5.6

    5.6

    5.6

    This extension is used to compute and analyze spatial references.

    ganos_tiger_geocoder

    5.6

    5.6

    5.6

    This extension is used to support the TIGER data format that is used by the USCB.

    ganos_trajectory

    5.6

    5.6

    5.6

    This extension is used to compute and analyze objects in the MOD system of Ganos.

    hll

    2.16

    2.16

    2.15

    This extension is used to estimate business metrics, such as PVs and UVs, in an efficient manner.

    hstore

    1.8

    1.8

    1.7

    This extension is used to store key-value pairs within a single PostgreSQL value.

    hypopg

    1.3.1

    1.3.1

    1.3.1

    This extension is used to create virtual indexes.

    index_adviser

    2.0

    2.0

    2.0

    This extension provides index recommendations.

    intagg

    1.1

    1.1

    1.1

    This extension provides an integer aggregator and an enumerator.

    intarray

    1.5

    1.5

    1.3

    This extension provides functions and operators that are used to manage null-free arrays of integers.

    ip4r

    2.4

    2.4

    2.4

    This extension is used to store IPv4 and IPv6 addresses in PostgreSQL.

    isn

    1.2

    1.2

    1.2

    This extension is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes.

    ltree

    1.2

    1.2

    1.2

    This extension is used to label the data that is stored in a hierarchical tree structure.

    log_fdw

    Not supported

    Not supported

    Not supported

    This extension is used to query logs.

    mysql_fdw

    1.1

    1.1

    1.1

    This extension is used to read and write data to an ApsaraDB RDS for MySQL instance or a self-managed MySQL database.

    oracle_fdw

    Not supported

    Not supported

    Not supported

    This extension is used to synchronize the update operations on the tables of an ApsaraDB RDS for PostgreSQL instance to the tables of an Oracle database.

    orafce

    3.17

    3.17

    Not supported

    This extension provides functions that are compatible with Oracle.

    oss_fdw

    1.1

    1.1

    1.1

    This extension is used to read data from and write data to an OSS bucket.

    pase

    0.0.1

    0.0.1

    0.0.1

    This extension is used to search for vectors in an efficient manner.

    pg_bigm

    1.2

    1.2

    1.2

    This extension is used to create a 2-gram Generalized Inverted Index (GIN) that is used to accelerate full-text searches.

    pg_buffercache

    1.3

    1.3

    1.3

    This extension is used to examine shared buffers in real time.

    pg_concurrency_control

    Not supported

    Not supported

    Not supported

    This extension is used to control the concurrency of SQL statements.

    pg_cron

    1.5

    1.5

    1.5

    This extension is used to configure scheduled tasks.

    pg_freespacemap

    1.2

    1.2

    1.2

    This extension is used to examine the free space map (FSM).

    pg_jieba

    1.2.0

    1.2.0

    1.1.0

    This extension is used to segment Chinese text.

    pg_hint_plan

    1.5.0

    1.4.0

    1.3.7

    This extension is used to add hints to SQL statements. The hints are used to change the execution plans of SQL statements.

    pg_partman

    4.7.3

    4.7.3

    4.7.3

    This extension is used to create and manage time-based and sequence-based table partition sets.

    pg_pathman

    Not supported

    Not supported

    1.5

    This extension is used to partition tables at high performance.

    pg_prewarm

    1.2

    1.2

    1.2

    This extension is used to load data to the buffer of the operating system or PostgreSQL database engine.

    pg_profile

    4.1

    4.1

    4.1

    This extension is used to collect statistics on resource-intensive activities.

    pg_repack

    1.4.8

    1.4.7

    1.4.6

    This extension is used to clear tablespaces that stay online.

    pg_sphere

    Not supported

    Not supported

    Not supported

    This extension provides spherical data types, functions, operators, and indexes for PostgreSQL.

    pg_stat_kcache

    2.2.1

    2.2.1

    2.2.1

    This extension is used to collect statistics on read and write operations in file systems.

    pg_stat_statements

    1.10

    1.9

    1.8

    This extension is used to track the statistics of all SQL statements that are executed on a specific server.

    pg_trgm

    1.6

    1.6

    1.5

    This extension provides functions and operators that are used to compute the similarity between alphanumeric texts. This extension also provides index operator classes that are used to search for similar strings in an efficient manner.

    pgaudit

    1.6.1

    1.6.1

    1.5

    This extension is used to generate audit logs that contain the details about sessions and objects.

    pgcrypto

    1.3

    1.3

    1.3

    This extension provides cryptographic functions for PostgreSQL.

    pgl_ddl_deploy

    2.1

    2.1

    2.1

    This extension supports transparent DDL replication.

    pglogical

    2.4.2

    2.4.2

    2.4.2

    This extension provides the logical streaming replication feature by using a publish/subscribe pattern.

    pgrouting

    3.4.2

    3.4.2

    3.4.2

    This extension is used to compute and analyze spatial network geometries.

    pgrowlocks

    1.2

    1.2

    1.2

    This extension provides a function that is used to display the row lock information about a specific table.

    pgstattuple

    1.5

    1.5

    1.5

    This extension provides various functions that are used to obtain tuple-level statistics.

    pgvector

    0.4.1

    0.4.1

    Not supported

    This extension is used for high-dimensional vector similarity search.

    pldebugger

    Not supported

    Not supported

    1.1

    This extension is used to debug the stored procedures of an ApsaraDB RDS for PostgreSQL instance.

    plperl

    1.0

    1.0

    1.0

    This extension is used to support the Perl procedural language.

    plpgsql

    1.0

    1.0

    1.0

    This extension is used to support the SQL procedural language.

    plproxy

    2.10.0

    2.10.0

    2.10.0

    This extension provides the CLUSTER and CONNECT modes in which an ApsaraDB RDS for PostgreSQL instance can be accessed.

    pltcl

    1.0

    1.0

    1.0

    This extension is used to support the TCL procedural language.

    postgis

    3.3.2

    3.3.2

    3.3.2

    This extension is used to process and store the information about spatial geographical locations in PostGIS.

    postgis_sfcgal

    3.3.2

    3.3.2

    3.3.2

    This extension is an extension that is used to manage spatial geographic information in PostGIS.

    postgis_tiger_geocoder

    3.3.2

    3.3.2

    3.3.2

    This extension is used to manage PostGIS data in the TIGER format.

    postgis_topology

    3.3.2

    3.3.2

    3.3.2

    This extension is used to manage topological objects in PostGIS.

    postgres_fdw

    1.1

    1.1

    1.0

    This extension is used to manage tables across databases.

    q3c

    Not supported

    Not supported

    Not supported

    This extension is used to create spatial indexes on a sphere.

    rds_ccl

    1.0

    1.0

    Not supported

    This extension is used for SQL throttling.

    rds_tde_utils

    1.0

    1.0

    1.0

    This extension is used to encrypt and decrypt tables and indexes at a time by using TDE.

    roaringbitmap

    0.5

    0.5

    0.5

    This extension is used to compute bitmaps to increase query performance.

    rum

    1.3

    1.3

    1.3

    This extension is used to efficiently run full-text searches.

    sequential-uuids

    1.0.2

    1.0.2

    1.0.2

    This extension is used to generate sequential UUIDs.

    smlar

    1.0

    1.0

    1.0

    This extension is used to compute the similarity between two arrays of the same data type.

    sslinfo

    1.2

    1.2

    1.2

    This extension is used to obtain information about the SSL certificate that is provided by the connected client.

    tablefunc

    1.0

    1.0

    1.0

    This extension provides functions that are used to return tables.

    tds_fdw

    2.0.3

    2.0.3

    2.0.3

    This extension is used to query data from an ApsaraDB RDS instance that does not run PostgreSQL.

    timescaledb

    2.9.2

    2.9.2

    2.5.0

    This extension is used to support features such as automatic sharding, efficient writes, retrieval, and near real-time aggregation of time series data.

    tsm_system_rows

    1.0

    1.0

    1.0

    This extension provides the table sampling method SYSTEM_ROWS.

    tsm_system_time

    1.0

    1.0

    1.0

    This extension provides the table sampling method SYSTEM_TIME.

    unaccent

    1.1

    1.1

    1.1

    This extension provides a text search dictionary that is used to remove accent marks or diacritic signs from lexemes.

    uuid-ossp

    1.1

    1.1

    1.1

    This extension provides functions that use a standard algorithm to generate UUIDs.

    varbitx

    Not supported

    Not supported

    Not supported

    This extension is used to support various BIT-type operations.

    wal2json

    2.3

    2.3

    2.3

    This extension is used to export logical log records as a file in the JSON format.

    xml2

    1.1

    1.1

    1.1

    This extension provides XPath query and XSLT functionality.

    zhparser

    1.0

    1.0

    1.0

    This extension is used to support full-text searches in Chinese.

    zombodb

    Not supported

    Not supported

    Not supported

    This extension provides text indexing and analytics features.