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

Note
Plug-in PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.4 Description
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.
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 Generalized Inverted Index (GIN) operator classes that are used to implement B-tree equivalent behavior for multiple data types and all enum 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 enum 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.
dblink 1.2 1.2 1.2 1.2 1.1 This plug-in is used to manage tables across databases.
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.
fuzzystrmatch 1.1 1.1 1.1 1.1 1.0 This plug-in is used to calculate the similarity and distance between strings.
ganos_address_standardizer 3.7 3.7 3.7 3.7 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 3.7 3.7 3.7 3.7 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 3.7 3.7 3.7 3.7 None This plug-in is used to compute and analyze spatial geometries.
ganos_geometry_sfcgal 3.7 3.7 3.7 3.7 None This plug-in is used to compute and analyze spatial geometries.
ganos_geometry_topology 3.7 3.7 3.7 3.7 None This plug-in is an extension to the SFCGAL plug-in that is used to process spatial geometries.
ganos_networking 3.7 3.7 3.7 3.7 None This plug-in is used to compute and analyze spatial network geometries.
ganos_pointcloud 3.7 3.7 3.7 3.7 None This plug-in is used to store, compute, and analyze point clouds.
ganos_pointcloud_geometry 3.7 3.7 3.7 3.7 None This plug-in is used to store, compute, and analyze point clouds.
ganos_raster 3.7 3.7 3.7 3.7 None This plug-in is used to store, compute, and analyze spatial grids.
ganos_spatialref 3.7 3.7 3.7 3.7 None This plug-in is used to compute and analyze spatial references.
ganos_tiger_geocoder 3.7 3.7 3.7 3.7 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 3.7 3.7 3.7 3.7 None This plug-in is used to compute and analyze objects in the moving object detection (MOD) system of Ganos.
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 high speeds.
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.
jsonbx None None None None 1.0 This plug-in is an extension that is used in PostgreSQL 9.4 to support JSONB functions.
log_fdw None None 1.0 None None This plug-in is used to query the logs of an RDS instance.
ltree 1.2 1.1 1.1 1.1 1.0 This plug-in is used to represent the labels of the data that is stored in a hierarchical tree-like structure.
mysql_fdw 1.1 1.1 1.1 1.1 None This plug-in is used to read and write data to a database on an ApsaraDB RDS for MySQL or self-managed MySQL instance.
orafce None None 3.8 3.6 3.6 This plug-in provides a number of Oracle-compatible functions.
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.
pase None None 0.0.1 None None This plug-in is used to search for vectors at high speeds.
pg_bigm 1.2 1.2 1.2 1.2 None This plug-in is used to create a 2-gram GIN index that is used to accelerate full-text searches.
pg_buffercache 1.3 1.3 1.3 1.3 1.0 This plug-in is used to examine the shared buffer in real time.
pg_concurrency_control None None 1.0 1.0 1.0 This plug-in is used to control the concurrency of SQL statements.
pg_cron None 1.1 1.1 1.1 None This plug-in is used to configure scheduled tasks.
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_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. These hints are used to change the plans based on which SQL statements are executed.
pg_pathman 1.5 1.5 1.5 1.5 None This plug-in is used to ensure high performance when you partition tables.
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_roaringbitmap None 0.5.0 None None None This plug-in is used to compute bitmaps. This increases query performance.
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 the SQL statements that are executed on the same 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 high 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.
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 RDS instance: CLUSTER and CONNECT.
pltcl None None None None 1.0 This plug-in is used to support the TCL procedural language.
plv8 2.3.13 2.3.13 2.3.13 1.4.2 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.2.8 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.2.8 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.2.8 This plug-in is an extension that is used to manage topological objects in PostGIS.
postgres_fdw 1.0 1.0 1.0 1.0 1.0 This plug-in is used to manage tables across databases.
q3c None None None 1.5.0 1.5.0 This plug-in is used to create spatial indexes on a sphere.
rdkit None 3.8 None None 3.4 This plug-in is used to support features such as molecular computing and search.
rum 1.3 1.3 1.3 1.3 None This plug-in is used to run full-text searches at high speeds.
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.
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 a number of functions that are used to return tables.
tds_fdw None 2.0.1 2.0.1 None None This plug-in is used to query data from an RDS instance that runs a different database engine than the connected RDS instance.
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 (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).
varbitx None None 1.0 1.0 1.0 This plug-in is used to support various BIT-type operations.
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.
xml2 1.1 1.1 1.1 1.1 1.0 This plug-in provides XPath query and XSLT functionality.
zhparser 2.1 2.1 1.0 1.0 1.0 This plug-in is used to support full-text searches in Chinese.
zombodb None None 4.0 None None This plug-in provides text indexing and analytics features.
pg_repack 1.4.6 1.4.6 1.4.6 1.4.6 None This plug-in provides a feature that clears tablespaces.