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.

tbase_gts_tools · TBase helpers for inspecting transaction global timestamps and heap-page tuple metadata. · 1.0 · Administration · Unknown · C · Not packagedgp_debug_numsegments · Get or set the default number of segments used when creating tables. · 1.0 · Administration · Apache-2.0 · C · Not packagedgp_distribution_policy · Check table distribution policy in a Greenplum-family cluster. · 1.0 · Administration · Apache-2.0 · C · Not packagedgp_toolkit · Administrative views and functions for Greenplum-family databases. · 1.6 · Administration · Apache-2.0 · C · Not packagedreject_partition_fullscan · Reject queries that scan every partition without pruning. · 1.0 · Administration · Apache-2.0 · C · Not packageddbdev · In-database client for installing packages from the database.dev registry. · 0.0.5 · Administration · Apache-2.0 · SQL · Not packagedsr_plan · Planner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates. · 1.2 · Administration · PostgreSQL · C · Not packagedptrack · Tracks changed PostgreSQL blocks for incremental backup using a shared-memory map and core storage hooks. · 2.4 · Administration · PostgreSQL · C · Not packagedpg_check · Provides basic integrity checks for data files. · 0.1.0 · Administration · BSD-3-Clause · C · Not packagedpg_keeper · Background-worker based clustering module for monitoring streaming replication, changing synchronous replication mode and promoting a standby on failure. · 2.0 · Administration · PostgreSQL · C · Not packagednextgres_idcp · NEXTGRES in-database connection pool extension for PostgreSQL. · 0.1.0 · Administration · NEXTGRES · C · Not packagedpg_healer · Proof-of-concept extension for automatically repairing PostgreSQL data corruption · 1.0 · Administration · PostgreSQL · C · Not packagedpg_dbms_stats · Statistics management extension for stabilizing PostgreSQL execution plans using fixed statistics. · 14.0 · Administration · BSD-3-Clause · C · Not packagedrecursively_delete · Recursively delete rows and their foreign-key dependents · 0.1.5 · Administration · MIT · SQL · Not packagedpg_pgbouncer · Runs and manages external PgBouncer processes from a PostgreSQL background worker through a pgrx extension. · 0.0.0 · Administration · MIT · Rust · Not packagedpgespresso · Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL · 1.2 · Administration · PostgreSQL · C · Not packagedpg_dtm · Pluggable distributed transaction manager using shared global snapshots · 1.0 · Administration · Unknown · C · Not packagedpg_start_sql · runs SQL statement at instance start · 1.0 · Administration · PostgreSQL · C · Not packagedpgraft · Raft consensus, leader election, and replicated key-value state · 2.0.0 · Administration · MIT · C · Not packagedpg_index_stats · Create extended statistics on an index manually or automatically · 0.2 · Administration · MIT · C · Not packagedpgbouncer_wrapper · Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw · 1.2.2 · Administration · MIT · SQL · Not packagedpg_quota · Enforce soft per-role disk-space quotas with background workers · 1.0 · Administration · PostgreSQL · C · Not packagedpgextmgr · pgrx extension manager and hook framework for registering, ordering, enabling, and disabling PostgreSQL extension plugins. · 0.0.0 · Administration · MIT · Rust · Not packagedpgx_show_hooks · Lists the in-process addresses of PostgreSQL hook functions and PL/pgSQL hook callbacks. · 0.0.3 · Administration · MIT · Rust · Not packagedconnection_limits · Enforce connection quotas by user, database, source IP or hostname, including combined rules. · 1.0.0 · Administration · BSD-2-Clause · C · Not packagedpg_sage · Provides a preload C DBA agent extension and a newer standalone Go monitoring and guarded-action sidecar. · 0.5.0 · Administration · AGPL-3.0 · C · Not packagedpginstall · PostgreSQL extension installer that hooks CREATE EXTENSION to fetch and install extension archives. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_subtrans_infos · Inspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps. · 1.0 · Administration · PostgreSQL · C · Not packagedautopex · Event-trigger extension that invokes Pex to automatically download and build PostgreSQL extensions when CREATE EXTENSION is run. · 0 · Administration · Unknown · C · Not packagedpg_remote_exec · Executes shell commands from SQL and optionally returns their standard output. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_replica · Consensus-driven automatic failover for PostgreSQL · 0.7.2 · Administration · AGPL-3.0-only · Rust · Not packagedpg_timeout · PostgreSQL background-worker extension for terminating idle database sessions. · 1.0 · Administration · PostgreSQL · C · Not packagedpggit · Git-like version control for PostgreSQL schemas · 0.1.3 · Administration · MIT · SQL · Not packagedfasttrun · Optimezed fasttruncate extension for 1C:Enterprise 8 · 2.0 · Administration · Unknown · C · Not packagedgarbagemap · A simple, pluggable background worker for PostgreSQL, walking over WAL · 1.0 · Administration · Unknown · C · Not packagedpg_bman · PostgreSQL hot-backup tooling with remote full/incremental backup and archive-log helpers. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_cgroup · Provides SQL-callable functions to create, configure, and attach processes to Linux cgroups. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_mentor · pg_mentor - manage query parameters · 0.1 · Administration · MIT · C · Not packagedpg_safer_settings · Functions and mechanisms for handling PostgreSQL settings more safely. · 1.0.0 · Administration · PostgreSQL · SQL · Not packagedpg_safer_settings_table_dependent_extension · A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. · forever · Administration · Unknown · SQL · Not packagedpg_safer_settings_table_dependent_subextension · A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. · monover · Administration · Unknown · SQL · Not packagedpgfr_control · Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record. · 2.28.1 · Administration · Unknown · SQL · Not packageddbpatch · PostgreSQL database patch change management extension · 1.3.0 · Administration · BSD-3-Clause · SQL · Not packagedddl_versioning · DDL object versioning with event triggers for tables, indexes, functions, and views. · 1.0 · Administration · GPL-3.0 · SQL · Not packageddont_drop_db · Prevents DROP DATABASE for databases listed in the dont_drop_db.list setting. · 1.0 · Administration · Unknown · C · Not packagedpg_bofh · Rejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. · 0.0.1 · Administration · PostgreSQL · C · Not packagedpg_exclusive_backup · Compatibility functions for exclusive-style physical backup on PostgreSQL 15 or later. · 1.0 · Administration · Unknown · C · Not packagedpg_wal_budget · PostgreSQL extension that observes and enforces WAL generation against configurable budgets by policy scope. · 0.3.0 · Administration · Apache-2.0 · Rust · Not packagedpgmoneta_ext · Server-side block and delta-backup helpers for pgmoneta. · 0.1.1 · Administration · BSD-3-Clause · C · Not packagedwalreader · SQL functions for reading and inspecting PostgreSQL WAL records. · 1.0 · Administration · Unknown · C · Not packagedpacman_agent · PACMAN is a Postgres Autonomous Cluster Manager · 0.1.0 · Administration · Apache-2.0 · Go · Not packagedpg_fk_indexer · Automatically creates indexes for newly defined foreign-key columns. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_query_settings · Module that dynamically set queries parameters based on their queryid · 0.1 · Administration · Unknown · C · Not packagedfilenode_map_inspect · Check and examine pg_filenode.map files · 0.1 · Administration · Unknown · C · Not packagedlogging · Administrative C function to enable or disable logging mode on relations. · 0.1 · Administration · PostgreSQL · C · Not packagedpg_control_priority · Controls scheduling priorities (nice values) of PostgreSQL server processes. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_fuck_block · C extension for reading all tuples from a relation block · 1.0 · Administration · Unknown · C · Not packagedpg_show_vm · pg show vm displays the visibility map data for a specified relation, including its corresponding indexes and partitions. · 1.0 · Administration · Unknown · C · Not packagedscrub · Background worker that scans heaps, B-tree indexes, TOAST data, page structure, and checksums for corruption. · 1.0 · Administration · PostgreSQL · C · Not packagedtrunkfingerprint · Computes comparable fingerprints of PostgreSQL database structure and optionally data. · 1.3.0 · Administration · PostgreSQL · SQL · Not packagedautoreindex · Shared-preload background-worker extension that scans for bloated indexes and performs concurrent reindexing work in the background. · 1.0 · Administration · Unknown · C · Not packagedcost_guard · Planner-hook guard that rejects statements whose estimated cost exceeds a configured threshold. · 1.0 · Administration · Unknown · C · Not packagededb_foreignkeyconstraintmanager · Manage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server · 1.0 · Administration · Unknown · SQL · Not packagedefm_extension · SQL interface for EDB Failover Manager cluster management · 1.1 · Administration · PostgreSQL · C · Not packagedextrema · PostgreSQL extension to control resource usage of other extensions' bgworkers · 1.0 · Administration · Unknown · C · Not packagedpg_block_if_slow · Abort queries that are taking too long based on EXPLAIN estimates. · 1.0 · Administration · Unknown · C · Not packagedpg_catalog_get_defs · Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. · 0.1.0 · Administration · BSD-3-Clause · SQL · Not packagedpg_checkdestroy · check sql drop&delete&truncate table · 1.0 · Administration · Unknown · C · Not packagedpg_connlimit · Limits per-role connection counts from filesystem configuration without catalog access. · 1.0 · Administration · BSD-2-Clause · C · Not packagedpg_coredump · Easier core dump collection for PostgreSQL · 1.0 · Administration · Unknown · C · Not packagedpg_dirty_hands · Provides functions to freeze individual heap tuples, including an unlogged variant. · 1.0 · Administration · Unknown · C · Not packagedpg_lock_pool · Wait on a PostgreSQL advisory lock pool · 0.0.1 · Administration · PostgreSQL · SQL · Not packagedpg_pageinspect_plus · Decode heap tuple data obtained with PostgreSQL pageinspect helpers · 1.0 · Administration · BSD-3-Clause · C · Not packagedpg_promoter · pg promoter is simplified clustering module based on bgworker. · 1.0 · Administration · Unknown · C · Not packagedpg_set_level · trigger action for SET statement · 0.0.1 · Administration · PostgreSQL · C · Not packagedpg_toastinspect · Low-level inspection of TOAST chunk identifiers, sizes, and stored values. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_visibilitymap · Inspect relation visibility-map bits on historical PostgreSQL releases. · 1.0 · Administration · Unknown · C · Not packagedpgxc_dns · PostgreSQL-XC coordinator DNS views and weighting functions for BIND SDB load balancing and failover. · 1.0 · Administration · PostgreSQL · C · Not packagedtrack_renames · Event-trigger function that forwards PostgreSQL object rename details to a configurable callback. · 0.1 · Administration · PostgreSQL · C · Not packagedvacuum_utils · SQL functions for inspecting VACUUM and ANALYZE thresholds and activity and for invoking table maintenance. · 0.1.0 · Administration · PostgreSQL · SQL · Not packagedautofailover · C extension exposing autofailover functions for role and WAL status checks, promotion, and synchronous replication setting changes. · 1.0 · Administration · Unknown · C · Not packagedbuffercache_tools · Inspect and manipulate PostgreSQL buffer cache entries for relations, forks, databases, and tablespaces. · 1.0 · Administration · Unknown · C · Not packagedconstr_name_unif · Uniforms the names of constraints on base tables. · 1.0.1 · Administration · MIT · SQL · Not packagedconstraint_uniform · This is an extension for uniforming the names of base table constraints. · 1.0.0 · Administration · MIT · SQL · Not packagedextension_drop · Run custom commands when an extension is dropped. · 0.1.1 · Administration · PostgreSQL · SQL · Not packagedforbid_truncate · Preload hook extension that rejects TRUNCATE commands. · 1.0 · Administration · PostgreSQL · C · Not packagedmvtbl · Easily move tables around tablespaces · 0.0.2 · Administration · PostgreSQL · SQL · Not packagednon_truncate · Disables TRUNCATE by raising an error from a ProcessUtility hook · 1.0 · Administration · Unknown · C · Not packagedpg_data_retention · PostgreSQL background-worker extension that applies table data retention policies. · 0.0.0 · Administration · MIT · Rust · Not packagedpg_decode_infomask · PostgreSQL 9.6 C functions that decode heap tuple infomask and infomask2 hint bits into queryable fields. · 0.1 · Administration · PostgreSQL · C · Not packagedpg_dropcache · Invalidate PostgreSQL shared_buffers cache for a database or relation · 1.0.0 · Administration · PostgreSQL · C · Not packagedpg_frozen · Exposes a frozen(tid) function that explains if a tuple has been frozen · 0.0.1 · Administration · Unknown · C · Not packagedpg_global_catalog · PostgreSQL global catalog · 0.0.1 · Administration · PostgreSQL · C · Not packagedpg_misc_functions · Administrative test functions for backend errors, PANIC, crashes, and failover exercises. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_nowhere · A PostgreSQL extension to disallow UPDATE and DELETE queries without a WHERE clause. · 0.1 · Administration · Public Domain · C · Not packagedpg_outrider · Dynamically launches a background worker that extends a relation when its free-space watermark is crossed. · 1.0 · Administration · Unknown · C · Not packagedpg_promise_guard · Catalog-only checks for schema guarantees that are no longer enforced · 0.2.0 · Administration · PostgreSQL · SQL · Not packagedpg_recyclebin · Intercepts DROP TABLE and TRUNCATE to retain recoverable table data and metadata in a recycle-bin schema. · 0.1.0 · Administration · MIT · Rust · Not packagedpg_reject_truncate · Rejects or prevents TRUNCATE operations in PostgreSQL. · 1.0 · Administration · Unknown · C · Not packagedpg_rlimit · setrlimit/getrlimit functions · 1.0 · Administration · BSD-3-Clause · C · Not packagedpg_sats · Per-role query metering and optional enforcement using satoshi-denominated balances. · 0.1.0 · Administration · MIT · C · Not packagedpg_setpriority · Get or change Unix scheduling priority for PostgreSQL processes · 1.0 · Administration · Unknown · C · Not packagedpg_toastutils · TOAST inspection utils for postgres · 1.0 · Administration · PostgreSQL · C · Not packagedpgds · dynamic statistics · 0.0.1 · Administration · PostgreSQL · C · Not packagedplsh_mtb · A PostgreSQL multi-tenant backup controller implemented with PL/SH and an installed Korn shell command. · 1.0 · Administration · PostgreSQL · Shell · Not packagedshowenv · Show environment variables for a backend · 1.0 · Administration · Apache-2.0 · C · Not packagedalohadb_pool · AlohaDB Built-in Connection Pooling · 1.0 · Administration · MIT · C · Not packagedalohadb_scale · AlohaDB Scale - scale-to-zero management · 1.0 · Administration · MIT · C · Not packagedapg_plan_mgmt · Amazon Aurora PostgreSQL Query Plan Management extension for managed plan baselines. · 3.0 · Administration · Unknown · C · Not packagedapgunit · No-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases. · 1.0 · Administration · Unknown · C · Not packagedcheck_updates · Trigger functions to allow/deny certain type of table updates · 1.0.1 · Administration · PostgreSQL · SQL · Not packageddebug_funcs · Debugging and benchmark functions for PostgreSQL buffer and relation locks. · 1.0 · Administration · Unknown · C · Not packagededb_cloneschema · Local and cross-database schema cloning for EPAS. · Administration · Proprietary · Unknown · Not packagededb_pg_tuner · Resource and workload analysis with PostgreSQL tuning recommendations. · 1.3.2 · Administration · Proprietary · Unknown · Not packagedflow_control · Amazon RDS for PostgreSQL extension that throttles writes in Multi-AZ DB clusters to reduce replica lag. · 1.0 · Administration · Unknown · C · Not packagedgbdchecks · Database health-check functions and views for bloat, locks, query statistics, and privileges. · 1.1 · Administration · GPL-3.0 · SQL · Not packagedgevel · Index-inspection functions for GiST, GIN, SP-GiST, B-tree, and BRIN indexes. · 1.1 · Administration · GPL-2.0 · C · Not packagedgoogle_plan_management · Preview AlloyDB extension for tracking, approving, denying, and consistently selecting query plans. · Administration · Unknown · C · Not packagedgp_internal_tools · Different internal tools for Greenplum · 1.0.0 · Administration · Apache-2.0 · C · Not packagedhypostats · Dump and load pg_statistic rows as JSON for statistics experiments. · 0.0.0 · Administration · MIT · Rust · Not packagedmansueli-function_vc · In database version control for postgres functions · 1.0.1 · Administration · Unknown · SQL · Not packagedmyext · A useful and a flexible pattern for reloading postgres SQL extensions without losing data in extension-managed tables. · noop · Administration · Unknown · Shell · Not packagedparallel_clone · Preloaded EPAS worker used by parallel schema cloning. · Administration · Proprietary · Unknown · Not packagedpg_adm · A PostgreSQL extension providing some administrative tools. · 0.0.1 · Administration · GPL-3.0 · SQL · Not packagedpg_concurrency_control · Concurrency control plug-in for Alibaba Cloud ApsaraDB RDS PostgreSQL · 1.0 · Administration · Unknown · C · Not packagedpg_decode_record · Hacky extension to extract SQL from WAL INSERT records; Originally from https://github.com/rjuju · 0.0.1 · Administration · Unknown · C · Not packagedpg_force_unlogged_create_table · force CREATE TABLE to create UNLOGGED tables · 1.0 · Administration · Unknown · C · Not packagedpg_isolate · Assign PostgreSQL backends to Linux cgroups for resource isolation · 1.0 · Administration · MIT · C · Not packagedpg_nice · Lower the I/O scheduling priority of the current PostgreSQL backend with Linux ionice · 0.0.1 · Administration · MIT · C · Not packagedpg_parapet · Hooks that can require WHERE on UPDATE and DELETE and restrict TRUNCATE to superusers. · 0.0.0 · Administration · Unknown · Rust · Not packagedpg_protect_columns · A set of postgres functions that allow you to protect columns that should not be updated. · 0.0.2 · Administration · Unknown · SQL · Not packagedpg_query_rules · ProxySQL Query Rules but for PostgreSQL · 0.1.0 · Administration · Unknown · C · Not packagedpg_restore_points · Create, catalog, list, and remove named PostgreSQL restore points. · 1.0 · Administration · Unknown · SQL · Not packagedpg_table_bloat · PostgreSQL extension that estimates table bloat from pg class + pg stats — no pgstattuple required · 0.1.0 · Administration · MIT · Rust · Not packagedpg_viewctl · View dependency management and safe schema evolution utilities · 0.1.0 · Administration · Unknown · Rust · Not packagedpg_wal_recovery · pg recovery is an educational PostgreSQL extension for database recovery · 1.0 · Administration · MIT · C · Not packagedpg_walrus · Automatic max_wal_size tuning based on checkpoint activity · 0.1.0 · Administration · PostgreSQL · Rust · Not packagedpgbully · Bully-algorithm leader election among PostgreSQL nodes · 1.0 · Administration · PostgreSQL · C · Not packagedpgdam · AWS Aurora PostgreSQL provider extension listed as pgdam version 1.7 for Aurora PostgreSQL 16 and 17. · 1.7 · Administration · Unknown · C · Not packagedpgeyes · PL/pgSQL administrative helper extension with a pgeyes() environment check and foreign_db metadata table. · 0.0.2 · Administration · MIT · SQL · Not packagedpgnice · Manage PostgreSQL backend process priorities and resource limits. · 0.0.0 · Administration · MPL-2.0 · Rust · Not packagedpgpodman · Launches and manages container applications from SQL on Crunchy Bridge. · Administration · Unknown · C · Not packagedpgrao · PGRAO Postgres DB Catalog Extension · 1.0.0 · Administration · Unknown · C · Not packagedprobackup_ctl · Inspect and operate pg_probackup catalogs, including filesystem, SFTP, and S3 storage. · 1.0 · Administration · MIT · C · Not packagedquery_advisor · Workload-based index and extended-statistics recommendations. · 1.2.2 · Administration · Proprietary · Unknown · Not packagedraminder-function_vc · In database version control for postgres functions · 2.0.0 · Administration · Unknown · SQL · Not packagedrds_ccl · Alibaba Cloud RDS PostgreSQL SQL throttling extension · 1.3 · Administration · Unknown · C · Not packagedrds_pg_sql_ccl · Huawei Cloud RDS for PostgreSQL kernel extension for limiting total and per-query SQL concurrency. · Administration · Unknown · C · Not packagedrds_server_handler · TencentDB PostgreSQL server maintenance handler extension · 1.0 · Administration · Unknown · C · Not packagedrds_tools · AWS RDS for PostgreSQL administrative functions for engine-version inspection, password-encryption audits, autovacuum diagnostics, and storage monitoring · 1.9 · Administration · Unknown · C · Not packagedresetsequence · functions to reset sequences to values contained in tables · 1.0.0 · Administration · PostgreSQL · C · Not packagedskitch-extension-verify · PL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. · 0.0.7 · Administration · MIT · SQL · Not packagedsoftvisio_admin · Proprietary SQL administration extension for database/role provisioning and cluster-wide extension inventory and updates via dblink. · 1.2.9 · Administration · Proprietary · SQL · Not packagedtblsize_nolock · Functions to calculate relation size without grabbing AccessShareLock on a target relation. · 1.0.0 · Administration · PostgreSQL · C · Not packagedtencentdb_serverless · TencentDB extension for per-database CPU resource isolation in serverless and multi-tenant workloads. · 1.0 · Administration · Unknown · C · Not packagedtencentdb_sql_throttling · TencentDB proprietary preloaded extension for limiting SQL concurrency by normalized SQL text or query ID across primary and read-only nodes. · 1.0 · Administration · Unknown · C · Not packagedtoast · Tutorial 7 TOAST · 1.0 · Administration · Unknown · C · Not packagedtuplock · lock tuples (rows) with a boolean attribute · 1.2.2 · Administration · GPL-3.0 · C · Not packagedx5fix · Low-level Greenplum persistent-filespace catalog and shared-memory repair helper. · 0.1 · Administration · Unknown · C · Not packaged

159 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
resetsequence 1.0.0 functions to reset sequences to values contained in tables ADMIN PostgreSQL C
skitch-extension-verify 0.0.7 PL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. ADMIN MIT SQL
softvisio_admin 1.2.9 Proprietary SQL administration extension for database/role provisioning and cluster-wide extension inventory and updates via dblink. ADMIN Proprietary SQL
tblsize_nolock 1.0.0 Functions to calculate relation size without grabbing AccessShareLock on a target relation. ADMIN PostgreSQL C
tencentdb_serverless 1.0 TencentDB extension for per-database CPU resource isolation in serverless and multi-tenant workloads. ADMIN C 14–18
tencentdb_sql_throttling 1.0 TencentDB proprietary preloaded extension for limiting SQL concurrency by normalized SQL text or query ID across primary and read-only nodes. ADMIN C 14–18
toast 1.0 Tutorial 7 TOAST ADMIN C
tuplock 1.2.2 lock tuples (rows) with a boolean attribute ADMIN GPL-3.0 C
x5fix 0.1 Low-level Greenplum persistent-filespace catalog and shared-memory repair helper. ADMIN C