select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_cron · Job scheduler for PostgreSQL · 1.6.8 · Time series · PostgreSQL · C · Packagedpg_background · Run SQL queries in the background · 2.0.2 · Time series · GPL-3.0 · C · Packagedpgrouting · pgRouting Extension · 4.0.2 · Geospatial · GPL-2.0 · C++ · Packagedpointcloud · data type for lidar point clouds · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedpointcloud_postgis · integration for pointcloud LIDAR data and PostGIS geometry data · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedh3 · H3 bindings for PostgreSQL · 4.5.0 · Geospatial · Apache-2.0 · C · Packagedh3_postgis · H3 PostGIS integration · 4.5.0 · Geospatial · Apache-2.0 · C · Packagedogr_fdw · foreign-data wrapper for GIS data access · 1.1.9 · Geospatial · MIT · C · Packagedq3c · q3c sky indexing plugin · 2.0.5 · Geospatial · GPL-2.0 · C · Packagedaddress_standardizer · Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedaddress_standardizer_data_us · Address Standardizer US dataset example · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis · PostGIS geometry and geography spatial types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_raster · PostGIS raster types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_sfcgal · PostGIS SFCGAL functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_tiger_geocoder · PostGIS tiger geocoder and reverse geocoder · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_topology · PostGIS topology spatial types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedvector · vector data type and ivfflat and hnsw access methods · 0.8.6 · AI and vectors · PostgreSQL · C · Packagedpg_partman · Extension to manage partitioned tables by time or ID · 5.5.0 · Analytics · PostgreSQL · C · Packagedpg_strom · PG-Strom - big-data processing acceleration using GPU and NVME · 6.1 · Analytics · PostgreSQL · C · Packagedhypopg · Hypothetical indexes for PostgreSQL · 1.4.3 · Features · PostgreSQL · C · Packagedhll · type for storing hyperloglog data · 2.21 · Features · Apache-2.0 · C++ · Packagedpg_hint_plan · Give PostgreSQL ability to manually force some decisions in execution plans. · 1.8.0 · Features · BSD-3-Clause · C · Packagedjsquery · data type for jsonb inspection · 1.2 · Features · PostgreSQL · C · Packagedpgq · Generic queue for PostgreSQL · 3.5.1 · Features · ISC · C · Packagedpgtap · Unit testing for PostgreSQL · 1.3.4 · Procedural languages · PostgreSQL · C · Packagedpljava · PL/Java procedural language · 1.6.10 · Procedural languages · BSD-3-Clause · Java · Packagedplsh · PL/sh procedural language · 1.20220917 · Procedural languages · MIT · C · Packagedplr · load R interpreter and execute R script from within a database · 8.4.8.6 · Procedural languages · GPL-2.0 · C · Packagedplprofiler · server-side support for profiling PL/pgSQL functions · 4.2.5 · Procedural languages · Artistic-1.0 · C · Packagedpldbgapi · server-side support for debugging PL/pgSQL functions · 1.10 · Procedural languages · Artistic-2.0 · C · Packagedplxslt · XSLT procedural language for PostgreSQL · 0.20140221 · Procedural languages · PostgreSQL · C · Packagedroaringbitmap · support for Roaring Bitmaps · 1.2.0 · Data types · Apache-2.0 · C · Packagedunit · SI units extension · 7.10 · Data types · GPL-2.0 · C · Packagedsemver · Semantic version data type · 0.41.0 · Data types · PostgreSQL · C · Packagedip4r · IPv4/v6 and IPv4/v6 range index type for PostgreSQL · 2.4.3 · Data types · PostgreSQL · C · Packagedprefix · Prefix Range module for PostgreSQL · 1.2.11 · Data types · PostgreSQL · C · Packageddebversion · Debian version number data type · 1.2.0 · Data types · PostgreSQL · SQL · Packagedhttp · HTTP client for PostgreSQL, allows web page retrieval inside the database. · 1.7.2 · Utilities · MIT · C · Packagedicu_ext · Access ICU functions · 1.11.0 · Utilities · PostgreSQL · C · Packagedtopn · type for top-n JSONB · 2.7.1 · Functions and aggregates · AGPL-3.0 · C · Packagedtdigest · Provides tdigest aggregate function. · 1.4.6 · Functions and aggregates · Apache-2.0 · C · Packagedextra_window_functions · Extra Window Functions for PostgreSQL · 1.0 · Functions and aggregates · PostgreSQL · C · Packagedpg_repack · Reorganize tables in PostgreSQL databases with minimal locks · 1.5.3 · Administration · PostgreSQL · C · Packagedpgautofailover · pg_auto_failover · 2.2 · Administration · PostgreSQL · C · Packagedpg_squeeze · A tool to remove unused space from a relation. · 1.9.4 · Administration · BSD-2-Clause · C · Packagedpg_permissions · view object permissions and compare them with the desired state · 1.4.1 · Administration · BSD-2-Clause · SQL · Packagedsafeupdate · Require criteria for UPDATE and DELETE · 1.5 · Administration · ISC · C · Packagedpgfincore · examine and manage the os buffer cache · 1.4.0 · Administration · BSD-3-Clause · C · Packagedpg_catcheck · Diagnosing system catalog corruption · 1.6.0 · Administration · BSD-3-Clause · C · Packagedpg_checksums · Activate/deactivate/verify checksums in offline Postgres clusters · 1.3 · Administration · BSD-2-Clause · C · Packagedprioritize · get and set the priority of PostgreSQL backends · 1.0.4 · Administration · PostgreSQL · C · Packagedpgagent · A PostgreSQL job scheduler · 4.2.3 · Administration · PostgreSQL · C · Packagedpgdisablelogerror · Disable selected SQLSTATE error codes from PostgreSQL server logging. · 1.0 · Administration · PostgreSQL · C · Packagedpgpool_adm · Administrative functions for pgPool · 4.7.2 · Administration · PostgreSQL · C · Packagedpgpool_recovery · recovery functions for pgpool-II for V4.3 · 4.7.2 · Administration · PostgreSQL · C · Packagedpgpool_regclass · replacement for regclass · 4.7.2 · Administration · PostgreSQL · C · Packagedpg_qualstats · An extension collecting statistics about quals · 2.1.4 · Monitoring · BSD-3-Clause · C · Packagedpg_stat_kcache · Kernel statistics gathering · 2.3.2 · Monitoring · BSD-3-Clause · C · Packagedpg_show_plans · show query plans of all currently running SQL statements · 2.1.8 · Monitoring · PostgreSQL · C · Packagedpg_statviz · Capture PostgreSQL statistics snapshots for time-series analysis and visualization · 1.2 · Monitoring · PostgreSQL · SQL · Packagedpowa · PostgreSQL Workload Analyser-core · 5.3.0 · Monitoring · PostgreSQL · PLpgSQL · Packagedpg_track_settings · Track settings changes · 2.1.2 · Monitoring · PostgreSQL · SQL · Packagedpg_stat_plans · Track per-plan call counts, execution times, and example EXPLAIN texts. · 2.1.0 · Monitoring · PostgreSQL · C · Packagedbgw_replstatus · Small PostgreSQL background worker to report whether a node is a replication master or standby · 1.0.8 · Monitoring · PostgreSQL · C · Packagedpg_stat_log · Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. · 0.1 · Monitoring · PostgreSQL · C · Packagedpgaudit · provides auditing functionality · 18.0 · Security · PostgreSQL · C · Packagedpgsodium · Postgres extension for libsodium functions · 3.1.11 · Security · BSD-3-Clause · C · Packagedpgextwlist · PostgreSQL Extension Whitelisting · 1.20 · Security · PostgreSQL · C · Packagedcredcheck · credcheck - postgresql plain text credential checker · 5.0 · Security · MIT · C · Packagedset_user · similar to SET ROLE but with added logging · 4.2.0 · Security · PostgreSQL · C · Packagedpgauditlogtofile · pgAudit addon to redirect audit log to an independent file · 1.8.5 · Security · PostgreSQL · C · Packagedpasswordpolicy · Dynamically configurable PostgreSQL password complexity checks. · 2.0.5 · Security · PostgreSQL · C · Packagedpg_pwhash · Advanced password hashing methods for PostgreSQL · 1.0 · Security · MIT · C · Packagedmysql_fdw · Foreign data wrapper for querying a MySQL server · 2.9.3 · Foreign data wrappers · BSD-3-Clause · C · Packagedoracle_fdw · foreign data wrapper for Oracle access · 2.9.0 · Foreign data wrappers · PostgreSQL · C · Packagedtds_fdw · Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) · 2.0.5 · Foreign data wrappers · PostgreSQL · C · Packagedmongo_fdw · foreign data wrapper for MongoDB access · 5.5.3 · Foreign data wrappers · LGPL-3.0 · C · Packagedsqlite_fdw · SQLite Foreign Data Wrapper · 2.5.0 · Foreign data wrappers · PostgreSQL · C · Packagedmulticorn · Fetch foreign data in Python in your PostgreSQL server. · 3.2 · Foreign data wrappers · PostgreSQL · C · Packageddb2_fdw · foreign data wrapper for DB2 access · 18.2.0 · Foreign data wrappers · PostgreSQL · C · Packagedinformix_fdw · Foreign data wrapper for Informix access · 0.6.3 · Foreign data wrappers · PostgreSQL · C · Packagedpgspider_ext · foreign-data wrapper for remote PGSpider servers · 1.3.0 · Foreign data wrappers · PostgreSQL · C · Packagedorafce · Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS · 4.16.10 · Compatibility · 0BSD · C · Packagedpgmemcache · memcached interface · 2.3.0 · Compatibility · MIT · C · Packagedpgtt · Extension to add Global Temporary Tables feature to PostgreSQL · 4.6 · Compatibility · ISC · C · Packagedplpgsql_wrap · Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. · 1.0 · Compatibility · PostgreSQL · C · Packagedpg_utl_smtp · Oracle UTL_SMTP compatibility extension for PostgreSQL · 1.0.0 · Compatibility · PostgreSQL · SQL · Packagedrepmgr · Replication manager for PostgreSQL · 5.5.0 · Replication and streams · GPL-3.0 · C · Packagedwal2json · Changing data capture in JSON format · 2.6 · Replication and streams · BSD-3-Clause · C · Packagedpglogical · PostgreSQL Logical Replication · 2.4.8 · Replication and streams · PostgreSQL · C · Packagedpglogical_origin · Dummy extension for compatibility when upgrading from Postgres 9.4 · 2.4.7 · Replication and streams · PostgreSQL · C · Packageddecoderbufs · Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format · 3.6.0 · Replication and streams · MIT · C · Packagedpgl_ddl_deploy · automated ddl deployment using pglogical · 2.2.1 · Replication and streams · MIT · C · Packagedpg_fact_loader · build fact tables with Postgres · 2.0.1 · Replication and streams · MIT · C · Packagedpglogical_ticker · Have an accurate view on pglogical replication delay · 1.4.1 · Replication and streams · PostgreSQL · C · Packaged

95 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_statviz 1.2 Capture PostgreSQL statistics snapshots for time-series analysis and visualization STAT PostgreSQL SQL 14–18 108
prefix 1.2.11 Prefix Range module for PostgreSQL TYPE PostgreSQL C 14–18 106
plprofiler 4.2.5 server-side support for profiling PL/pgSQL functions LANG Artistic-1.0 C 14–18 104
pgextwlist 1.20 PostgreSQL Extension Whitelisting SEC PostgreSQL C 14–18 102
pgl_ddl_deploy 2.2.1 automated ddl deployment using pglogical ETL MIT C 14–18 99
pgtt 4.6 Extension to add Global Temporary Tables feature to PostgreSQL SIM ISC C 14–18 99
tdigest 1.4.6 Provides tdigest aggregate function. FUNC Apache-2.0 C 14–18 98
pldbgapi 1.10 server-side support for debugging PL/pgSQL functions LANG Artistic-2.0 C 14–18 94
q3c 2.0.5 q3c sky indexing plugin GIS GPL-2.0 C 14–18 90
pg_catcheck 1.6.0 Diagnosing system catalog corruption ADMIN BSD-3-Clause C 14–18 87
credcheck 5.0 credcheck - postgresql plain text credential checker SEC MIT C 14–18 86
set_user 4.2.0 similar to SET ROLE but with added logging SEC PostgreSQL C 14–18 78
powa 5.3.0 PostgreSQL Workload Analyser-core STAT PostgreSQL PLpgSQL 14–18 75
pg_track_settings 2.1.2 Track settings changes STAT PostgreSQL SQL 14–18 55
pg_stat_plans 2.1.0 Track per-plan call counts, execution times, and example EXPLAIN texts. STAT PostgreSQL C 16–18 51
bgw_replstatus 1.0.8 Small PostgreSQL background worker to report whether a node is a replication master or standby STAT PostgreSQL C 14–18 34
icu_ext 1.11.0 Access ICU functions UTIL PostgreSQL C 14–18 34
db2_fdw 18.2.0 foreign data wrapper for DB2 access FDW PostgreSQL C 14–18 31
extra_window_functions 1.0 Extra Window Functions for PostgreSQL FUNC PostgreSQL C 14–18 31
pg_checksums 1.3 Activate/deactivate/verify checksums in offline Postgres clusters ADMIN BSD-2-Clause C 14–18 30
informix_fdw 0.6.3 Foreign data wrapper for Informix access FDW PostgreSQL C 14–18 29
pgspider_ext 1.3.0 foreign-data wrapper for remote PGSpider servers FDW PostgreSQL C 15–18 28
pg_stat_log 0.1 Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. STAT PostgreSQL C 18 27
pgauditlogtofile 1.8.5 pgAudit addon to redirect audit log to an independent file SEC PostgreSQL C 14–18 24
prioritize 1.0.4 get and set the priority of PostgreSQL backends ADMIN PostgreSQL C 14–18 22
plxslt 0.20140221 XSLT procedural language for PostgreSQL LANG PostgreSQL C 14–18 20
pg_fact_loader 2.0.1 build fact tables with Postgres ETL MIT C 14–18 11
plpgsql_wrap 1.0 Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. SIM PostgreSQL C 14–18 11
address_standardizer 3.6.4 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. GIS GPL-2.0 C 14–18 9
address_standardizer_data_us 3.6.4 Address Standardizer US dataset example GIS GPL-2.0 C 14–18 9
postgis 3.6.4 PostGIS geometry and geography spatial types and functions GIS GPL-2.0 C 14–18 9
postgis_raster 3.6.4 PostGIS raster types and functions GIS GPL-2.0 C 14–18 9
postgis_sfcgal 3.6.4 PostGIS SFCGAL functions GIS GPL-2.0 C 14–18 9
postgis_tiger_geocoder 3.6.4 PostGIS tiger geocoder and reverse geocoder GIS GPL-2.0 C 14–18 9
postgis_topology 3.6.4 PostGIS topology spatial types and functions GIS GPL-2.0 C 14–18 9
pg_utl_smtp 1.0.0 Oracle UTL_SMTP compatibility extension for PostgreSQL SIM PostgreSQL SQL 14–18 6
pglogical_ticker 1.4.1 Have an accurate view on pglogical replication delay ETL PostgreSQL C 14–18 3
passwordpolicy 2.0.5 Dynamically configurable PostgreSQL password complexity checks. SEC PostgreSQL C 14–18 2
pg_pwhash 1.0 Advanced password hashing methods for PostgreSQL SEC MIT C 14–18 2
debversion 1.2.0 Debian version number data type TYPE PostgreSQL SQL 14–18 1
pgagent 4.2.3 A PostgreSQL job scheduler ADMIN PostgreSQL C 14–18
pgdisablelogerror 1.0 Disable selected SQLSTATE error codes from PostgreSQL server logging. ADMIN PostgreSQL C 14–18
pgpool_adm 4.7.2 Administrative functions for pgPool ADMIN PostgreSQL C 14–18
pgpool_recovery 4.7.2 recovery functions for pgpool-II for V4.3 ADMIN PostgreSQL C 14–18
pgpool_regclass 4.7.2 replacement for regclass ADMIN PostgreSQL C 14–18