Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
210 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_repack | 1.5.3 | Reorganize tables in PostgreSQL databases with minimal locks | ADMIN | PostgreSQL | C | 14–18 | 2.3k |
| tbase_gts_tools | 1.0 | TBase helpers for inspecting transaction global timestamps and heap-page tuple metadata. | ADMIN | — | C | — | 1.4k |
| pgautofailover | 2.2 | pg_auto_failover | ADMIN | PostgreSQL | C | 14–18 | 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 |
| pg_squeeze | 1.9.4 | A tool to remove unused space from a relation. | ADMIN | BSD-2-Clause | C | 14–18 | 691 |
| dbdev | 0.0.5 | In-database client for installing packages from the database.dev registry. | ADMIN | Apache-2.0 | SQL | — | 441 |
| pglinter | 2.0.0 | PostgreSQL Linting and Analysis Extension | ADMIN | PostgreSQL | Rust | 14–18 | 170 |
| pg_permissions | 1.4.1 | view object permissions and compare them with the desired state | ADMIN | BSD-2-Clause | SQL | 14–18 | 167 |
| pg_dirtyread | 2.8 | Read dead but unvacuumed rows from table | ADMIN | BSD-3-Clause | C | 14–18 | 165 |
| ddlx | 0.31 | DDL eXtractor functions | ADMIN | PostgreSQL | SQL | 14–18 | 156 |
| safeupdate | 1.5 | Require criteria for UPDATE and DELETE | ADMIN | ISC | C | 14–18 | 153 |
| pgfincore | 1.4.0 | examine and manage the os buffer cache | ADMIN | BSD-3-Clause | C | 14–18 | 111 |
| pg_column_tetris | 0.1.0 | Enforce optimal column alignment to minimize row padding | ADMIN | MIT | SQL | 14–18 | 100 |
| pg_catcheck | 1.6.0 | Diagnosing system catalog corruption | ADMIN | BSD-3-Clause | C | 14–18 | 87 |
| pg_savior | 0.1.0 | Postgres extension to save OOPS mistakes | ADMIN | Apache-2.0 | C | 14–18 | 76 |
| 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 |
| qos | 1.0 | QoS resource governor extension for PostgreSQL sessions and queries | ADMIN | GPL-3.0 | C | 15–18 | 63 |
| pgdd | 0.6.1 | Introspect pg data dictionary via standard SQL | ADMIN | MIT | Rust | 14–18 | 56 |
| 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_rewrite | 2.2 | Tool allows read write to the table during the rewriting | ADMIN | BSD-3-Clause | C | 14–18 | 46 |
| pre_prepare | 0.9 | Pre Prepare your Statement server side | ADMIN | PostgreSQL | C | 14–18 | 46 |
| pg_cheat_funcs | 1.0 | Provides cheat (but useful) functions | ADMIN | PostgreSQL | C | 14–18 | 39 |
| 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 |
| pg_crash | 1.0 | Send random signals to random processes | ADMIN | BSD-3-Clause | C | 14–18 | 34 |
| fio | 1.0 | PostgreSQL File I/O Functions | ADMIN | BSD-3-Clause | C | 14–18 | 33 |
| 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_checksums | 1.3 | Activate/deactivate/verify checksums in offline Postgres clusters | ADMIN | BSD-2-Clause | C | 14–18 | 30 |
| 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_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 |
| pgraft | 2.0.0 | Raft consensus, leader election, and replicated key-value state | ADMIN | MIT | C | 14–18 | 24 |
| prioritize | 1.0.4 | get and set the priority of PostgreSQL backends | ADMIN | PostgreSQL | C | 14–18 | 22 |
| 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 |
| online_advisor | 1.0 | Suggest missing indexes and extended statistics online | ADMIN | PostgreSQL | C | 14–18 | 19 |
| pg_readonly | 1.0.6 | cluster database read only | ADMIN | PostgreSQL | C | 14–18 | 19 |
| pg_strict | 1.0.5 | Prevent dangerous UPDATE and DELETE without WHERE clause | ADMIN | MIT | Rust | 14–18 | 19 |
| 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 |