Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
74 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 |
| 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 |
| 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 |
| 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_healer | 1.0 | Proof-of-concept extension for automatically repairing PostgreSQL data corruption | ADMIN | PostgreSQL | C | — | 31 |
| 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 |
| 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 |
| 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 |
| 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_bofh | 0.0.1 | Rejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. | ADMIN | PostgreSQL | 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 |
| logging | 0.1 | Administrative C function to enable or disable logging mode on relations. | ADMIN | PostgreSQL | C | — | 3 |
| pg_control_priority | 1.0 | Controls scheduling priorities (nice values) of PostgreSQL server processes. | ADMIN | PostgreSQL | C | 10–18 | 3 |
| scrub | 1.0 | Background worker that scans heaps, B-tree indexes, TOAST data, page structure, and checksums for corruption. | ADMIN | PostgreSQL | C | — | 3 |
| trunkfingerprint | 1.3.0 | Computes comparable fingerprints of PostgreSQL database structure and optionally data. | ADMIN | PostgreSQL | SQL | 10–15 | 3 |
| efm_extension | 1.1 | SQL interface for EDB Failover Manager cluster management | ADMIN | PostgreSQL | C | 14–18 | 2 |
| pg_lock_pool | 0.0.1 | Wait on a PostgreSQL advisory lock pool | ADMIN | PostgreSQL | SQL | 12–17 | 2 |
| pg_set_level | 0.0.1 | trigger action for SET statement | ADMIN | PostgreSQL | C | — | 2 |
| pg_toastinspect | 1.0 | Low-level inspection of TOAST chunk identifiers, sizes, and stored values. | ADMIN | PostgreSQL | C | — | 2 |
| pg_upless | 0.0.3 | Detect Useless UPDATE | ADMIN | PostgreSQL | SQL | 14–18 | 2 |
| pgcozy | 1.0 | Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. | ADMIN | PostgreSQL | SQL | 14–18 | 2 |
| pgxc_dns | 1.0 | PostgreSQL-XC coordinator DNS views and weighting functions for BIND SDB load balancing and failover. | ADMIN | PostgreSQL | C | — | 2 |
| table_log | 0.6.4 | record table modification logs and PITR for table/row | ADMIN | PostgreSQL | C | 14–18 | 2 |
| track_renames | 0.1 | Event-trigger function that forwards PostgreSQL object rename details to a configurable callback. | ADMIN | PostgreSQL | C | 10–18 | 2 |
| vacuum_utils | 0.1.0 | SQL functions for inspecting VACUUM and ANALYZE thresholds and activity and for invoking table maintenance. | ADMIN | PostgreSQL | SQL | 10–18 | 2 |
| extension_drop | 0.1.1 | Run custom commands when an extension is dropped. | ADMIN | PostgreSQL | SQL | — | 1 |
| forbid_truncate | 1.0 | Preload hook extension that rejects TRUNCATE commands. | ADMIN | PostgreSQL | C | — | 1 |
| mvtbl | 0.0.2 | Easily move tables around tablespaces | ADMIN | PostgreSQL | SQL | — | 1 |
| pg_decode_infomask | 0.1 | PostgreSQL 9.6 C functions that decode heap tuple infomask and infomask2 hint bits into queryable fields. | ADMIN | PostgreSQL | C | — | 1 |
| pg_dropcache | 1.0.0 | Invalidate PostgreSQL shared_buffers cache for a database or relation | ADMIN | PostgreSQL | C | 11–16 | 1 |
| pg_global_catalog | 0.0.1 | PostgreSQL global catalog | ADMIN | PostgreSQL | C | — | 1 |
| pg_living_assertions | 0.4.1 | Executable SQL checks with verdict dates and assertion history | ADMIN | PostgreSQL | SQL | 14–18 | 1 |