Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
133 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| filenode_map_inspect | 0.1 | Check and examine pg_filenode.map files | ADMIN | — | C | 10–18 | 3 |
| 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 |
| extrema | 1.0 | PostgreSQL extension to control resource usage of other extensions' bgworkers | ADMIN | — | C | — | 2 |
| pg_checkdestroy | 1.0 | check sql drop&delete&truncate table | ADMIN | — | C | — | 2 |
| pg_coredump | 1.0 | Easier core dump collection for PostgreSQL | 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_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 |
| 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_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_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_promise_guard | 0.2.0 | Catalog-only checks for schema guarantees that are no longer enforced | ADMIN | PostgreSQL | SQL | 13–19 | 1 |
| pg_reject_truncate | 1.0 | Rejects or prevents TRUNCATE operations in PostgreSQL. | ADMIN | — | C | — | 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 |
| adminpack | 2.1 | administrative functions for PostgreSQL | ADMIN | PostgreSQL | C | 14–16 | |
| 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 | |
| check_updates | 1.0.1 | Trigger functions to allow/deny certain type of table updates | ADMIN | PostgreSQL | SQL | — | |
| debug_funcs | 1.0 | Debugging and benchmark functions for PostgreSQL buffer and relation locks. | ADMIN | — | C | — | |
| edb_pg_tuner | 1.3.2 | Resource and workload analysis with PostgreSQL tuning recommendations. | ADMIN | Proprietary | — | — | |
| flow_control | 1.0 | Amazon RDS for PostgreSQL extension that throttles writes in Multi-AZ DB clusters to reduce replica lag. | ADMIN | — | C | 13–18 | |
| lo | 1.1 | Large Object maintenance | ADMIN | PostgreSQL | C | 14–18 |