# Supported Plugins List This document lists the plugins and their versions supported by various versions of UPgSQL. ``` Note: - This page only lists commonly used plugins. For more information on plugin support, you can query within the database using the SELECT * FROM pg_available_extensions; command. - Some plugins need to be added to the shared_preload_libraries parameter before use, otherwise the plugin cannot be created. ``` | Plugin Name | Version 13.4 | Version 12.8 | Version 10.4 | Version 9.6 | Description | |-------------------------|--------------|--------------|--------------|-------------|------------------------------------------------------------------------------------------------| | postgis | 3.0.9 | 2.4.9 | 2.4.9 | 2.4.9 | PostGIS spatial geographic information related extension | | pg_cron | None | 1.4-1 | 1.4-1 | 1.4-1 | Set up scheduled tasks | | pg_partman | None | 4.6.0 | 4.6.0 | 4.6.0 | Extension to automatically create and maintain table partitioning | | pg_pathman | None | 1.5 | 1.5 | 1.5 | High-performance partition table plugin | | mysql_fdw | None | 1.1 | 1.1 | None | Read and write data in MySQL database | | pg_bigm | None | 1.2 | 1.2 | 1.2 | Creates a binary grammar (2-gram) GIN index to speed up the full-text search process | | plproxy | None | 2.10.0 | 2.10.0 | 2.10.0 | Contains CLUSTER and CONNECT modes, can help you access the database in different ways | | pg_hint_plan | None | 1.3.7 | 1.3.6 | 1.2.7 | Through special comment prompts, allowing PostgreSQL to change its established execution plan | | pgaudit | None | 1.4.3 | 1.2.4 | 1.1.4 | Provides detailed session and object audit logging | | pg_repack | None | 1.4.6 | 1.4.6 | 1.4.6 | Online cleanup table space functionality | | hypopg | None | 1.3.2 | 1.3.2 | 1.3.2 | Creating virtual indexes | | sequential_uuids | None | 1.0.2 | 1.0.2 | 1.0.2 | UUID generator | | pg_squeeze | None | 1.4 | 1.4 | 1.4 | Removes unused space from table and optionally sorts tuples according to a specific index | | roaringbitmap | None | 0.2.66 | 0.2.66 | 0.2.66 | Using bitmap functionality, improve query performance. | | aggs_for_arrays | None | 1.3.2 | 1.3.2 | 1.3.2 | Provides extended functions for calculating statistics about numeric arrays. | | dblink | 1.2 | 1.2 | 1.2 | 1.2 | Cross-database operation table | | btree_gin | 1.3 | 1.3 | 1.2 | 1.0 | Provides an example of a GIN operator class that implements B-tree equivalent behavior for various data types and all enum types | | btree_gist | 1.5 | 1.5 | 1.5 | 1.2 | Provides an example of a GiST operator class that implements B-tree equivalent behavior for various data types and all enum types | | chkpass | None | None | 1.0 | 1.0 | Implements a data type used to store encrypted passwords | | citext | 1.6 | 1.6 | 1.4 | 1.3 | Provides a case-insensitive string type | | cube | 1.4 | 1.4 | 1.2 | 1.2 | Provides a data type for representing multidimensional cubes | | dict_int | 1.0 | 1.0 | 1.0 | 1.0 | Example of an additional full-text search dictionary template | | earthdistance | 1.1 | 1.1 | 1.1 | 1.1 | Provides two different methods to calculate the great-circle distance on the earth's surface | | fuzzystrmatch | 1.1 | 1.1 | 1.1 | 1.1 | Decide the similarity and distance between strings | | hstore | 1.6 | 1.6 | 1.4 | 1.4 | Stores key-value pairs in a single PostgreSQL value | | intagg | 1.1 | 1.1 | 1.1 | 1.1 | Provides an integer aggregator and an enumerator | | intarray | 1.3 | 1.2 | 1.2 | 1.2 | Provides some useful functions and operators to manipulate non-empty integer arrays | | isn | 1.2 | 1.2 | 1.1 | 1.1 | Validates input against a hardcoded prefix list and is also used to concatenate numbers in output | | ltree | 1.2 | 1.1 | 1.1 | 1.1 | Used to represent labels stored in a hierarchical tree-like data structure | | pg_buffercache | 1.3 | 1.3 | 1.3 | 1.2 | Provides a way to check shared buffer in real time | | pg_freespacemap | 1.2 | 1.2 | 1.2 | 1.1 | Check free space map (FSM) | | pg_prewarm | 1.2 | 1.2 | 1.1 | 1.1 | Provides a convenient way to load data into the OS buffer or PostgreSQL buffer | | pg_stat_statements | 1.8 | 1.7 | 1.5 | 1.4 | Provides a way to track execution statistics for all SQL statements executed by the server | | pg_trgm | 1.5 | 1.4 | 1.3 | 1.3 | Provides functions and operators for determining similarity of alphanumeric text, and supports quickly searching for similar strings with index operator classes | | pgcrypto | 1.3 | 1.3 | 1.3 | 1.3 | Provides cryptographic functions for PostgreSQL | | pgrowlocks | 1.2 | 1.2 | 1.2 | 1.2 | Provides a function to display row locking information of a specified table | | pgstattuple | 1.5 | 1.5 | 1.5 | 1.4 | Provides various functions to obtain tuple-level statistics | | plpgsql | 1.0 | 1.0 | 1.0 | 1.0 | Provides SQL processing language | | postgis_sfcgal | 3.1.4 | None | 3.1.4 | None | PostGIS SFCGAL spatial geographic information related extension | | postgis_tiger_geocoder | 2.4.9 | 2.4.9 | 2.4.9 | 2.4.9 | PostGIS TIGER data spatial geographic information related extension | | postgis_topology | 2.4.9 | 2.4.9 | 2.4.9 | 2.4.9 | PostGIS topology data spatial geographic information related extension | | postgres_fdw | 1.0 | 1.0 | 1.0 | 1.0 | Cross-database operation table | | rum | None | 1.3 | 1.3 | 1.3 | High speed full text search | | sslinfo | None | None | 1.2 | None | Provides information about the SSL certificate provided by the current client | | tablefunc | 1.0 | 1.0 | 1.0 | 1.0 | Includes multiple return table functions | | tsm_system_rows | 1.0 | 1.0 | 1.0 | 1.0 | Provides table sampling method SYSTEM_ROWS | | tsm_system_time | 1.0 | 1.0 | 1.0 | 1.0 | Provides table sampling method SYSTEM_TIME | | unaccent | 1.1 | 1.1 | 1.1 | 1.1 | Text search dictionary, which removes accents (additional characters) from lexemes | | zhparser | None | 2.1 | 2.1 | 2.1 | Chinese full text search | | postgreml | 2.6.0 | 2.6.0 | None | None | PostgreSQL AI plugin | | pgvector | 0.4.4 | 0.4.4 | None | None | Open source vector similarity search for PostgreSQL |