Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
159 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pacman_agent | 0.1.0 | PACMAN is a Postgres Autonomous Cluster Manager | ADMIN | Apache-2.0 | Go | — | 4 |
| pg_fk_indexer | 1.0 | Automatically creates indexes for newly defined foreign-key columns. | ADMIN | PostgreSQL | C | — | 4 |
| pg_query_settings | 0.1 | Module that dynamically set queries parameters based on their queryid | ADMIN | — | C | — | 4 |
| 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 |
| pg_fuck_block | 1.0 | C extension for reading all tuples from a relation block | ADMIN | — | C | — | 3 |
| pg_show_vm | 1.0 | pg show vm displays the visibility map data for a specified relation, including its corresponding indexes and partitions. | ADMIN | — | C | — | 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 |
| autoreindex | 1.0 | Shared-preload background-worker extension that scans for bloated indexes and performs concurrent reindexing work in the background. | ADMIN | — | C | — | 2 |
| cost_guard | 1.0 | Planner-hook guard that rejects statements whose estimated cost exceeds a configured threshold. | ADMIN | — | C | 11–18 | 2 |
| edb_foreignkeyconstraintmanager | 1.0 | Manage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server | ADMIN | — | SQL | — | 2 |
| 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_block_if_slow | 1.0 | Abort queries that are taking too long based on EXPLAIN estimates. | ADMIN | — | C | — | 2 |
| pg_catalog_get_defs | 0.1.0 | Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. | ADMIN | BSD-3-Clause | SQL | — | 2 |
| pg_checkdestroy | 1.0 | check sql drop&delete&truncate table | ADMIN | — | C | — | 2 |
| pg_connlimit | 1.0 | Limits per-role connection counts from filesystem configuration without catalog access. | ADMIN | BSD-2-Clause | C | — | 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_visibilitymap | 1.0 | Inspect relation visibility-map bits on historical PostgreSQL releases. | ADMIN | — | C | — | 2 |
| pgxc_dns | 1.0 | PostgreSQL-XC coordinator DNS views and weighting functions for BIND SDB load balancing and failover. | ADMIN | PostgreSQL | C | — | 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_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 |