Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
210 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| connection_limits | 1.0.0 | Enforce connection quotas by user, database, source IP or hostname, including combined rules. | ADMIN | BSD-2-Clause | C | 10–18 | 13 |
| pg_pathcheck | 0.9.1 | Validate planner Path trees for freed or corrupt memory | ADMIN | MIT | C | 17–18 | 13 |
| pg_sage | 0.5.0 | Provides a preload C DBA agent extension and a newer standalone Go monitoring and guarded-action sidecar. | ADMIN | AGPL-3.0 | C | 14–18 | 13 |
| pginstall | 1.0 | PostgreSQL extension installer that hooks CREATE EXTENSION to fetch and install extension archives. | ADMIN | PostgreSQL | C | — | 13 |
| pg_circuit | 0.1.0 | Runtime observation, warnings and blocking for dangerous SQL statements | ADMIN | Apache-2.0 | C | 16–18 | 12 |
| pg_subtrans_infos | 1.0 | Inspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps. | ADMIN | PostgreSQL | C | 10–13 | 11 |
| autopex | 0 | Event-trigger extension that invokes Pex to automatically download and build PostgreSQL extensions when CREATE EXTENSION is run. | ADMIN | — | C | 10–18 | 10 |
| pg_remote_exec | 1.0 | Executes shell commands from SQL and optionally returns their standard output. | ADMIN | PostgreSQL | C | 12–16 | 10 |
| pg_replica | 0.7.2 | Consensus-driven automatic failover for PostgreSQL | ADMIN | AGPL-3.0-only | Rust | 18 | 10 |
| pg_timeout | 1.0 | PostgreSQL background-worker extension for terminating idle database sessions. | ADMIN | PostgreSQL | C | 10–16 | 10 |
| pggit | 0.1.3 | Git-like version control for PostgreSQL schemas | ADMIN | MIT | SQL | — | 9 |
| fasttrun | 2.0 | Optimezed fasttruncate extension for 1C:Enterprise 8 | ADMIN | — | C | — | 8 |
| garbagemap | 1.0 | A simple, pluggable background worker for PostgreSQL, walking over WAL | ADMIN | — | C | — | 8 |
| 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_mentor | 0.1 | pg_mentor - manage query parameters | ADMIN | MIT | C | — | 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_safer_settings_table_dependent_extension | forever | A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. | ADMIN | — | SQL | — | 7 |
| pg_safer_settings_table_dependent_subextension | monover | A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. | ADMIN | — | SQL | — | 7 |
| pgfr_control | 2.28.1 | Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record. | ADMIN | — | SQL | — | 7 |
| dbpatch | 1.3.0 | PostgreSQL database patch change management extension | ADMIN | BSD-3-Clause | SQL | — | 6 |
| ddl_versioning | 1.0 | DDL object versioning with event triggers for tables, indexes, functions, and views. | ADMIN | GPL-3.0 | SQL | 13–18 | 5 |
| 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 |
| pg_wal_budget | 0.3.0 | PostgreSQL extension that observes and enforces WAL generation against configurable budgets by policy scope. | ADMIN | Apache-2.0 | Rust | — | 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 |
| 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 |
| pgelog | 1.0.2 | Extended logging via pseudo-autonomous transactions | ADMIN | PostgreSQL | SQL | 14–18 | 4 |
| cat_tools | 0.3.0 | Tools for interfacing with the PostgreSQL catalog | ADMIN | MIT | SQL | 14–18 | 3 |
| 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 |