Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
148 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 |
| pg_dirtyread | 2.8 | Read dead but unvacuumed rows from table | ADMIN | BSD-3-Clause | C | 14–18 | 165 |
| 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_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 |
| 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 |
| 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 |
| 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_quota | 1.0 | Enforce soft per-role disk-space quotas with background workers | ADMIN | PostgreSQL | C | — | 17 |
| 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_pathcheck | 0.9.1 | Validate planner Path trees for freed or corrupt memory | ADMIN | MIT | C | 17–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_circuit | 0.1.0 | Runtime observation, warnings and blocking for dangerous SQL statements | ADMIN | Apache-2.0 | C | 16–18 | 12 |
| 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_timeout | 1.0 | PostgreSQL background-worker extension for terminating idle database sessions. | ADMIN | PostgreSQL | C | 10–16 | 10 |
| 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 |