ApsaraDB RDS:Supported extensions

Extension name

18

17

16

15

14

13

12

11

10

Description

rds_online_migrate

None

1.0

1.0

1.0

1.0

1.0

None

None

None

Provides an online partitioning feature.

pgroonga

None

4.0.4

None

None

None

None

None

None

None

Provides a full-text search feature for PostgreSQL.

clickhouse_fdw

None

1.4

1.4

1.4

1.4

1.4

Not supported

None

None

Lets you query data in a ClickHouse database directly from PostgreSQL, as if it were a local table.

pg_permissions

None

1.4

None

Not supported

None

None

None

None

None

Lets you view and audit the permission settings for all objects, such as tables, views, and functions, in a PostgreSQL database. This facilitates permission management and security audits.

address_standardizer

None

3.3.7

3.3.4

3.3.2

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

A placename standardization extension based on the PAGC standard.

address_standardizer_data_us

None

3.3.7

3.3.4

3.3.2

3.1.4

3.1.4

3.1.4

3.1.4

3.1.4

A placename standardization (United States) data extension based on the PAGC standard.

aggs_for_arrays

None

None

None

None

None

None

None

None

1.3.1

Provides extension functions to calculate statistics for numeric arrays.

age

None

1.6.0

1.6.0

1.5.0

1.5.0

None

None

None

None

Provides graph database features for PostgreSQL.

bloom

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Provides an index access method based on Bloom filters.

btree_gin

1.3

1.3

1.3

1.3

1.3

1.3

1.3

1.3

1.2

Provides a sample GIN operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

btree_gist

1.8

1.7

1.7

1.7

1.6

1.5

1.5

1.5

1.5

Provides a sample GiST operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

chkpass

None

None

None

None

None

None

None

None

1.0

Implements a data type for storing encrypted security tokens.

citext

1.8

1.6

1.6

1.6

1.6

1.6

1.6

1.5

1.4

Provides a case-insensitive string type.

cube

1.5

1.5

1.5

1.5

1.5

1.4

1.4

1.4

1.2

Provides a data type to represent multidimensional cubes.

dblink

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

Operates on tables across databases.

decoderbufs

None

None

None

None

None

0.1.0

0.1.0

0.1.0

0.1.0

Outputs data 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

1.0

An example of an add-on full-text search dictionary template.

earthdistance

1.2

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

Provides two different methods to calculate great-circle distances on the surface of the Earth.

encdb

None

1.1.14

1.1.14

1.1.14

1.1.14

1.1.14

1.1.14

1.1.14

1.1.13

Provides confidential database features.

encdb_btree

None

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

1.0.0

Accelerates ciphertext queries on confidential databases.

fuzzystrmatch

1.2

1.2

1.2

1.1

1.1

1.1

1.1

1.1

1.1

Determines the similarity and distance between strings.

ganos_address_standardizer

Not supported

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

A placename standardization extension based on the PAGC standard.

ganos_address_standardizer_data_us

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

A placename standardization (United States) data extension based on the PAGC standard.

ganos_geometry

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides computing and analysis features for spatial geometry types.

ganos_geometry_pyramid

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Used for fast display of 2D spatial geometry big data.

ganos_geometry_sfcgal

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides extension features for the spatial geometry SFCGAL plugin.

ganos_geometry_topology

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides computing and analysis features for spatial geometry types.

ganos_geomgrid

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems.

ganos_networking

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides computing and analysis features for spatial geometry network types.

ganos_pointcloud

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides storage, computing, and analysis features for point clouds.

ganos_pointcloud_geometry

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides storage, computing, and analysis features for point clouds.

ganos_raster

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides storage, computing, and analysis features for spatial raster data.

ganos_spatialref

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides computing and analysis features for spatial references.

ganos_tiger_geocoder

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

Provides support for the USCB TIGER data type.

ganos_trajectory

None

7.0

6.9

6.9

6.9

6.9

6.9

6.3

6.3

GanosBase moving object (MOD) data computing and analysis features.

hll

2.18

2.19

2.18

2.18

2.18

2.15

2.14

2.14

None

Quickly estimates business metrics such as page views (PVs) and unique visitors (UVs).

hstore

1.8

1.8

1.8

1.8

1.8

1.7

1.6

1.5

1.4

Stores key-value pairs in a single PostgreSQL instance.

hypopg

1.4.2

1.4.1

1.4.1

1.4.1

1.4.1

1.3.1

1.3.1

1.3.1

1.3.1

Creates hypothetical indexes.

index_adviser

None

2.0

2.0

2.0

2.0

2.0

2.0

2.0

2.0

Provides index recommendations.

intagg

None

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

Provides an integer aggregator and an enumerator.

intarray

1.5

1.5

1.5

1.5

1.5

1.3

1.2

1.2

1.2

Provides useful functions and operators for manipulating integer arrays that do not contain null values.

ip4r

2.4

2.4

2.4

2.4

2.4

2.4

None

None

None

Enables PostgreSQL to support IP address range types.

isn

1.3

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.1

Validates input against a hard-coded prefix list and is also used to concatenate numbers on output.

ltree

1.3

1.2

1.2

1.2

1.2

1.2

1.1

1.1

1.1

Used for labels of data stored in a hierarchical tree-like structure.

log_fdw

Not supported

None

None

None

None

None

None

1.0

None

Queries database logs.

mysql_fdw

None

2.9.2

1.2

1.2

1.2

1.1

1.1

1.1

1.1

Reads and writes data in ApsaraDB RDS for MySQL instances or self-managed MySQL databases.

oracle_fdw

Not supported

None

None

None

None

None

1.1

Not supported

None

Supports synchronous updates to tables in an Oracle database from a PostgreSQL table.

orafce

4.15

None

4.9.2

4.9.2

4.9.2

None

None

3.8

3.6

Provides a series of Oracle-compatible functions.

oss_fdw

Not supported

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

Reads and writes data in OSS.

pase

None

None

0.0.1

0.0.1

0.0.1

0.0.1

0.0.1

0.0.1

None

Efficient vector retrieval.

pg_bigm

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

Creates a 2-gram GIN index to accelerate the full-text search process.

pg_buffercache

1.6

1.4

1.4

1.3

1.3

1.3

1.3

1.3

1.3

Provides a way to inspect the shared buffer in real time.

pg_concurrency_control

Not supported

None

None

None

None

None

None

1.0

1.0

Used for concurrency control of SQL statements.

pg_cron

1.6

1.6

1.6

1.6

1.6

1.5

1.1

1.1

1.1

Sets scheduled tasks.

pg_freespacemap

1.3

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

Examines the free space map (FSM).

pg_jieba

1.2.0

1.2.0

1.2.0

1.2.0

1.2.0

1.1.0

1.1.0

1.1.0

1.1.0

Performs tokenization for Chinese full-text search.

pg_hint_plan

1.8.0

1.7.0

1.6.1

1.5.2

1.4.3

1.3.9

1.3.9

1.3.9

1.3.0

Allows PostgreSQL to change its predetermined execution plan through hints in special comment statements.

pg_partman

5.2.4

5.2.4

5.1.0

5.1.0

5.1.0

4.7.3

4.7.3

None

None

Creates and manages time-based and sequence-based table partition sets.

pg_pathman

None

Not supported

None

None

None

1.5

1.5

1.5

1.5

A high-performance partitioned table extension.

pg_prewarm

1.2

None

1.2

1.2

1.2

1.2

1.2

1.2

1.1

Provides a convenient way to load data into the operating system buffer or the PostgreSQL buffer.

pg_profile

None

None

4.4

4.4

4.4

4.1

4.1

4.1

4.1

Statistics on resource-intensive activities.

pg_proctab

None

0.0.10

0.0.10

0.0.10

0.0.10

0.0.10

0.0.10

0.0.10

None

Lets users access operating system-level process and system resource consumption data through SQL queries.

pg_repack

Not supported

1.5.1

1.5.0

1.5.0

1.5.0

1.4.6

1.4.6

1.4.6

1.4.6

Online tablespace cleanup feature.

pg_sphere

None

None

None

None

None

None

None

None

1.0

Provides spherical data types, functions, operators, and indexes for PostgreSQL.

pg_stat_kcache

Not applicable

2.3.0

2.2.3

2.2.3

2.2.3

2.2.1

2.2.1

2.2.1

2.2.1

System read and write information statistics.

pg_stat_statements

1.12

1.10

1.10

1.10

1.9

1.8

1.7

1.6

1.6

Provides a way to track execution statistics for all SQL statements executed by a server.

pg_trgm

1.6

1.6

1.6

1.6

1.6

1.5

1.4

1.4

1.3

Provides functions and operators for determining the similarity of alphanumeric text, and index operator classes that support fast searching for similar strings.

pg_squeeze

1.8

1.7

1.6

1.6

1.6

1.6

1.6

1.6

None

Shrinks bloated tables and indexes online.

pg_wait_sampling

1.1

1.1

None

Not supported

None

None

None

None

None

Used to monitor and analyze the wait states of a database.

pgaudit

None

17.0

16.0

1.6.1

1.6.1

1.5

1.4.1

1.3.2

1.2.2

Provides detailed session and object audit logging.

pgcrypto

1.4

1.3

1.3

1.3

1.3

1.3

1.3

1.3

1.3

Provides cryptographic functions for PostgreSQL.

pgl_ddl_deploy

None

None

2.2

2.2

2.2

2.1

None

None

None

Enables transparent logical DDL replication for PostgreSQL.

pglogical

2.4.6

2.4.5

2.4.5

2.4.4

2.4.4

2.4.2

2.4.2

2.4.0

2.4.0

Provides logical streaming replication for publishing and subscribing.

pgrouting

None

3.4.2

3.4.2

3.4.2

3.4.2

3.4.2

3.4.2

3.4.2

3.4.2

Provides computing and analysis features for spatial geometry networks.

pgrowlocks

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

Provides a function to display row lock information for a specified table.

pgsql-gzip

1.0

1.0.0

1.0.0

None

None

None

None

None

None

Implements Gzip compression and decompression of data in a PostgreSQL database.

pgsql-http

1.6

None

1.6

None

None

None

None

None

None

Lets users initiate HTTP requests directly within a PostgreSQL database.

pgstattuple

1.5

1.5

1.5

1.5

1.5

1.5

1.5

1.5

1.5

Provides various functions to obtain tuple-level statistics.

pgvector

0.8.1

0.8.0

0.8.0

0.8.0

0.8.0

Not supported

None

None

None

A high-dimensional vector similarity search extension.

pldebugger

None

1.8

1.8

1.8

1.8

1.1

1.1

1.1

1.1

A stored procedure debugging extension.

plperl

None

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Provides the Perl procedural language.

plpgsql

None

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Provides the SQL procedural language.

plproxy

2.11.0

None

2.11.0

2.10.0

2.10.0

2.10.0

2.9.0

2.9.0

2.8.0

Includes CLUSTER and CONNECT modes to help you access databases in different ways.

pltcl

None

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Provides the Tcl procedural language.

plv8

Not supported

None

None

None

2.3.15

2.3.15

2.3.15

2.3.15

2.3.15

A trusted JavaScript language extension.

postgis

None

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.2

PostGIS spatial and geographic information-related extensions.

postgis_sfcgal

None

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.2

PostGIS SFCGAL spatial and geographic information-related extensions.

postgis_tiger_geocoder

None

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.2

PostGIS TIGER data spatial and geographic information-related extensions.

postgis_topology

Not supported

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.4

3.3.2

PostGIS topology data spatial and geographic information-related extensions.

postgres_fdw

1.2

1.1

1.1

1.1

1.1

1.0

1.0

1.0

1.0

Operates on tables across databases.

postgresql_anonymizer

None

1.1.0

None

1.1.0

1.1.0

None

None

None

None

Anonymizes or masks sensitive data in a database.

q3c

Not supported

None

None

None

None

None

None

None

1.5.0

Used for spatial indexing on a sphere.

rdkit

None

None

None

None

None

None

3.8

None

None

Supports features such as cheminformatics and chemical molecule retrieval.

rds_ai

1.0

1.0.0

1.0.0

1.0.0

1.0.0

None

None

None

None

Integrates advanced models from Alibaba Cloud Model Studio, including Qwen and general-purpose text embeddings. This extension lets you easily implement various scenarios in your ApsaraDB RDS for PostgreSQL database, such as large model Q&A, text-to-embedding conversion, Top-N similar vector search, and retrieval-augmented generation (RAG) Q&A.

rds_ccl

1.3

1.2

1.2

1.2

1.2

None

None

None

None

Supports SQL throttling.

rds_duckdb

1.3.2.3

1.1

1.2

1.3

1.1

1.1

1.1

None

None

Accelerates complex queries.

rds_embedding

None

1.0

1.0

1.0

1.0

None

None

None

None

Provides capabilities for custom model configuration and model invocation. You can perform text-to-embedding conversion at the database level.

rds_encdb

None

None

1.0

None

None

None

None

None

None

Encrypts sensitive columns in query result sets. By configuring database account permissions, you can ensure that relevant accounts can only retrieve query results in ciphertext format when accessing sensitive column information.

rds_online_ddl

1.0

1.0

1.0

1.0

1.0

1.0

1.0

None

None

Supports online modification of column types, allowing you to complete schema evolution without affecting business continuity.

rds_tde_utils

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

A batch encryption and decryption extension for TDE.

roaringbitmap

0.5.4

0.5.4

0.5.4

0.5

0.5

0.5

0.5

None

None

Uses bitmap features to improve query performance.

rum

Not supported

1.3

1.3

1.3

1.3

1.3

1.3

1.3

1.3

High-speed full-text search.

sequential-uuids

1.0.3

None

1.0.2

1.0.2

1.0.2

1.0.2

1.0.2

1.0.2

1.0.2

A UUID generator with a sequential pattern.

smlar

None

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Calculates the similarity between two arrays of the same type.

snowflake

2.2

2.2

2.2

2.2

Not applicable.

None

None

None

None

Provides a unique ID solution based on int8 and sequences as an alternative to the built-in bigserial data type in PostgreSQL.

sslinfo

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

1.2

Provides information about the SSL certificate provided by the current client.

tablefunc

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Includes multiple functions that return tables.

tds_fdw

None

2.0.4

2.0.3

2.0.3

2.0.3

2.0.3

2.0.3

2.0.3

None

Queries data from other types of databases.

timescaledb

None

2.17.0

2.14.2

2.9.2

2.9.2

2.5.0

1.7.1

1.7.1

1.3.0

Supports automatic sharding, efficient writing, retrieval, and near real-time aggregation of time series data.

tsm_system_rows

1.0

None

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Provides the table sampling method SYSTEM_ROWS.

tsm_system_time

1.0

None

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Provides the table sampling method SYSTEM_TIME.

unaccent

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

A text search dictionary that removes accents (diacritical marks) from lexemes.

uuid-ossp

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

1.1

Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms.

varbitx

None

None

None

None

None

None

None

1.0

1.0

Supports multiple BIT operations.

wal2json

2.6

2.6

2.6

2.6

2.6

2.3

2.3

2.2

2.2

Outputs logical log files in JSON format.

xml2

1.2

None

1.1

1.1

1.1

1.1

1.1

1.1

1.1

Provides XPath querying and XSLT features.

zhparser

2.1

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

Chinese full-text search.

zombodb

None

None

None

None

None

None

None

4.0

None

Powerful text indexing and analysis features.

Extension name

18

17

16

15

14

13

Description

rds_online_migrate

None

1.0

1.0

1.0

1.0

1.0

Provides an online partitioning feature

pgroonga

None

4.0.4

None

None

None

None

Provides a full-text search feature for PostgreSQL.

clickhouse_fdw

Not supported

1.4

1.4

1.4

1.4

1.4

Lets you query data in a ClickHouse database directly from PostgreSQL, as if it were a local table.

pg_permissions

None

1.4

None

None

None

None

Lets you view and audit the permission settings for all objects, such as tables, views, and functions, in a PostgreSQL database. This facilitates permission management and security audits.

address_standardizer

None

3.3.7

3.3.4

3.3.2

3.1.4

3.1.4

A placename standardization extension based on the PAGC standard.

address_standardizer_data_us

Not supported

3.3.7

3.3.4

3.3.2

3.1.4

3.1.4

A placename standardization (United States) data extension based on the PAGC standard.

age

None

1.6.0

1.6.0

1.5.0

1.5.0

None

Provides graph database features for PostgreSQL.

bloom

1.0

1.0

1.0

1.0

1.0

1.0

Provides an index access method based on Bloom filters.

btree_gin

1.3

1.3

1.3

1.3

1.3

1.3

Provides a sample GIN operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

btree_gist

1.8

1.7

1.7

1.7

1.6

1.5

Provides a sample GiST operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

citext

1.8

1.6

1.6

1.6

1.6

1.6

Provides a case-insensitive string type.

cube

1.5

1.5

1.5

1.5

1.5

1.4

Provides a data type to represent multidimensional cubes.

dblink

1.2

1.2

1.2

1.2

1.2

1.2

Operates on tables across databases.

decoderbufs

None

None

None

None

None

0.1.0

Outputs data 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

An example of an add-on full-text search dictionary template.

earthdistance

1.2

1.1

1.1

1.1

1.1

1.1

Provides two different methods to calculate great-circle distances on the surface of the Earth.

fuzzystrmatch

1.2

1.2

1.2

1.1

1.1

1.1

Determines the similarity and distance between strings.

ganos_address_standardizer

None

7.0

6.9

6.9

6.9

6.9

A placename standardization extension based on the PAGC standard.

ganos_address_standardizer_data_us

None

7.0

6.9

6.9

6.9

6.9

A placename standardization (United States) data extension based on the PAGC standard.

ganos_geometry

None

7.0

6.9

6.9

6.9

6.9

Provides computing and analysis features for spatial geometry types.

ganos_geometry_pyramid

None

7.0

6.9

6.9

6.9

6.9

Used for fast display of 2D spatial geometry big data.

ganos_geometry_sfcgal

Not supported

7.0

6.9

6.9

6.9

6.9

Provides extension features for the spatial geometry SFCGAL plugin.

ganos_geometry_topology

None

7.0

6.9

6.9

6.9

6.9

Provides computing and analysis features for spatial geometry types.

ganos_geomgrid

None

7.0

6.9

6.9

6.9

6.9

Provides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems.

ganos_networking

Not supported

7.0

6.9

6.9

6.9

6.9

Provides computing and analysis features for spatial geometry network types.

ganos_pointcloud

None

7.0

6.9

6.9

6.9

6.9

Provides storage, computing, and analysis features for point clouds.

ganos_pointcloud_geometry

None

7.0

6.9

6.9

6.9

6.9

Provides storage, computing, and analysis features for point clouds.

ganos_raster

None

7.0

6.9

6.9

6.9

6.9

Provides storage, computing, and analysis features for spatial raster data.

ganos_spatialref

None

7.0

6.9

6.9

6.9

6.9

Provides computing and analysis features for spatial references.

ganos_tiger_geocoder

None

7.0

6.9

6.9

6.9

6.9

Provides support for the USCB TIGER data type.

ganos_trajectory

None

7.0

6.9

6.9

6.9

6.9

GanosBase moving object (MOD) data computing and analysis features.

hll

2.18

2.19

2.18

2.18

2.18

2.15

Quickly estimates business metrics such as page views (PVs) and unique visitors (UVs).

hstore

1.8

1.8

1.8

1.8

1.8

1.7

Stores key-value pairs in a single PostgreSQL instance.

hypopg

1.4.2

1.4.1

1.4.1

1.4.1

1.4.1

1.3.1

Creates hypothetical indexes.

index_adviser

Not supported

2.0

2.0

2.0

2.0

2.0

Provides index recommendations.

intagg

None

1.1

1.1

1.1

1.1

1.1

Provides an integer aggregator and an enumerator.

intarray

1.5

1.5

1.5

1.5

1.5

1.3

Provides useful functions and operators for manipulating integer arrays that do not contain null values.

ip4r

2.4

2.4

2.4

2.4

2.4

2.4

Enables PostgreSQL to support IP address range types.

isn

1.3

1.2

1.2

1.2

1.2

1.2

Validates input against a hard-coded prefix list and is also used to concatenate numbers on output.

ltree

1.3

1.2

1.2

1.2

1.2

1.2

Used for labels of data stored in a hierarchical tree-like structure.

mysql_fdw

None

2.9.2

1.2

1.2

1.2

1.1

Reads and writes data in ApsaraDB RDS for MySQL instances or self-managed MySQL databases.

orafce

4.15

None

4.9.2

4.9.2

4.9.2

None

Provides a series of Oracle-compatible functions.

oss_fdw

None

1.1

1.1

1.1

1.1

1.1

Reads and writes data in OSS.

pase

Not supported

None

0.0.1

0.0.1

0.0.1

0.0.1

Efficient vector retrieval.

pg_bigm

1.2

1.2

1.2

1.2

1.2

1.2

Creates a 2-gram GIN index to accelerate the full-text search process.

pg_buffercache

1.6

1.4

1.4

1.3

1.3

1.3

Provides a way to inspect the shared buffer in real time.

pg_cron

1.6

1.6

1.6

1.6

1.6

1.5

Sets scheduled tasks.

pg_freespacemap

1.3

1.2

1.2

1.2

1.2

1.2

Examines the free space map (FSM).

pg_jieba

1.2.0

1.2.0

1.2.0

1.2.0

1.2.0

1.1.0

Performs tokenization for Chinese full-text search.

pg_hint_plan

1.8.0

1.7.0

1.6.1

1.5.2

1.4.3

1.3.9

Allows PostgreSQL to change its predetermined execution plan through hints in special comment statements.

pg_partman

4.7.3

5.2.4

5.1.0

5.1.0

5.0.1

4.7.3

Creates and manages time-based and sequence-based table partition sets.

pg_pathman

None

None

None

None

None

1.5

A high-performance partitioned table extension.

pg_prewarm

1.2

None

1.2

1.2

1.2

1.2

Provides a convenient way to load data into the operating system buffer or the PostgreSQL buffer.

pg_profile

None

None

4.4

4.4

4.4

4.1

Statistics on resource-intensive activities.

pg_proctab

Not supported

0.0.10

0.0.10

0.0.10

0.0.10

0.0.10

Lets users access operating system-level process and system resource consumption data through SQL queries.

pg_repack

None

1.5.1

1.5.0

1.5.0

1.5.0

1.4.6

Online tablespace cleanup feature.

pg_stat_kcache

None

2.3.0

2.2.3

2.2.3

2.2.3

2.2.1

System read and write information statistics.

pg_stat_statements

1.12

1.10

1.10

1.10

1.9

1.8

Provides a way to track execution statistics for all SQL statements executed by a server.

pg_trgm

1.6

1.6

1.6

1.6

1.6

1.5

Provides functions and operators for determining the similarity of alphanumeric text, and index operator classes that support fast searching for similar strings.

pg_squeeze

1.8

1.7

1.6

1.6

1.6

1.6

Shrinks bloated tables and indexes online.

pg_wait_sampling

1.1

1.1

None

None

None

None

Used to monitor and analyze the wait states of a database.

pgaudit

None

17.0

16.0

1.6.1

1.6.1

1.5

Provides detailed session and object audit logging.

pgcrypto

1.4

1.3

1.3

1.3

1.3

1.3

Provides cryptographic functions for PostgreSQL.

pgl_ddl_deploy

None

None

2.2

2.2

2.2

2.1

Enables transparent logical DDL replication for PostgreSQL.

pglogical

2.4.6

2.4.5

2.4.5

2.4.4

2.4.4

2.4.2

Provides logical streaming replication for publishing and subscribing.

pgrouting

None

3.4.2

3.4.2

3.4.2

3.4.2

3.4.2

Provides computing and analysis features for spatial geometry networks.

pgrowlocks

1.2

1.2

1.2

1.2

1.2

1.2

Provides a function to display row lock information for a specified table.

pgsql-gzip

1.0

1.0.0

1.0.0

None

None

None

Implements Gzip compression and decompression of data in a PostgreSQL database.

pgsql-http

1.6

None

1.6

None

None

None

Lets users initiate HTTP requests directly within a PostgreSQL database.

pgstattuple

1.5

1.5

1.5

1.5

1.5

1.5

Provides various functions to obtain tuple-level statistics.

pgvector

0.8.1

0.8.0

0.8.0

0.8.0

0.8.0

None

A high-dimensional vector similarity search extension.

pldebugger

None

1.8

1.8

1.8

1.8

1.1

A stored procedure debugging extension.

plperl

None

1.0

1.0

1.0

1.0

1.0

Provides the Perl procedural language.

plpgsql

Not supported

1.0

1.0

1.0

1.0

1.0

Provides the SQL procedural language.

plproxy

2.11.0

None

2.11.0

2.10.0

2.10.0

2.10.0

Includes CLUSTER and CONNECT modes to help you access databases in different ways.

pltcl

None

1.0

1.0

1.0

1.0

1.0

Provides the Tcl procedural language.

postgis

None

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

PostGIS spatial and geographic information-related extensions.

postgis_sfcgal

None

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

PostGIS SFCGAL spatial and geographic information-related extensions.

postgis_tiger_geocoder

None

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

PostGIS TIGER data spatial and geographic information-related extensions.

postgis_topology

None

3.3.7

3.3.4

3.3.4

3.3.4

3.3.4

PostGIS topology data spatial and geographic information-related extensions.

postgres_fdw

1.2

1.1

1.1

1.1

1.1

1.0

Operates on tables across databases.

postgresql_anonymizer

None

1.1.0

None

1.1.0

1.1.0

None

Anonymizes or masks sensitive data in a database.

rds_ai

1.0

1.0.0

1.0.0

1.0.0

1.0.0

None

Integrates advanced models from Alibaba Cloud Model Studio, including Qwen and general-purpose text embeddings. This extension lets you easily implement various scenarios in your ApsaraDB RDS for PostgreSQL database, such as large model Q&A, text-to-embedding conversion, Top-N similar vector search, and retrieval-augmented generation (RAG) Q&A.

rds_ccl

1.3

1.2

1.2

1.2

1.2

None

Supports SQL throttling.

rds_duckdb

1.3.2.3

1.1

1.2

1.3

1.1

1.1

Accelerates complex queries.

rds_embedding

None

1.0

1.0

1.0

1.0

None

Provides capabilities for custom model configuration and model invocation. You can perform text-to-embedding conversion at the database level.

rds_encdb

None

None

1.0

Not supported

None

None

Encrypts sensitive columns in query result sets. By configuring database account permissions, you can ensure that relevant accounts can only retrieve query results in ciphertext format when accessing sensitive column information.

rds_online_ddl

1.0

1.0

1.0

1.0

1.0

1.0

Supports online modification of column types, allowing you to complete schema evolution without affecting business continuity.

rds_tde_utils

1.0

1.0

1.0

1.0

1.0

1.0

A batch encryption and decryption extension for TDE.

roaringbitmap

0.5.4

0.5.4

0.5.4

0.5

0.5

0.5

Uses bitmap features to improve query performance.

rum

None

1.3

1.3

1.3

1.3

1.3

High-speed full-text search.

sequential-uuids

1.0.3

None

1.0.2

1.0.2

1.0.2

1.0.2

A UUID generator with a sequential pattern.

smlar

None

1.0

1.0

1.0

1.0

1.0

Calculates the similarity between two arrays of the same type.

snowflake

2.2

2.2

2.2

2.2

None

None

Provides a unique ID solution based on int8 and sequences as an alternative to the built-in bigserial data type in PostgreSQL.

sslinfo

1.2

1.2

1.2

1.2

1.2

1.2

Provides information about the SSL certificate provided by the current client.

tablefunc

1.0

1.0

1.0

1.0

1.0

1.0

Includes multiple functions that return tables.

tds_fdw

None

2.0.4

2.0.3

2.0.3

2.0.3

2.0.3

Queries data from other types of databases.

timescaledb

None

2.17.0

2.14.2

2.9.2

2.9.2

2.5.0

Supports automatic sharding, efficient writing, retrieval, and near real-time aggregation of time series data.

tsm_system_rows

1.0

None

1.0

1.0

1.0

1.0

Provides the table sampling method SYSTEM_ROWS.

tsm_system_time

1.0

None

1.0

1.0

1.0

1.0

Provides the table sampling method SYSTEM_TIME.

unaccent

1.1

1.1

1.1

1.1

1.1

1.1

A text search dictionary that removes accents (diacritical marks) from lexemes.

uuid-ossp

1.1

1.1

1.1

1.1

1.1

1.1

Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms.

wal2json

2.6

2.6

2.6

2.6

2.6

2.3

Outputs logical log files in JSON format.

xml2

1.2

None

1.1

1.1

1.1

1.1

Provides XPath querying and XSLT features.

zhparser

2.1

1.0

1.0

1.0

1.0

1.0

Chinese full-text search.