Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
133 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 |
| 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 |
| pglinter | 2.0.0 | PostgreSQL Linting and Analysis Extension | ADMIN | PostgreSQL | Rust | 14–18 | 170 |
| ddlx | 0.31 | DDL eXtractor functions | ADMIN | PostgreSQL | SQL | 14–18 | 156 |
| pg_column_tetris | 0.1.0 | Enforce optimal column alignment to minimize row padding | ADMIN | MIT | SQL | 14–18 | 100 |
| 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 |
| 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 |
| 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_dbms_stats | 14.0 | Statistics management extension for stabilizing PostgreSQL execution plans using fixed statistics. | ADMIN | BSD-3-Clause | C | 14 | 30 |
| 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_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 |
| prioritize | 1.0.4 | get and set the priority of PostgreSQL backends | ADMIN | PostgreSQL | C | 14–18 | 22 |
| 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 |
| 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 |
| 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 |
| 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_drop_events | 0.1.0 | logs transaction ids of drop table, drop column, drop materialized view statements | ADMIN | PostgreSQL | SQL | 14–18 | 7 |
| 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 |
| dbpatch | 1.3.0 | PostgreSQL database patch change management extension | ADMIN | BSD-3-Clause | SQL | — | 6 |
| 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 |
| walreader | 1.0 | SQL functions for reading and inspecting PostgreSQL WAL records. | ADMIN | — | C | — | 5 |
| pg_fk_indexer | 1.0 | Automatically creates indexes for newly defined foreign-key columns. | ADMIN | PostgreSQL | C | — | 4 |
| pgelog | 1.0.2 | Extended logging via pseudo-autonomous transactions | ADMIN | PostgreSQL | SQL | 14–18 | 4 |
| cat_tools | 0.3.0 | Tools for interfacing with the PostgreSQL catalog | ADMIN | MIT | SQL | 14–18 | 3 |