PostgreSQL Extension Catalogue

587 extensions found. Clear filters

Name	Version	Description	Category	License	Language	PG Version	Stars
lsm3	1.0	LSM tree index access method based on PostgreSQL B-tree indexes	FEAT	PostgreSQL	C	—	31
pg_healer	1.0	Proof-of-concept extension for automatically repairing PostgreSQL data corruption	ADMIN	PostgreSQL	C	—	31
osm_fdw	4.1.2	Foreign data wrapper for reading OpenStreetMap PBF files	FDW	PostgreSQL	C	10–18	30
pgpcre	0.20190509	Perl Compatible Regular Expression functions	UTIL	PostgreSQL	C	14–18	30
pgproto	0.5.0	Native Protobuf parsing, mutation, indexing, and JSON conversion support	UTIL	PostgreSQL	C	14–18	30
financial	1.0.1	Financial aggregate functions	FUNC	PostgreSQL	C	14–18	29
informix_fdw	0.6.3	Foreign data wrapper for Informix access	FDW	PostgreSQL	C	14–18	29
uint128	1.2.0	Native uint128 type	TYPE	PostgreSQL	C	14–18	29
vectorize_engine	1.0	Vectorized query execution extension for PostgreSQL	OLAP	PostgreSQL	C	—	29
check_access	0.1	Functions and views to facilitate PostgreSQL object access inspection	SEC	PostgreSQL	SQL	10–18	28
pgspider_ext	1.3.0	foreign-data wrapper for remote PGSpider servers	FDW	PostgreSQL	C	15–18	28
tinyint	0.1.1	One-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes.	TYPE	PostgreSQL	C	10	28
argm	1.1.1	argmax, argmin, and anyold aggregate functions	FUNC	PostgreSQL	C	14–18	27
pg_stat_log	0.1	Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.	STAT	PostgreSQL	C	18	27
pgespresso	1.2	Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL	ADMIN	PostgreSQL	C	—	27
pgtelemetry	1.7	Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.	STAT	PostgreSQL	SQL	10–17	27
tsvector2	1.0	Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing.	FTS	PostgreSQL	C	10–13	27
pg_snakeoil	1.4	The PostgreSQL Antivirus	SEC	PostgreSQL	C	14–18	25
faker	0.5.3	Wrapper for the Faker Python library	LANG	PostgreSQL	Python	14–18	24
json_build	1.1.0	C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays.	FUNC	PostgreSQL	C	10–18	24
parray_gin	1.5.0	GIN index operator class and partial-match operators for text arrays	FUNC	PostgreSQL	C	14–18	24
pg_orphaned	1.0	Deal with orphaned files	ADMIN	PostgreSQL	C	14–18	24
pg_query_rewrite	0.0.5	Rewrite SQL statements with a PostgreSQL ProcessUtility hook	ADMIN	PostgreSQL	C	14–18	24
pg_start_sql	1.0	runs SQL statement at instance start	ADMIN	PostgreSQL	C	—	24
pg_ttl_index	3.0.0	Automatic data expiration with TTL indexes	FEAT	PostgreSQL	C	15–18	24
pgauditlogtofile	1.8.5	pgAudit addon to redirect audit log to an independent file	SEC	PostgreSQL	C	14–18	24
bignum	0.8.0	Unlimited precision integers for PostgreSQL	TYPE	PostgreSQL	C	10–18	23
pg_relusage	0.0.1	Log all the queries that reference a particular column	STAT	PostgreSQL	C	14–18	22
pg_shared_plans	0.0.1	Proof-of-concept shared-memory execution-plan cache for PostgreSQL	FEAT	PostgreSQL	C	12–17	22
prioritize	1.0.4	get and set the priority of PostgreSQL backends	ADMIN	PostgreSQL	C	14–18	22
column_encrypt	4.0	Transparent column-level encryption with encrypted_text and encrypted_bytea types	SEC	PostgreSQL	C	14–18	21
pg_message_queue	0.2.1	Listen/Notify-based PostgreSQL message queue extension	FEAT	PostgreSQL	SQL	10–18	21
plxslt	0.20140221	XSLT procedural language for PostgreSQL	LANG	PostgreSQL	C	14–18	20
online_advisor	1.0	Suggest missing indexes and extended statistics online	ADMIN	PostgreSQL	C	14–18	19
pg_backtrace	1.0	Show backtrace for errors and signals	STAT	PostgreSQL	C	—	19
pg_readonly	1.0.6	cluster database read only	ADMIN	PostgreSQL	C	14–18	19
pgsampler	1.0	Experimental PostgreSQL background worker that collects time-series status and performance metrics.	STAT	PostgreSQL	C	—	19
re2	0.4.1	ClickHouse-compatible regex functions using RE2	UTIL	PostgreSQL	C++	16–18	19
pg_sampletolog	2.0.0	Samples statements or whole transactions into PostgreSQL logs through executor and utility hooks.	STAT	PostgreSQL	C	10–11	18
pgpyml	0.3.1	Run scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers.	RAG	PostgreSQL	Python	—	18
pg_quota	1.0	Enforce soft per-role disk-space quotas with background workers	ADMIN	PostgreSQL	C	—	17
pg_tsparser	1.0	Parser for PostgreSQL text search	FTS	PostgreSQL	C	—	17
pgtt_rsl	2.0.0	Provide Oracle/DB2-style global temporary tables using unlogged tables, row-level security, views, and a cleanup worker	SIM	PostgreSQL	C	10–18	17
pg_doc_store	0.2.1	Provides a JSONB document-store API with full-text search.	FEAT	PostgreSQL	SQL	10–18	15
pg_logging	0.2	Captures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions.	STAT	PostgreSQL	C	10–11	15
varint	0.1.0	A signed and unsigned 64 bit integer encoding scheme that saves disk space	TYPE	PostgreSQL	C	—	15
open_pg_tde	2.4.0	Transparent data encryption for upstream PostgreSQL using the tde_heap access method, including tables, indexes, TOAST, WAL, and temporary files.	SEC	PostgreSQL	C	16–18	14
pg_dispatch	0.1.5	Asynchronous SQL dispatcher built on pg_cron	TIME	PostgreSQL	SQL	14–18	14
crockford	0.8.34	Crockford Base32 encoded unsigned integer data types	TYPE	PostgreSQL	C	11	13
griddb_fdw	1.2	GridDB Foreign Data Wrapper for PostgreSQL	FDW	PostgreSQL	C	13–17	13

Quick links

PostgreSQL Extension Catalogue