Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
210 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_cooldown | 0.1 | remove buffered pages for specific relations | ADMIN | Apache-2.0 | C | 14–18 | 2 |
| pg_coredump | 1.0 | Easier core dump collection for PostgreSQL | ADMIN | — | C | — | 2 |
| pg_dirty_hands | 1.0 | Provides functions to freeze individual heap tuples, including an unlogged variant. | ADMIN | — | C | — | 2 |
| pg_lock_pool | 0.0.1 | Wait on a PostgreSQL advisory lock pool | ADMIN | PostgreSQL | SQL | 12–17 | 2 |
| pg_pageinspect_plus | 1.0 | Decode heap tuple data obtained with PostgreSQL pageinspect helpers | ADMIN | BSD-3-Clause | C | 10–18 | 2 |
| pg_promoter | 1.0 | pg promoter is simplified clustering module based on bgworker. | ADMIN | — | C | — | 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 |
| pg_visibilitymap | 1.0 | Inspect relation visibility-map bits on historical PostgreSQL releases. | ADMIN | — | C | — | 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 |
| autofailover | 1.0 | C extension exposing autofailover functions for role and WAL status checks, promotion, and synchronous replication setting changes. | ADMIN | — | C | — | 1 |
| buffercache_tools | 1.0 | Inspect and manipulate PostgreSQL buffer cache entries for relations, forks, databases, and tablespaces. | ADMIN | — | C | — | 1 |
| constr_name_unif | 1.0.1 | Uniforms the names of constraints on base tables. | ADMIN | MIT | SQL | 10–18 | 1 |
| constraint_uniform | 1.0.0 | This is an extension for uniforming the names of base table constraints. | ADMIN | MIT | SQL | — | 1 |
| 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 |
| non_truncate | 1.0 | Disables TRUNCATE by raising an error from a ProcessUtility hook | ADMIN | — | C | 13–18 | 1 |
| pg_data_retention | 0.0.0 | PostgreSQL background-worker extension that applies table data retention policies. | ADMIN | MIT | Rust | 13–18 | 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_frozen | 0.0.1 | Exposes a frozen(tid) function that explains if a tuple has been frozen | ADMIN | — | C | — | 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 |
| pg_misc_functions | 1.0 | Administrative test functions for backend errors, PANIC, crashes, and failover exercises. | ADMIN | PostgreSQL | C | — | 1 |
| pg_nowhere | 0.1 | A PostgreSQL extension to disallow UPDATE and DELETE queries without a WHERE clause. | ADMIN | Public Domain | C | — | 1 |
| pg_outrider | 1.0 | Dynamically launches a background worker that extends a relation when its free-space watermark is crossed. | ADMIN | — | C | — | 1 |
| pg_promise_guard | 0.2.0 | Catalog-only checks for schema guarantees that are no longer enforced | ADMIN | PostgreSQL | SQL | 13–19 | 1 |
| pg_recyclebin | 0.1.0 | Intercepts DROP TABLE and TRUNCATE to retain recoverable table data and metadata in a recycle-bin schema. | ADMIN | MIT | Rust | 14–18 | 1 |
| pg_reject_truncate | 1.0 | Rejects or prevents TRUNCATE operations in PostgreSQL. | ADMIN | — | C | — | 1 |
| pg_rlimit | 1.0 | setrlimit/getrlimit functions | ADMIN | BSD-3-Clause | C | 10–18 | 1 |
| pg_sats | 0.1.0 | Per-role query metering and optional enforcement using satoshi-denominated balances. | ADMIN | MIT | C | 14–18 | 1 |
| pg_setpriority | 1.0 | Get or change Unix scheduling priority for PostgreSQL processes | ADMIN | — | C | — | 1 |
| pg_toastutils | 1.0 | TOAST inspection utils for postgres | ADMIN | PostgreSQL | C | — | 1 |
| pgds | 0.0.1 | dynamic statistics | ADMIN | PostgreSQL | C | — | 1 |
| plsh_mtb | 1.0 | A PostgreSQL multi-tenant backup controller implemented with PL/SH and an installed Korn shell command. | ADMIN | PostgreSQL | Shell | — | 1 |
| showenv | 1.0 | Show environment variables for a backend | ADMIN | Apache-2.0 | C | — | 1 |
| adminpack | 2.1 | administrative functions for PostgreSQL | ADMIN | PostgreSQL | C | 14–16 | |
| alohadb_pool | 1.0 | AlohaDB Built-in Connection Pooling | ADMIN | MIT | C | — | |
| alohadb_scale | 1.0 | AlohaDB Scale - scale-to-zero management | ADMIN | MIT | C | — | |
| amcheck | 1.4 | functions for verifying relation integrity | ADMIN | PostgreSQL | C | 14–18 | |
| apg_plan_mgmt | 3.0 | Amazon Aurora PostgreSQL Query Plan Management extension for managed plan baselines. | ADMIN | — | C | 12–18 | |
| apgunit | 1.0 | No-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases. | ADMIN | — | C | — | |
| basebackup_to_shell | - | adds a custom basebackup target called shell | ADMIN | PostgreSQL | C | 15–18 | |
| basic_archive | - | an example of an archive module | ADMIN | PostgreSQL | C | 15–18 |