This topic provides an overview of the plug-ins and plug-in versions that are supported by ApsaraDB RDS for PostgreSQL instances.

Note
Plug-in PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.4 Description
timescaledb None 1.7.1 1.7.1 None None This plug-in is used to support features such as the automatic sharding, efficient writes, retrieval, and near real-time aggregation of time series data.
smlar 1.0 1.0 1.0 1.0 1.0 This plug-in is used to calculate the similarity between two arrays of the same data type.
pase None None 0.0.1 None None This plug-in is used to efficiently search for vectors.
roaringbitmap None 0.5.0 None None None This plug-in is used to compute bitmaps to increase query performance.
varbitx None None 1.0 1.0 1.0 This plug-in is used to support various BIT-type operations.
rdkit None 3.8 None None 3.4 This plug-in is used to support features such as molecular computing and search.
oss_fdw 1.1 1.1 1.1 1.1 1.1 This plug-in is used to read and write data to an Object Storage Service (OSS) bucket.
mysql_fdw 1.1 1.1 1.1 1.1 None This plug-in is used to read and write data to an ApsaraDB RDS for MySQL instance or a self-managed MySQL database.
log_fdw None None 1.0 None None This plug-in is used to query the logs of an ApsaraDB RDS for PostgreSQL instance.
tds_fdw None 2.0.1 2.0.1 None None This plug-in is used to query data from an ApsaraDB RDS instance that does not run PostgreSQL.
oracle_fdw None 1.1 None None None This plug-in is used to synchronize the update operations on the tables of an ApsaraDB RDS for PostgreSQL instance to the tables of an Oracle database.
dblink 1.2 1.2 1.2 1.2 1.1 This plug-in is used to manage tables across databases.
postgres_fdw 1.0 1.0 1.0 1.0 1.0 This plug-in is used to manage tables across databases.
hll 2.15 2.14 2.14 None None This plug-in is used to estimate business metrics, such as page views (PV) and unique visitors (UV), at fast speeds.
pg_cron None 1.1 1.1 1.1 None This plug-in is used to configure scheduled tasks.
plproxy 2.10.0 2.9.0 2.9.0 2.8.0 None This plug-in provides two modes that are used to access an ApsaraDB RDS for PostgreSQL instance: CLUSTER and CONNECT.
pg_bigm 1.2 1.2 1.2 1.2 None This plug-in is used to create a 2-gram Generalized Inverted Index (GIN) that is used to accelerate full-text searches.
wal2json 2.3 2.3 2.2 None None This plug-in is used to export logical log records as a file in the JSON format.
zombodb None None 4.0 None None This plug-in provides text indexing and analytics features.
sql_firewall None 0.8 0.8 0.8 None This plug-in is used as a firewall to protect databases from SQL injection attacks.
pg_concurrency_control None None 1.0 1.0 1.0 This plug-in is used to control the concurrency of SQL statements.
rum 1.3.8 1.3.8 1.3.8 1.3.8 None This plug-in is used to efficiently run full-text searches.
zhparser 2.1 2.1 1.0 1.0 1.0 This plug-in is used to support full-text searches in Chinese.
fuzzystrmatch 1.1 1.1 1.1 1.1 1.0 This plug-in is used to calculate the similarity and distance between strings.
pg_hint_plan 1.3.7 1.3.7 1.3.7 1.3.0 1.1.3 This plug-in is used to add hints to SQL statements. The hints are used to change the execution plans of SQL statements.
pg_repack 1.4.6 1.4.6 1.4.6 1.4.6 None This plug-in is used to clear tablespaces that stay online.
pglogical 2.4.0 2.4.0 2.4.0 2.4.0 None This plug-in provides the logical streaming replication feature by using a publish/subscribe pattern.
pgaudit 1.5.0 1.4.1 1.3.2 1.2.2 None This plug-in is used to generate audit logs. The audit logs contain details about sessions and objects.
encdb 1.1.7 1.1.7 1.1.7 1.1.7 None This plug-in is used to support fully encrypted databases.
address_standardizer 2.5.4 2.5.4 2.5.4 2.5.4 None This plug-in is used to standardize the names of geographic locations based on Postal Address Geocoder (PAGC). For more information, see Tuning the Standardizer.
address_standardizer_data_us 2.5.4 2.5.4 2.5.4 2.5.4 None This plug-in is used to standardize the names of the geographic locations in the United States based on PAGC. For more information, see Tuning the Standardizer.
aggs_for_arrays None None None 1.3.1 None This plug-in provides an extension function that is used to compute the statistics of numeric arrays.
bloom 1.0 1.0 1.0 1.0 None This plug-in provides an index access method that is based on Bloom filters.
btree_gin 1.3 1.3 1.3 1.2 1.0 This plug-in provides sample GIN operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enumerated data types.
btree_gist 1.5 1.5 1.5 1.5 1.0 This plug-in provides sample GiST operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enumerated data types.
chkpass None None None 1.0 1.0 This plug-in provides a data type that is used to store encrypted passwords.
citext 1.6 1.6 1.5 1.4 1.0 This plug-in provides a string type that is not case-sensitive.
cube 1.4 1.4 1.4 1.2 1.0 This plug-in provides a data type that is used to represent multidimensional cubes.
decoderbufs 0.1.0 0.1.0 None None None This plug-in 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 plug-in 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.0 This plug-in provides two different methods that are used to calculate great-circle distances on the surface of the Earth.
ganos_address_standardizer 4.1 4.1 4.1 4.1 None This plug-in is used to standardize the names of geographic locations based on PAGC. For more information, see Tuning the Standardizer.
ganos_address_standardizer_data_us 4.1 4.1 4.1 4.1 None This plug-in is used to standardize the names of the geographic locations in the United States based on PAGC. For more information, see Tuning the Standardizer.
ganos_geometry 4.1 4.1 4.1 4.1 None This plug-in is used to compute and analyze spatial geometries.
ganos_geometry_sfcgal 4.1 4.1 4.1 4.1 None This plug-in is used to compute and analyze spatial geometries.
ganos_geometry_topology 4.1 4.1 4.1 4.1 None This plug-in is an extension of the SFCGAL plug-in that is used to process spatial geometries.
ganos_networking 4.1 4.1 4.1 4.1 None This plug-in is used to compute and analyze spatial network geometries.
ganos_pointcloud 4.1 4.1 4.1 4.1 None This plug-in is used to store, compute, and analyze point clouds.
ganos_pointcloud_geometry 4.1 4.1 4.1 4.1 None This plug-in is used to store, compute, and analyze point clouds.
ganos_raster 4.1 4.1 4.1 4.1 None This plug-in is used to store, compute, and analyze spatial grids.
ganos_spatialref 4.1 4.1 4.1 4.1 None This plug-in is used to compute and analyze spatial references.
ganos_tiger_geocoder 4.1 4.1 4.1 4.1 None This plug-in is used to support the Topologically Integrated Geographic Encoding and Referencing (TIGER) data format that is used by the United States Census Bureau (USCB).
ganos_trajectory 4.1 4.1 4.1 4.1 None This plug-in is used to compute and analyze objects in the moving object detection (MOD) system of Ganos.
hstore 1.7 1.6 1.5 1.4 1.3 This plug-in is used to store key-value pairs within a single PostgreSQL value.
imgsmlr None None None None 1.0 This plug-in is used to search for similar images.
intagg 1.1 1.1 1.1 1.1 1.0 This plug-in provides an integer aggregator and an enumerator.
intarray 1.3 1.2 1.2 1.2 1.0 This plug-in provides functions and operators that are used to manage null-free arrays of integers.
isn 1.2 1.2 1.2 1.1 1.0 This plug-in is used to validate input numbers and hyphenate output numbers based on a hard-coded list of prefixes.
ltree 1.2 1.1 1.1 1.1 1.0 This plug-in is used to label the data that is stored in a hierarchical tree structure.
jsonbx None None None None 1.0 This plug-in is an extension that is used in PostgreSQL 9.4 to support JSONB functions.
orafce None None 3.8 3.6 3.6 This plug-in provides functions that are compatible with Oracle.
pg_buffercache 1.3 1.3 1.3 1.3 1.0 This plug-in is used to examine shared buffers in real time.
pg_freespacemap 1.2 1.2 1.2 1.2 1.0 This plug-in is used to examine the free space map (FSM).
pg_pathman 1.5 1.5.12 1.5.12 1.5 None This plug-in is used to partition tables at high performance.
pg_prewarm 1.2 1.2 1.2 1.1 1.0 This plug-in is used to load data to the buffer of the operating system or PostgreSQL database engine.
pg_sphere None None None 1 1 This plug-in provides spherical data types, functions, operators, and indexes for PostgreSQL.
pg_stat_statements 1.8 1.7 1.6 1.6 1.2 This plug-in is used to track the statistics of all SQL statements that are executed on a specified server.
pg_trgm 1.5 1.4 1.4 1.3 1.1 This plug-in provides functions and operators that are used to calculate the similarity between alphanumeric texts. This plug-in also provides index operator classes that are used to search for similar strings at fast speeds.
pgcrypto 1.3 1.3 1.3 1.3 1.1 This plug-in provides cryptographic functions for PostgreSQL.
pgrouting None None 2.6.2 2.6.2 2.0.0 This plug-in is used to compute and analyze spatial network geometries.
pgrowlocks 1.2 1.2 1.2 1.2 1.1 This plug-in provides a function that is used to display the row lock information of a specified table.
pgstattuple 1.5 1.5 1.5 1.5 1.2 This plug-in provides various functions that are used to obtain tuple-level statistics.
plperl 1.0 1.0 1.0 1.0 1.0 This plug-in is used to support the Perl procedural language.
plpgsql 1.0 1.0 1.0 1.0 1.0 This plug-in is used to support the SQL procedural language.
pltcl None None None None 1.0 This plug-in is used to support the TCL procedural language.
plv8 2.3.15 2.3.15 2.3.15 2.3.15 1.4.2 This plug-in is a trusted JavaScript language extension.
postgis 2.5.4 2.5.4 2.5.4 2.5.4 2.5.4 This plug-in is an extension that is used to process and store spatial geographic information.
postgis_sfcgal 2.5.4 2.5.4 2.5.4 2.5.4 None This plug-in is an extension that is used to manage spatial geographic information in PostGIS.
postgis_tiger_geocoder 2.5.4 2.5.4 2.5.4 2.5.4 2.5.4 This plug-in is an extension that is used to manage PostGIS data in the TIGER format.
postgis_topology 2.5.4 2.5.4 2.5.4 2.5.4 2.5.4 This plug-in is an extension that is used to manage topological objects in PostGIS.
q3c None None None 1.5.0 1.5.0 This plug-in is used to create spatial indexes on a sphere.
sslinfo 1.2 1.2 1.2 1.2 1.0 This plug-in 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 plug-in provides functions that are used to return tables.
tsearch2 None None None None 1.0 This plug-in provides a text search feature that is compatible with earlier tsearch2 versions.
tsm_system_rows 1.0 1.0 1.0 None None This plug-in provides a table sampling method called SYSTEM_ROWS.
tsm_system_time 1.0 1.0 1.0 None None This plug-in provides a table sampling method called SYSTEM_TIME.
unaccent 1.1 1.1 1.1 1.1 1.0 This plug-in provides a text search dictionary that is used to remove accent marks or diacritic signs from lexemes.
uuid-ossp 1.1 None None 1.1 1.0 This plug-in provides functions that use a standard algorithm to generate universally unique identifiers (UUIDs).
xml2 1.1 1.1 1.1 1.1 1.0 This plug-in provides XPath query and XSLT functionality.