ApsaraDB RDS:Supported extensions

Extension

17

16

15

14

13

12

11

10

Description

address_standardizer

Not supported

3.3.4

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

Not supported

3.3.4

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

Not supported

Not supported

1.3.1

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

age

Not supported

1.5.0

1.5.0

1.5.0

Not supported

Not supported

Not supported

Not supported

This extension enables users to leverage a graph database on top of existing PostgreSQL databases.

bloom

1.0

1.0

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.3

1.3

1.2

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.7

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 and all enumerated data types.

chkpass

Not supported

Not supported

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.6

1.6

1.5

1.4

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

cube

1.5

1.5

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

1.2

1.2

This extension is used to manage tables across databases.

decoderbufs

Not supported

Not supported

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

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

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.14

1.1.14

1.1.14

1.1.14

1.1.14

1.1.14

1.1.14

1.1.13

This extension is used to provide the always-confidential database feature.

encdb_btree

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

This extension is used to accelerate ciphertext queries on always-confidential databases.

fuzzystrmatch

1.2

1.2

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

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

This extension is used to compute and analyze spatial geometries.

ganos_geometry_pyramid

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

ganos_geometry_sfcgal

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

ganos_geometry_topology

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

This extension is used to compute and analyze spatial geometries.

ganos_geomgrid

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

This extension is used for the meshing, coding, indexing, and analysis of grids such as H3 and GeoSOT grids.

ganos_networking

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

ganos_pointcloud

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

ganos_pointcloud_geometry

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

ganos_raster

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

ganos_spatialref

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

This extension is used to compute and analyze spatial references.

ganos_tiger_geocoder

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

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

ganos_trajectory

Not supported

6.3

6.3

6.3

6.3

6.3

6.3

6.3

This extension is used to compute and analyze objects in the moving object detection (MOD) system of GanosBase.

hll

Not supported

2.18

2.18

2.18

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.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

Not supported

1.4.1

1.4.1

1.4.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

2.0

2.0

This extension provides index recommendations.

intagg

1.1

1.1

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.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

Not supported

2.4

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.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.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

Not supported

Not supported

1.0

Not supported

This extension is used to query the logs.

madlib

Not supported

Not supported

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

Not supported

1.2

1.2

1.2

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

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

Not supported

4.9.2

4.9.2

4.9.2

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

1.1

1.1

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

pase

Not supported

0.0.1

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

Not supported

1.2

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.4

1.4

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

Not supported

Not supported

1.0

1.0

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

pg_cron

Not supported

1.6

1.6

1.6

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

1.2

1.2

This extension is used to examine the FSM.

pg_jieba

Not supported

1.2.0

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

Not supported

1.6.0

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

Not supported

5.1.0

5.1.0

5.1.0

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

Not supported

Not supported

1.5

1.5

1.5

1.5

This extension is used to partition tables at high performance.

pg_prewarm

Not supported

1.2

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

Not supported

4.4

4.4

4.4

4.1

4.1

4.1

4.1

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

pg_proctab

Not supported

0.0.10

0.0.10

0.0.10

0.0.10

0.0.10

0.0.10

Not supported

This extension allows you to access the processes and resource consumption data in an operating system by using SQL statements.

pg_repack

Not supported

1.5.0

1.5.0

1.5.0

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

Not supported

Not supported

1.0

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

pg_stat_kcache

Not supported

2.2.3

2.2.3

2.2.3

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.10

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 specified server.

pg_trgm

1.6

1.6

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.

pg_squeeze

Not supported

1.6

1.6

1.6

1.6

1.6

1.6

Not supported

This extension is used to shrink bloated tables and indexes online.

pgaudit

Not supported

16.0

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

1.3

1.3

This extension provides cryptographic functions for PostgreSQL.

pgl_ddl_deploy

Not supported

2.2

2.2

2.2

2.1

Not supported

Not supported

Not supported

This extension supports transparent DDL replication.

pglogical

Not supported

2.4.4

2.4.4

2.4.4

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

Not supported

3.4.2

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

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

1.5

1.5

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

pgvector

Not supported

0.7.4

0.7.4

0.7.4

Not supported

Not supported

Not supported

Not supported

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

pldebugger

Not supported

Not supported

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

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

1.0

1.0

This extension is used to support the SQL procedural language.

plproxy

Not supported

2.11.0

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

1.0

1.0

This extension is used to support the TCL procedural language.

plv8

Not supported

Not supported

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

Not supported

3.3.4

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

Not supported

3.3.4

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

Not supported

3.3.4

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

Not supported

3.3.4

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.1

1.1

1.0

1.0

1.0

1.0

This extension is used to manage tables across databases.

postgresql_anonymizer

Not supported

Not supported

1.1.0

1.1.0

Not supported

Not supported

Not supported

Not supported

This extension is used for data anonymization and data masking.

q3c

Not supported

Not supported

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

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.1

1.1

1.0

1.0

Not supported

Not supported

Not supported

Not supported

This extension is used for SQL throttling.

rds_duckdb

Not supported

1.0

Not supported

Not supported

Not supported

Not supported

Not supported

Not supported

This extension is used to accelerate complex queries.

rds_embedding

Not supported

1.0

1.0

1.0

Not supported

Not supported

Not supported

Not supported

This extension provides custom model configuration and model invocation capabilities to convert text to vectors in a database.

rds_tde_utils

1.0

1.0

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

Not supported

0.5.4

0.5

0.5

0.5

0.5

Not supported

Not supported

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

rum

Not supported

1.3

1.3

1.3

1.3

1.3

1.3

1.3

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

sequential-uuids

Not supported

1.0.2

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

Not supported

1.0

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

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

1.0

1.0

This extension provides functions that are used to return tables.

tds_fdw

Not supported

2.0.3

2.0.3

2.0.3

2.0.3

2.0.3

2.0.3

Not supported

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

timescaledb

Not supported

2.14.2

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

Not supported

1.0

1.0

1.0

1.0

1.0

1.0

1.0

This extension provides the table sampling method SYSTEM_ROWS.

tsm_system_time

Not supported

1.0

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

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

1.1

1.1

This extension provides functions that use a standard algorithm to generate universally unique identifiers (UUIDs).

varbitx

Not supported

Not supported

Not supported

Not supported

Not supported

Not supported

1.0

1.0

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

wal2json

Not supported

2.6

2.6

2.6

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

Not supported

1.1

1.1

1.1

1.1

1.1

1.1

1.1

This extension provides XPath query and XSLT functionality.

zhparser

Not supported

1.0

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

Not supported

Not supported

4.0

Not supported

This extension provides text indexing and analytics features.

Extension

17

16

15

14

13

Description

address_standardizer

Not supported

3.3.4

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

Not supported

3.3.4

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.

age

Not supported

1.5.0

1.5.0

1.5.0

Not supported

This extension enables users to leverage a graph database on top of existing PostgreSQL databases.

bloom

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

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.7

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 and all enumerated data types.

citext

1.6

1.6

1.6

1.6

1.6

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

cube

1.5

1.5

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

1.2

1.2

This extension is used to manage tables across databases.

decoderbufs

Not supported

Not supported

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

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

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

fuzzystrmatch

1.2

1.2

1.1

1.1

1.1

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

ganos_address_standardizer

Not supported

6.3

6.3

6.3

6.3

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

Not supported

6.3

6.3

6.3

6.3

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

Not supported

6.3

6.3

6.3

6.3

This extension is used to compute and analyze spatial geometries.

ganos_geometry_pyramid

Not supported

6.3

6.3

6.3

6.3

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

ganos_geometry_sfcgal

Not supported

6.3

6.3

6.3

6.3

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

ganos_geometry_topology

Not supported

6.3

6.3

6.3

6.3

This extension is used to compute and analyze spatial geometries.

ganos_geomgrid

Not supported

6.3

6.3

6.3

6.3

This extension is used for the meshing, coding, indexing, and analysis of grids such as H3 and GeoSOT grids.

ganos_networking

Not supported

6.3

6.3

6.3

6.3

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

ganos_pointcloud

Not supported

6.3

6.3

6.3

6.3

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

ganos_pointcloud_geometry

Not supported

6.3

6.3

6.3

6.3

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

ganos_raster

Not supported

6.3

6.3

6.3

6.3

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

ganos_spatialref

Not supported

6.3

6.3

6.3

6.3

This extension is used to compute and analyze spatial references.

ganos_tiger_geocoder

Not supported

6.3

6.3

6.3

6.3

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

ganos_trajectory

Not supported

6.3

6.3

6.3

6.3

This extension is used to compute and analyze objects in the moving object detection (MOD) system of GanosBase.

hll

Not supported

2.18

2.18

2.18

2.15

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.8

1.8

1.7

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

hypopg

Not supported

1.4.1

1.4.1

1.4.1

1.3.1

This extension is used to create virtual indexes.

index_adviser

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

This extension provides an integer aggregator and an enumerator.

intarray

1.5

1.5

1.5

1.5

1.3

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

ip4r

Not supported

2.4

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

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

1.2

1.2

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

mysql_fdw

Not supported

1.2

1.2

1.2

1.1

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

orafce

Not supported

4.9.2

4.9.2

4.9.2

Not supported

This extension provides functions that are compatible with Oracle.

oss_fdw

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

Not supported

0.0.1

0.0.1

0.0.1

0.0.1

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

pg_bigm

Not supported

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.4

1.4

1.3

1.3

1.3

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

pg_cron

Not supported

1.6

1.6

1.6

1.5

This extension is used to configure scheduled tasks.

pg_freespacemap

1.2

1.2

1.2

1.2

1.2

This extension is used to examine the FSM.

pg_jieba

Not supported

1.2.0

1.2.0

1.2.0

1.1.0

This extension is used to segment Chinese text.

pg_hint_plan

Not supported

1.6.0

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

Not supported

5.1.0

5.1.0

5.0.1

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

Not supported

Not supported

1.5

This extension is used to partition tables at high performance.

pg_prewarm

Not supported

1.2

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

Not supported

4.4

4.4

4.4

4.1

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

pg_proctab

Not supported

0.0.10

0.0.10

0.0.10

0.0.10

This extension allows you to access the processes and resource consumption data in an operating system by using SQL statements.

pg_repack

Not supported

1.5.0

1.5.0

1.5.0

1.4.6

This extension is used to clear tablespaces that stay online.

pg_stat_kcache

Not supported

2.2.3

2.2.3

2.2.3

2.2.1

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

pg_stat_statements

1.10

1.10

1.10

1.9

1.8

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

pg_trgm

1.6

1.6

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.

pg_squeeze

Not supported

1.6

1.6

1.6

1.6

This extension is used to shrink bloated tables and indexes online.

pgaudit

Not supported

16.0

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

1.3

1.3

This extension provides cryptographic functions for PostgreSQL.

pgl_ddl_deploy

Not supported

2.2

2.2

2.2

2.1

This extension supports transparent DDL replication.

pglogical

Not supported

2.4.4

2.4.4

2.4.4

2.4.2

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

pgrouting

Not supported

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

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

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

pgvector

Not supported

0.7.4

0.7.4

0.7.4

Not supported

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

pldebugger

Not supported

Not supported

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

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

This extension is used to support the SQL procedural language.

plproxy

Not supported

2.11.0

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

1.0

1.0

This extension is used to support the TCL procedural language.

postgis

Not supported

3.3.4

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

Not supported

3.3.4

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

Not supported

3.3.4

3.3.2

3.3.2

3.3.2

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

postgis_topology

Not supported

3.3.4

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.1

1.1

1.0

This extension is used to manage tables across databases.

postgresql_anonymizer

Not supported

Not supported

1.1.0

1.1.0

Not supported

This extension is used for data anonymization and data masking.

rds_ccl

1.1

1.1

1.0

1.0

Not supported

This extension is used for SQL throttling.

rds_duckdb

Not supported

1.0

Not supported

Not supported

Not supported

This extension is used to accelerate complex queries.

rds_embedding

Not supported

1.0

1.0

1.0

Not supported

This extension provides custom model configuration and model invocation capabilities to convert text to vectors in a database.

rds_tde_utils

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

Not supported

0.5.4

0.5

0.5

0.5

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

rum

Not supported

1.3

1.3

1.3

1.3

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

sequential-uuids

Not supported

1.0.2

1.0.2

1.0.2

1.0.2

This extension is used to generate sequential UUIDs.

smlar

Not supported

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

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

This extension provides functions that are used to return tables.

tds_fdw

Not supported

2.0.3

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

Not supported

2.14.2

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

Not supported

1.0

1.0

1.0

1.0

This extension provides the table sampling method SYSTEM_ROWS.

tsm_system_time

Not supported

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

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

This extension provides functions that use a standard algorithm to generate universally unique identifiers (UUIDs).

wal2json

Not supported

2.6

2.6

2.6

2.3

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

xml2

Not supported

1.1

1.1

1.1

1.1

This extension provides XPath query and XSLT functionality.

zhparser

Not supported

1.0

1.0

1.0

1.0

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