Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
148 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_cgroup | 1.0 | Provides SQL-callable functions to create, configure, and attach processes to Linux cgroups. | ADMIN | PostgreSQL | C | 10 | 8 |
| pg_mentor | 0.1 | pg_mentor - manage query parameters | ADMIN | MIT | C | — | 8 |
| dont_drop_db | 1.0 | Prevents DROP DATABASE for databases listed in the dont_drop_db.list setting. | ADMIN | — | C | 13–18 | 5 |
| 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 |
| pgmoneta_ext | 0.1.1 | Server-side block and delta-backup helpers for pgmoneta. | ADMIN | BSD-3-Clause | C | 14 | 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 |
| 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 |
| 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 |
| 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_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_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_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 |
| 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 |
| 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 |
| forbid_truncate | 1.0 | Preload hook extension that rejects TRUNCATE commands. | ADMIN | PostgreSQL | C | — | 1 |
| non_truncate | 1.0 | Disables TRUNCATE by raising an error from a ProcessUtility hook | ADMIN | — | C | 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_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 |