Supported Extensions
The following table lists the extensions supported by the latest minor versions of RDS for PostgreSQL. You can use SELECT name FROM pg_available_extensions; to view the extensions supported by your DB instance. If any of the following extensions is not supported by your PostgreSQL version, migrate your data to an RDS for PostgreSQL instance of the latest version.
The extensions mysql_fdw, dblink, postgres_fdw, and tds_fdw are used to access data stored in remote database servers. Before using any of them, ensure that the server IP addresses of the two DB instances are in the same VPC and subnet.
Extensions Supported by PostgreSQL
| Extension Name | Description | Whether to Preload Parameter Values and Reboot the Instance Before Installing the Extension | 13 | 14 | 15 | 16 | 17 | 18 |
|---|---|---|---|---|---|---|---|---|
| address_standardizer | An address standardization extension based on the PAGC standard | No | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
| address_standardizer_data_us | An address standardization (US) data extension based on the PAGC standard | No | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
| amcheck | Verifies the consistency between tables and indexes. | No | 1.2 | 1.3 | 1.3 | 1.3 | 1.4 | 1.5 |
| anon | Provides a data anonymization tool. | Yes | 0.7.1 | 1.3.2 | 1.3.2 | 1.3.2 | 1.3.2 | 1.3.2 |
| auth_delay | Causes the server to pause briefly before reporting authentication failure. | Yes | 2 | 2 | 2 | 2 | 2 | 2 |
| auto_explain | Records the execution plan of slow queries. | No | 2 | 2 | 2 | 2 | 2 | 2 |
| autoinc | A function used for auto-increment fields | No | 1 | 1 | 1 | 1 | 1 | 1 |
| bloom | Provides index access methods based on Bloom filters. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| btree_gin | Provides GIN operator classes that implement B-tree equivalent behavior. | No | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
| btree_gist | Provides GiST operator classes that implement B-tree equivalent behavior. | No | 1.5 | 1.6 | 1.7 | 1.7 | 1.7 | 1.8 |
| citext | Provides a case-insensitive string type. | No | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 | 1.8 |
| cube For details, see cube. | Provides a data type to represent multidimensional cubes. | No | 1.4 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
| dblink | Performs cross-database operations on tables. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| dict_int | Adds an example of a full-text search dictionary template. | No | 1.0 | 1.0 | 1.0 | 1 | 1 | 1.0 |
| dict_xsyn | Adds an example of a full-text search synonym dictionary template. | No | 1.0 | 1.0 | 1.0 | 1 | 1 | 1.0 |
| earthdistance For details, see earthdistance. | Provides two different approaches to calculating great circle distances on the surface of the Earth. | No | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 | 1.2 |
| fuzzystrmatch | Determines the similarity and distance between strings. | No | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 | 1.2 |
| h3 | Provides Uber's H3 hierarchical hexagonal geospatial indexing. | No | 4.2.3 | 4.2.3 | 4.2.3 | 4.2.3 | 4.2.3 | 4.2.3 |
| hll | Quickly estimates service metrics such as PV and UV. | No | 2.18 | 2.18 | 2.18 | 2.18 | 2.18 | 2.19 |
| hstore | Stores key-value pairs in a single PostgreSQL instance. | No | 1.7 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
| hypopg | Creates virtual indexes. | No | 1.4.1 | 1.4.2 | 1.4.2 | 1.4.2 | 1.4.2 | 1.4.2 |
| icu | Precisely controls string collation, case conversion, and other behaviors. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| insert_username | Tracks the username used to modify a table. | No | 1 | 1 | 1 | 1 | 1 | 1 |
| intagg | Provides an integer aggregator and an enumerator. | No | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| intarray | Provides some useful functions and operators to manipulate integer arrays that do not contain null values. | No | 1.3 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
| ip4r | Enables PostgreSQL to support the IP address range type. | No | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 | 2.4.2 |
| isn | Validates input against a hard-coded list of prefixes, and also used to connect numbers during output. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.3 |
| jsonb_plperl | Establishes a conversion mechanism between JSONB and PL/Perl. | No | 1 | 1 | 1 | 1 | 1 | 1.0 |
| lo | Manages large objects. | No | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 |
| ltree | Represents a label for data stored in a hierarchical tree structure. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.3 | 1.3 |
| moddatetime | Tracks the last modification time. | No | 1 | 1 | 1 | 1 | 1 | 1 |
| mysql_fdw | Queries the foreign data wrapper of the MySQL server. | No | 2.9.2 | 2.9.3 | 2.9.3 | 2.9.3 | 2.9.3 | 2.9.3 |
| obs_fdw | Queries the foreign data wrapper of OBS. | No | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 | 1.0.0 |
| old_snapshot | Checks and debugs the mapping status from the internal timestamp to the transaction ID of the server. | No | - | 1 | 1 | 1 | - | - |
| oracle_fdw | Synchronizes PostgreSQL table updates to the tables in the Oracle database. | No | 2.3.0 | - | - | - | - | - |
| orafce | Provides a series of Oracle-compatible functions. | No | 3.14.0 | 3.21.1 | 4.14 | 4.14 | 4.14 | 4.16.5 |
| pageinspect | Performs low-level checks on database pages. | No | 1.8 | 1.9 | 1.11 | 1.12 | 1.12 | 1.13 |
| passwordcheck | Verifies the password strength. | No | 2 | 2 | 2 | 2 | 2 | 2 |
| pgaudit | Provides detailed session and object audit logs. | No | 1.5.2 | 1.6.2 | 1.7.0 | 16.0 | 17.0 | 18.0 |
| pg_bigm | Creates a 2-gram GIN index to accelerate the full-text search process. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| pg_buffercache | Provides a method to check the shared buffer in real time. | No | 1.3 | 1.3 | 1.3 | 1.4 | 1.5 | 1.6 |
| pg_cron | Sets scheduled tasks. | Yes | 1.6.7 | 1.6.7 | 1.6.7 | 1.6.7 | 1.6.7 | 1.6.7 |
| pg_freespacemap | Checks the free space map (FSM). | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.3 |
| pg_hint_plan | Uses special comment statements to prompt PostgreSQL to change its established execution plan. | Yes | 1.3.10 | 1.4.3 | 1.5.2 | 1.6.1 | 1.7.0 | 1.8.0 |
| pg_jieba | Implements word segmentation for on the entire Chinese text. | No | 2.0.1 | 1.1.0 | 1.1.0 | - | - | - |
| pg_partman | Creates and manages time- and sequence-based table partitioning sets. | No | - | 5.0.1 | 5.0.1 | 5.0.1 | 5.2.2 | 5.4.3 |
| pg_pathman | Provides optimized partitioning mechanism and functions to manage partitions. | Yes | 1.5.12 | - | - | - | - | - |
| pg_prewarm | Provides a convenient method to load data into the OS buffer or PostgreSQL buffer. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| pg_qualstats | Collects statistics about predicates in the WHERE and JOIN clauses. | Yes | 2.1.1 | 2.1.1 | 2.1.1 | 2.1.1 | 2.1.1 | 2.1.3 |
| pg_repack | Cleans tablespaces online. | No | 1.5.2 | 1.5.2 | 1.5.2 | 1.5.2 | 1.5.2 | 1.5.3 |
| roaringbitmap | Uses the bitmap function to improve query performance. | No | 0.5.4 | 0.5.4 | 0.5.4 | 0.5.4 | 0.5.4 | 1.1.0 |
| pg_stat_kcache | Collects statistics about system read and write information. | Yes | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.0 | 2.3.1 |
| pg_stat_statements | Provides a method for tracking execution statistics of all SQL statements executed by a server. | No | 1.8 | 1.9 | 1.10 | 1.1 | 1.11 | 1.12 |
| pg_surgery | Performs surgery on a damaged relation. | No | - | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| pg_tle | Provides trusted language extensions for PostgreSQL. | Yes | 1.4.0 | 1.4.0 | 1.4.0 | 1.4.0 | 1.4.0 | 1.5.2 |
| pg_track_settings | Traces the change history of database parameter settings. | No | 2.1.2 | 2.1.2 | 2.1.2 | 2.1.2 | - | - |
| pg_trgm | Provides functions and operators for measuring the similarity of alphanumeric text, as well as index operator classes that support fast similarity searching. | No | 1.5 | 1.6 | 1.6 | 1.6 | 1.6 | 1.6 |
| pg_visibility | Provides a means for examining the visibility map (VM) and page-level visibility information of a table. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| pg_wait_sampling | Monitors and analyzes the waiting status of the database. | Yes | 1.1.6 | 1.1.6 | 1.1.6 | 1.1.6 | 1.1.6 | 1.1.9 |
| pg_walinspect | Provides functions to check the contents of PostgreSQL write-ahead logs. | No | - | - | 1 | 1.1 | 1.1 | 1.1 |
| pgcrypto | Provides cryptographic functions for PostgreSQL. | No | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.4 |
| pgl_ddl_deploy | Enables PostgreSQL to support transparent logical DDL replication. | No | 2.1.0 | 2.1.0 | 2.1.0 | 2.2.1 | 2.2.1 | - |
| pglogical | Provides logical streaming replication using a publisher and subscriber model. | Yes | 2.4.5 | 2.4.5 | 2.4.5 | 2.4.5 | 2.4.5 | 2.4.6 |
| pgrouting | Provides the calculation and analysis functions for spatial geometric networks. | No | 3.1.4 | 3.3.1 | 3.5.0 | 3.6.1 | 3.7.1 | 4.0.1 |
| pgrowlocks | Provides a function to display row locking information about a specified table. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| pg_sql_history For details, see pg_sql_history. | An extension for SQL audit | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| pgstattuple | Provides multiple functions to obtain statistics at the tuple layer. | No | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |
| pgvector | An extension for high-dimensional vector similarity search | No | 0.8.0 | 0.8.0 | 0.8.0 | 0.8.0 | 0.8.0 | 0.8.2 |
| plpgsql For details, see plpgsql. | Provides the SQL procedural language. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| plperl | Provides the Perl procedural language. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| plprofiler | Analyzes and tunes the performance of PL/pgSQL. | No | 4.2.4 | 4.2.4 | 4.2.4 | 4.2.4 | 4.2.4 | 4.2.5 |
| plproxy | Includes the CLUSTER and CONNECT modes, which help access the database in different ways. | No | 2.11.0 | 2.11.0 | 2.11.0 | 2.11.0 | 2.11.0 | 2.11.0 |
| postgis For details, see postgis. | PostGIS extension that adds support for spatial and geographic information | No | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
| postgis_raster | Processes raster spatial data. | No | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
| postgis_sfcgal | PostGIS SFCGAL extension for spatial and geographic information | No | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
| postgis_tiger_geocoder | PostGIS TIGER extension for spatial and geographic information | No | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
| postgis_topology | PostGIS topology extension for spatial and geographic information | No | 3.1.11 | 3.2.7 | 3.4.3 | 3.4.3 | 3.5.0 | 3.6.3 |
| postgres_fdw | Performs cross-database operations on tables. | No | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 |
| postgres-decoderbufs For details, see postgres-decoderbufs. | An extension for logical decoding output | No | 1.7.0 | 1.7.0 | - | - | - | - |
| powa | PostgreSQL workload analyzer | No | 4.2.2 | 4.2.2 | 4.2.2 | 4.2.2 | 5.0.0 | 5.1.1 |
| rds_hwdrs_ddl | An extension for DRS migration | No | 1 | 1 | 1 | 1 | 1 | 1 |
| rds_hwdrs_privs | Escalates permissions for a version without root privilege escalation. | No | 1 | 1 | 1 | 1 | 1 | 1 |
| rds_pg_sql_ccl | Controls the number of concurrent SQL statements that can be executed. | No | 1 | 1 | 1 | 1 | 1 | 1 |
| rds_performance_statements | Monitors QPS-related metrics. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| rum | Performs high-speed full-text search. | No | 1.3.14 | 1.3.14 | 1.3.14 | 1.3.14 | 1.3.14 | 1.3.15 |
| seg | Provides data types that represent line segments or floating-point ranges. | No | 1.3 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
| sslinfo | Obtains the SSL information of the client. | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| tablefunc | Provides functions that return tables (multiple rows). | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| tcn | Provides a trigger function to notify listeners of changes in table contents. | No | 1 | 1 | 1 | 1 | 1 | 1 |
| tds_fdw | Queries data in other types of databases. | No | 2.0.4 | 2.0.4 | 2.0.4 | 2.0.4 | 2.0.4 | 2.0.5 |
| test_decoding | Provides the SQL-based WAL logical decoding. | No | 2 | 2 | 2 | 2 | 2 | 2 |
| TimescaleDB For details, see TimescaleDB. | Supports automatic sharding, efficient write, retrieval, and quasi-real-time aggregation of time series data. | Yes | 2.1.0 | 2.7.0 | 2.11.1 | 2.14.2 | 2.17.2 | 2.27.0 |
| tsm_system_rows | Provides the SYSTEM_ROWS sampling method for tables. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| tsm_system_time | Provides the SYSTEM_TIME sampling method for tables. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| unaccent | A text search dictionary that removes accents (diacritical marks) from lexemes | No | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| uuid-ossp | Provides functions that generate universally unique identifiers (UUIDs) using one of several standard algorithms. | No | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| wal2json For details, see wal2json. | Outputs logical log files in JSON format. | No | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.6 |
| xml2 | Provides XPath query and XSLT functions. | No | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.2 |
| zhparser | Performs full-text search in Chinese. | No | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | 2.3 |
| pg_stat_monitor | A query performance monitoring tool for PostgreSQL, which can provide aggregate statistics, client information, execution plans, and histograms | Yes | 2.1 | 2.1 | 2.1 | 2.1 | 2.1 | 2.3.2 |
| pg_tm_aux | Allows the creation of a logical replication slot at a past log sequence number (LSN). | No | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
| pg_net | Initiates HTTP requests asynchronously. | Yes | - | - | - | - | 0.20.2 | 0.20.2 |
| recyclebin | Provides the table recycle bin function. | Yes | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 |
| supabase_vault | Encrypts, stores, and manages sensitive character strings securely within a database. | Yes | - | - | - | - | 0.3.1 | 0.3.1 |
| Extension Name | Description | Whether to Preload Parameter Values and Reboot the Instance Before Installing the Extension | 9.5 | 9.6 | 10 | 11 | 12 |
|---|---|---|---|---|---|---|---|
| address_standardizer | An address standardization extension based on the PAGC standard | No | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 |
| address_standardizer_data_us | An address standardization (US) data extension based on the PAGC standard | No | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 |
| amcheck | Verifies the consistency between tables and indexes. | No | - | - | - | 1.1 | 1.2 |
| anon | Provides a data anonymization tool. | Yes | - | - | - | - | 0.7.1 |
| auth_delay | Causes the server to pause briefly before reporting authentication failure. | Yes | - | - | - | - | 2 |
| auto_explain | Records the execution plan of slow queries. | No | 2 | 2 | 2 | 2 | 2 |
| autoinc | A function used for auto-increment fields | No | - | - | - | - | 1 |
| bloom | Provides index access methods based on Bloom filters. | No | - | - | - | 1.0 | 1.0 |
| btree_gin | Provides GIN operator classes that implement B-tree equivalent behavior. | No | 1.0 | 1.0 | 1.2 | 1.3 | 1.3 |
| btree_gist | Provides GiST operator classes that implement B-tree equivalent behavior. | No | 1.1 | 1.2 | 1.5 | 1.5 | 1.5 |
| citext | Provides a case-insensitive string type. | No | 1.1 | 1.3 | 1.4 | 1.5 | 1.6 |
| cube For details, see cube. | Provides a data type to represent multidimensional cubes. | No | 1.0 | 1.2 | 1.2 | 1.4 | 1.4 |
| dblink | Performs cross-database operations on tables. | No | 1.1 | 1.2 | 1.2 | 1.2 | 1.2 |
| dict_int | Adds an example of a full-text search dictionary template. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| dict_xsyn | Adds an example of a full-text search synonym dictionary template. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| earthdistance For details, see earthdistance. | Provides two different approaches to calculating great circle distances on the surface of the Earth. | No | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 |
| fuzzystrmatch | Determines the similarity and distance between strings. | No | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 |
| hll | Quickly estimates service metrics such as PV and UV. | No | 2.12 | 2.12 | 2.12 | 2.12 | 2.14 |
| hstore | Stores key-value pairs in a single PostgreSQL instance. | No | 1.3 | 1.4 | 1.4 | 1.5 | 1.6 |
| hypopg | Creates virtual indexes. | No | - | - | - | 1.4.0 | 1.4.1 |
| icu | Precisely controls string collation, case conversion, and other behaviors. | No | - | - | - | 1.0 | 1.0 |
| insert_username | Tracks the username used to modify a table. | No | - | - | - | - | 1 |
| intagg | Provides an integer aggregator and an enumerator. | No | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 |
| intarray | Provides some useful functions and operators to manipulate integer arrays that do not contain null values. | No | 1.0 | 1.2 | 1.2 | 1.2 | 1.2 |
| ip4r | Enables PostgreSQL to support the IP address range type. | No | - | - | - | - | 2.4.2 |
| isn | Validates input against a hard-coded list of prefixes, and also used to connect numbers during output. | No | 1.0 | 1.1 | 1.1 | 1.2 | 1.2 |
| jsonb_plperl | Establishes a conversion mechanism between JSONB and PL/Perl. | No | - | - | - | - | 1 |
| lo | Manages large objects. | No | - | - | - | - | 1.1 |
| ltree | Represents a label for data stored in a hierarchical tree structure. | No | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 |
| moddatetime | Tracks the last modification time. | No | - | - | - | - | 1 |
| mysql_fdw | Queries the foreign data wrapper of the MySQL server. | No | - | - | - | 2.9.1 | 2.9.2 |
| obs_fdw | Queries the foreign data wrapper of OBS. | No | - | - | - | - | 1.0.0 |
| old_snapshot | Checks and debugs the mapping status from the internal timestamp to the transaction ID of the server. | No | - | - | - | - | - |
| oracle_fdw | Synchronizes PostgreSQL table updates to the tables in the Oracle database. | No | - | - | 2.1.0 | 2.1.0 | 2.2.0 |
| orafce | Provides a series of Oracle-compatible functions. | No | 3.8.0 | 3.8.0 | 3.8.0 | 3.8.0 | 3.8.0 |
| pageinspect | Performs low-level checks on database pages. | No | 1.3 | 1.5 | 1.6 | 1.7 | 1.7 |
| passwordcheck | Verifies the password strength. | No | 2 | 2 | 2 | 2 | 2 |
| pgaudit | Provides detailed session and object audit logs. | No | - | - | - | - | 1.4.3 |
| pg_bigm | Creates a 2-gram GIN index to accelerate the full-text search process. | No | - | - | - | 1.2_20200228 | 1.2 |
| pg_buffercache | Provides a method to check the shared buffer in real time. | No | 1.1 | 1.2 | 1.3 | 1.3 | 1.3 |
| pg_cron | Sets scheduled tasks. | Yes | - | - | - | - | 1.6.7 |
| pg_freespacemap | Checks the free space map (FSM). | No | 1.0 | 1.1 | 1.2 | 1.2 | 1.2 |
| pg_hint_plan | Uses special comment statements to prompt PostgreSQL to change its established execution plan. | Yes | 1.1.5 | 1.2.0 | 1.3.0 | 1.3.5 | 1.3.9 |
| pg_jieba | Implements word segmentation for on the entire Chinese text. | No | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 | 1.1.0 |
| pg_partman | Creates and manages time- and sequence-based table partitioning sets. | No | - | - | - | - | - |
| pg_pathman | Provides optimized partitioning mechanism and functions to manage partitions. | Yes | 1.5.8 | 1.5.8 | 1.5.8 | 1.5.8 | 1.5.12 |
| pg_prewarm | Provides a convenient method to load data into the OS buffer or PostgreSQL buffer. | No | 1.0 | 1.1 | 1.1 | 1.2 | 1.2 |
| pg_qualstats | Collects statistics about predicates in the WHERE and JOIN clauses. | Yes | - | - | - | 2.1.0 | 2.1.0 |
| pg_repack | Cleans tablespaces online. | No | 1.5.0 | 1.5.0 | 1.5.0 | 1.5.0 | 1.5.0 |
| roaringbitmap | Uses the bitmap function to improve query performance. | No | - | - | - | 0.5.4 | 0.5.4 |
| pg_stat_kcache | Collects statistics about system read and write information. | Yes | - | - | - | 2.2.3 | 2.2.3 |
| pg_stat_statements | Provides a method for tracking execution statistics of all SQL statements executed by a server. | No | 1.3 | 1.4 | 1.6 | 1.6 | 1.7 |
| pg_surgery | Performs surgery on a damaged relation. | No | - | - | - | - | - |
| pg_tle | Provides trusted language extensions for PostgreSQL. | Yes | - | - | - | - | - |
| pg_track_settings | Traces the change history of database parameter settings. | No | - | - | - | 2.1.2 | 2.1.2 |
| pg_trgm | Provides functions and operators for measuring the similarity of alphanumeric text, as well as index operator classes that support fast similarity searching. | No | 1.1 | 1.3 | 1.3 | 1.4 | 1.4 |
| pg_visibility | Provides a means for examining the visibility map (VM) and page-level visibility information of a table. | No | - | - | - | 1.2 | 1.2 |
| pg_wait_sampling | Monitors and analyzes the waiting status of the database. | Yes | - | - | - | 1.1.5 | 1.1.5 |
| pg_walinspect | Provides functions to check the contents of PostgreSQL write-ahead logs. | No | - | - | - | - | - |
| pgcrypto | Provides cryptographic functions for PostgreSQL. | No | 1.2 | 1.3 | 1.3 | 1.3 | 1.3 |
| pgl_ddl_deploy | Enables PostgreSQL to support transparent logical DDL replication. | No | - | - | - | - | 2.1.0 |
| pglogical | Provides logical streaming replication using a publisher and subscriber model. | Yes | - | - | - | 2.4.4 | 2.4.4 |
| pgrouting | Provides the calculation and analysis functions for spatial geometric networks. | No | - | - | - | 3.1.0 | 3.1.0 |
| pgrowlocks | Provides a function to display row locking information about a specified table. | No | 1.1 | 1.2 | 1.2 | 1.2 | 1.2 |
| pg_sql_history For details, see pg_sql_history. | An extension for SQL audit | No | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
| pgstattuple | Provides multiple functions to obtain statistics at the tuple layer. | No | 1.3 | 1.4 | 1.5 | 1.5 | 1.5 |
| pgvector | An extension for high-dimensional vector similarity search | No | - | - | - | - | 0.7.0 |
| plpgsql For details, see plpgsql. | Provides the SQL procedural language. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| plperl | Provides the Perl procedural language. | No | - | - | - | 1.0 | 1.0 |
| plprofiler | Analyzes and tunes the performance of PL/pgSQL. | No | - | - | - | - | 4.2.4 |
| plproxy | Includes the CLUSTER and CONNECT modes, which help access the database in different ways. | No | - | - | - | 2.11.0 | 2.11.0 |
| postgis For details, see postgis. | PostGIS extension that adds support for spatial and geographic information | No | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 |
| postgis_raster | Processes raster spatial data. | No | Integrated to postgis | Integrated to postgis | Integrated to postgis | Integrated to postgis | 3.0.0 |
| postgis_sfcgal | PostGIS SFCGAL extension for spatial and geographic information | No | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 |
| postgis_tiger_geocoder | PostGIS TIGER extension for spatial and geographic information | No | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 |
| postgis_topology | PostGIS topology extension for spatial and geographic information | No | 2.5.1 | 2.5.1 | 2.5.1 | 2.5.1 | 3.0.0 |
| postgres_fdw | Performs cross-database operations on tables. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| postgres-decoderbufs For details, see postgres-decoderbufs. | An extension for logical decoding output | No | - | - | - | 1.7.0 | 1.7.0 |
| powa | PostgreSQL workload analyzer | No | - | - | - | - | 4.2.2 |
| rds_hwdrs_ddl | An extension for DRS migration | No | 1 | 1 | 1 | 1 | 1 |
| rds_hwdrs_privs | Escalates permissions for a version without root privilege escalation. | No | 1 | 1 | 1 | 1 | 1 |
| rds_pg_sql_ccl | Controls the number of concurrent SQL statements that can be executed. | No | - | - | - | - | 1 |
| rum | Performs high-speed full-text search. | No | - | - | - | 1.3 | 1.3.14 |
| seg | Provides data types that represent line segments or floating-point ranges. | No | - | - | - | - | 1.3 |
| sslinfo | Obtains the SSL information of the client. | No | - | - | - | 1.2 | 1.2 |
| tablefunc | Provides functions that return tables (multiple rows). | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| tcn | Provides a trigger function to notify listeners of changes in table contents. | No | - | - | - | - | 1 |
| tds_fdw | Queries data in other types of databases. | No | - | - | 2.0.3 | 2.0.3 | 2.0.3 |
| test_decoding | Provides the SQL-based WAL logical decoding. | No | 2 | 2 | 2 | 2 | 2 |
| TimescaleDB For details, see TimescaleDB. | Supports automatic sharding, efficient write, retrieval, and quasi-real-time aggregation of time series data. | Yes | 0 | 1.3.2 | 1.3.2 | 1.3.2 | 1.7.0 |
| tsm_system_rows | Provides the SYSTEM_ROWS sampling method for tables. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| tsm_system_time | Provides the SYSTEM_TIME sampling method for tables. | No | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |
| unaccent | A text search dictionary that removes accents (diacritical marks) from lexemes | No | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 |
| uuid-ossp | Provides functions that generate universally unique identifiers (UUIDs) using one of several standard algorithms. | No | 1.0 | 1.1 | 1.1 | 1.1 | 1.1 |
| wal2json For details, see wal2json. | Outputs logical log files in JSON format. | No | - | - | - | 2.5 | 2.5 |
| xml2 | Provides XPath query and XSLT functions. | No | - | - | - | 1.1 | 1.1 |
| zhparser | Performs full-text search in Chinese. | No | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 |
| pg_stat_monitor | A query performance monitoring tool for PostgreSQL, which can provide aggregate statistics, client information, execution plans, and histograms | Yes | - | - | - | - | 2.1 |
| pg_tm_aux | Allows the creation of a logical replication slot at a past log sequence number (LSN). | No | - | - | - | - | 1.1 |
| pg_net | Initiates HTTP requests asynchronously. | Yes | - | - | - | - | - |
| recyclebin | Provides the table recycle bin function. | Yes | - | - | - | - | 0.4 |
| supabase_vault | Encrypts, stores, and manages sensitive character strings securely within a database. | Yes | - | - | - | - | - |
Extension Description
- postgis
- Creating postgis_topology and postgis_tiger_geocoder will change the search_path settings. However, this change will not take effect for established connections. To use the two extensions, re-establish a connection to update the search_path settings.
- plpgsql
plpgsql 1.0 provides the SQL procedural language and is installed by default.
- earthdistance
To install the earthdistance extension, you must install the cube extension first.
- cube
If the earthdistance extension has been installed, deleting the cube extension will cause the earthdistance extension to be unavailable.
- TimescaleDB
The TimescaleDB extension of RDS for PostgreSQL supports only the features of the Apache protocol. It does not support the features of the TSL protocol. For details, see APIs Not Supported by TimescaleDB.
- wal2json, postgres-decoderbufs
They are logical replication extensions. You can use them directly without installing them through control_extension.
They are not listed in the pg_available_extensions view. To check whether the two extensions are supported, run the statements below. If no error is reported during the execution, the extensions are supported.
- wal2json
select pg_create_logical_replication_slot('tst_wal2json', 'wal2json'); - postgres-decoderbufs
select pg_create_logical_replication_slot('tst_decoderbufs', 'decoderbufs');
After the execution, delete the slot to prevent WAL log accumulation.- Delete the slot tst_wal2json.
select pg_drop_replication_slot('tst_wal2json'); - Delete the slot tst_decoderbufs.
select pg_drop_replication_slot('tst_decoderbufs');
- wal2json
- pg_sql_history
This extension is used by Database Security Service (DBSS) to audit SQL operations of RDS for PostgreSQL instances. SQL statements retrieved by this extension may be truncated because each record is allocated a fixed space of 4 KB. This space includes a retrieved SQL statement along with information such as the database name, username, and SQL type.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot