Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
159 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| tbase_gts_tools | 1.0 | TBase helpers for inspecting transaction global timestamps and heap-page tuple metadata. | ADMIN | — | C | — | 1.4k |
| gp_debug_numsegments | 1.0 | Get or set the default number of segments used when creating tables. | ADMIN | Apache-2.0 | C | — | 1.4k |
| gp_distribution_policy | 1.0 | Check table distribution policy in a Greenplum-family cluster. | ADMIN | Apache-2.0 | C | — | 1.4k |
| gp_toolkit | 1.6 | Administrative views and functions for Greenplum-family databases. | ADMIN | Apache-2.0 | C | — | 1.4k |
| reject_partition_fullscan | 1.0 | Reject queries that scan every partition without pruning. | ADMIN | Apache-2.0 | C | — | 1.4k |
| dbdev | 0.0.5 | In-database client for installing packages from the database.dev registry. | ADMIN | Apache-2.0 | SQL | — | 441 |
| sr_plan | 1.2 | Planner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates. | ADMIN | PostgreSQL | C | 10–11 | 64 |
| ptrack | 2.4 | Tracks changed PostgreSQL blocks for incremental backup using a shared-memory map and core storage hooks. | ADMIN | PostgreSQL | C | 11–18 | 56 |
| pg_check | 0.1.0 | Provides basic integrity checks for data files. | ADMIN | BSD-3-Clause | C | 10–18 | 52 |
| pg_keeper | 2.0 | Background-worker based clustering module for monitoring streaming replication, changing synchronous replication mode and promoting a standby on failure. | ADMIN | PostgreSQL | C | — | 36 |
| nextgres_idcp | 0.1.0 | NEXTGRES in-database connection pool extension for PostgreSQL. | ADMIN | NEXTGRES | C | 16 | 32 |
| pg_healer | 1.0 | Proof-of-concept extension for automatically repairing PostgreSQL data corruption | ADMIN | PostgreSQL | C | — | 31 |
| pg_dbms_stats | 14.0 | Statistics management extension for stabilizing PostgreSQL execution plans using fixed statistics. | ADMIN | BSD-3-Clause | C | 14 | 30 |
| recursively_delete | 0.1.5 | Recursively delete rows and their foreign-key dependents | ADMIN | MIT | SQL | 10–13 | 29 |
| pg_pgbouncer | 0.0.0 | Runs and manages external PgBouncer processes from a PostgreSQL background worker through a pgrx extension. | ADMIN | MIT | Rust | 16 | 28 |
| pgespresso | 1.2 | Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL | ADMIN | PostgreSQL | C | — | 27 |
| pg_dtm | 1.0 | Pluggable distributed transaction manager using shared global snapshots | ADMIN | — | C | — | 26 |
| pg_start_sql | 1.0 | runs SQL statement at instance start | ADMIN | PostgreSQL | C | — | 24 |
| pgraft | 2.0.0 | Raft consensus, leader election, and replicated key-value state | ADMIN | MIT | C | 14–18 | 24 |
| pg_index_stats | 0.2 | Create extended statistics on an index manually or automatically | ADMIN | MIT | C | — | 21 |
| pgbouncer_wrapper | 1.2.2 | Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw | ADMIN | MIT | SQL | — | 20 |
| pg_quota | 1.0 | Enforce soft per-role disk-space quotas with background workers | ADMIN | PostgreSQL | C | — | 17 |
| pgextmgr | 0.0.0 | pgrx extension manager and hook framework for registering, ordering, enabling, and disabling PostgreSQL extension plugins. | ADMIN | MIT | Rust | 15 | 15 |
| pgx_show_hooks | 0.0.3 | Lists the in-process addresses of PostgreSQL hook functions and PL/pgSQL hook callbacks. | ADMIN | MIT | Rust | 15 | 15 |
| connection_limits | 1.0.0 | Enforce connection quotas by user, database, source IP or hostname, including combined rules. | ADMIN | BSD-2-Clause | C | 10–18 | 13 |
| pg_sage | 0.5.0 | Provides a preload C DBA agent extension and a newer standalone Go monitoring and guarded-action sidecar. | ADMIN | AGPL-3.0 | C | 14–18 | 13 |
| pginstall | 1.0 | PostgreSQL extension installer that hooks CREATE EXTENSION to fetch and install extension archives. | ADMIN | PostgreSQL | C | — | 13 |
| pg_subtrans_infos | 1.0 | Inspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps. | ADMIN | PostgreSQL | C | 10–13 | 11 |
| autopex | 0 | Event-trigger extension that invokes Pex to automatically download and build PostgreSQL extensions when CREATE EXTENSION is run. | ADMIN | — | C | 10–18 | 10 |
| pg_remote_exec | 1.0 | Executes shell commands from SQL and optionally returns their standard output. | ADMIN | PostgreSQL | C | 12–16 | 10 |
| pg_replica | 0.7.2 | Consensus-driven automatic failover for PostgreSQL | ADMIN | AGPL-3.0-only | Rust | 18 | 10 |
| pg_timeout | 1.0 | PostgreSQL background-worker extension for terminating idle database sessions. | ADMIN | PostgreSQL | C | 10–16 | 10 |
| pggit | 0.1.3 | Git-like version control for PostgreSQL schemas | ADMIN | MIT | SQL | — | 9 |
| fasttrun | 2.0 | Optimezed fasttruncate extension for 1C:Enterprise 8 | ADMIN | — | C | — | 8 |
| garbagemap | 1.0 | A simple, pluggable background worker for PostgreSQL, walking over WAL | ADMIN | — | C | — | 8 |
| pg_bman | 1.0 | PostgreSQL hot-backup tooling with remote full/incremental backup and archive-log helpers. | ADMIN | PostgreSQL | C | — | 8 |
| pg_cgroup | 1.0 | Provides SQL-callable functions to create, configure, and attach processes to Linux cgroups. | ADMIN | PostgreSQL | C | 10 | 8 |
| pg_mentor | 0.1 | pg_mentor - manage query parameters | ADMIN | MIT | C | — | 8 |
| pg_safer_settings | 1.0.0 | Functions and mechanisms for handling PostgreSQL settings more safely. | ADMIN | PostgreSQL | SQL | — | 7 |
| pg_safer_settings_table_dependent_extension | forever | A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. | ADMIN | — | SQL | — | 7 |
| pg_safer_settings_table_dependent_subextension | monover | A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. | ADMIN | — | SQL | — | 7 |
| pgfr_control | 2.28.1 | Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record. | ADMIN | — | SQL | — | 7 |
| dbpatch | 1.3.0 | PostgreSQL database patch change management extension | ADMIN | BSD-3-Clause | SQL | — | 6 |
| ddl_versioning | 1.0 | DDL object versioning with event triggers for tables, indexes, functions, and views. | ADMIN | GPL-3.0 | SQL | 13–18 | 5 |
| dont_drop_db | 1.0 | Prevents DROP DATABASE for databases listed in the dont_drop_db.list setting. | ADMIN | — | C | 13–18 | 5 |
| pg_bofh | 0.0.1 | Rejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. | ADMIN | PostgreSQL | C | — | 5 |
| pg_exclusive_backup | 1.0 | Compatibility functions for exclusive-style physical backup on PostgreSQL 15 or later. | ADMIN | — | C | 15–18 | 5 |
| pg_wal_budget | 0.3.0 | PostgreSQL extension that observes and enforces WAL generation against configurable budgets by policy scope. | ADMIN | Apache-2.0 | Rust | — | 5 |
| pgmoneta_ext | 0.1.1 | Server-side block and delta-backup helpers for pgmoneta. | ADMIN | BSD-3-Clause | C | 14 | 5 |
| walreader | 1.0 | SQL functions for reading and inspecting PostgreSQL WAL records. | ADMIN | — | C | — | 5 |