Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
179 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_get_queryid | 1.0 | get last queryid generated/used by pg_stat_statements for a given backend pid | STAT | PostgreSQL | C | 10–18 | 2 |
| pg_inet_addr | 1.0 | Lists the IPv4 and IPv6 addresses and netmasks assigned to the PostgreSQL server host network interfaces. | STAT | BSD-3-Clause | C | 10–18 | 2 |
| pg_lockwatch | 0.1.0 | Sample blocking chains and score lock-contention risk | STAT | — | Rust | 15–18 | 2 |
| pg_log | 1.0.0 | displays log content from SQL | STAT | PostgreSQL | C | — | 2 |
| pg_login_stat | 1.0 | Per-user and per-database successful and failed authentication counters. | STAT | — | C | 15–17 | 2 |
| pg_metrics | 1.0 | Collects named counters from PostgreSQL backends in shared memory and exposes them through SQL metric functions. | STAT | — | C | — | 2 |
| pg_monitoring | 0.2 | Provides a common SQL interface for collecting PostgreSQL replication, table-load and database-load monitoring statistics. | STAT | PostgreSQL | SQL | 10–18 | 2 |
| pg_procfs | 0.0.1 | displays /proc data from SQL | STAT | PostgreSQL | C | — | 2 |
| pg_querylog | 0.1 | Captures current and recently completed backend queries in shared memory for SQL inspection. | STAT | — | C | 10–12 | 2 |
| resources | 0.1.0 | Linux server resource monitoring views backed by file_fdw PROGRAM foreign tables. | STAT | — | SQL | 10–18 | 2 |
| stat_record | 0.4.0 | Background-worker snapshot recorder and reporting suite for PostgreSQL server statistics. | STAT | — | C | 10–18 | 2 |
| statsmgr | 0.1-alpha | C extension that snapshots PostgreSQL cumulative WAL, SLRU, checkpoint, archiver, I/O, and background-writer statistics in dynamic shared memory. | STAT | PostgreSQL | C | 17–18 | 2 |
| supamonitor | 0.0.6 | Preloaded pgrx query hook that logs query text, query ID, planning time, and execution time as JSON. | STAT | — | Rust | 13–18 | 2 |
| auto_explain_z | 1.0 | Compressed binary execution-plan logging with rotation and offline decoding. | STAT | Apache-2.0 | C | 14–18 | 1 |
| autovacuum_informations | 1.0 | PostgreSQL extension that adds functions for reporting the autovacuum launcher PID and autovacuum worker information. | STAT | — | C | — | 1 |
| dbstat | 0.1 | Collects exact table row counts and modification timing through SQL objects and a companion libpq process. | STAT | MIT | C | 10–18 | 1 |
| loginfo | 1.0 | Functions and views for PostgreSQL to query the postgres log | STAT | GPL-3.0 | C | — | 1 |
| monitoring_role | 0.0.1 | Security-definer monitoring wrappers for a non-privileged role | STAT | WTFPL | SQL | — | 1 |
| pg_dbsm | 0.0.1 | track database size | STAT | — | C | — | 1 |
| pg_mem_counters | 1.0 | Maintains named total and requests-per-minute counters in PostgreSQL shared memory. | STAT | MIT | C | 10–11 | 1 |
| pg_plan_guard | 1.1 | Detect drift from approved PostgreSQL 19 plan-advice baselines | STAT | PostgreSQL | PLpgSQL | 19 | 1 |
| pg_sessions | 1.3 | Tracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory. | STAT | GPL-3.0 | C | — | 1 |
| pg_stat_errors | 1.2 | Cluster-wide error-class counters with a bounded sample of recent errors. | STAT | PostgreSQL | C | — | 1 |
| pg_stat_ssi_failures | 0.1 | Cluster-wide counter for PostgreSQL SSI serialization failures. | STAT | — | C | — | 1 |
| pg_stat_usage | 1.0 | track usage statistics of stored procedure calls | STAT | BSD-2-Clause | C | — | 1 |
| pg_sweep | 0.0.0 | Collect PostgreSQL database and table statistics as JSON for monitoring. | STAT | MIT | Rust | 14–16 | 1 |
| pgscale | 1.0 | Background worker exposing PostgreSQL statistics views through a simple HTTP endpoint. | STAT | — | C | — | 1 |
| streaminglag | 1.0 | SQL helpers that convert WAL LSNs to integers and estimate primary-to-standby streaming replication lag in bytes. | STAT | BSD-2-Clause | SQL | 10–18 | 1 |
| xl_global_views | 0.0.1 | Creates global pgxl_ views over Postgres-XL nodes based on pg_ views. | STAT | PostgreSQL | SQL | — | 1 |
| alohadb_query_store | 1.0 | AlohaDB Query Store and Index Advisor | STAT | MIT | C | — | |
| apgcc | 1.0 | No-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases. | STAT | — | C | — | |
| aurora_stat_utils | 1.0 | Aurora PostgreSQL statistics utility functions for wait-event reporting. | STAT | — | C | 10–18 | |
| auto_explain | - | Provides a means for logging execution plans of slow statements automatically | STAT | PostgreSQL | C | 14–18 | |
| diag_planner | 1.0 | incubator repositries | STAT | — | C | — | |
| dventimi@pg_flight_recorder | 2.26.3 | Server-side flight recorder for PostgreSQL performance monitoring | STAT | — | SQL | — | |
| dventimi@pg_flight_recorder_control | 2.26.3 | Control functions for pg_flight_recorder | STAT | — | SQL | — | |
| dventimi@pg_flight_recorder_reporting | 2.26.3 | Reporting and analysis functions for pg_flight_recorder | STAT | — | SQL | — | |
| edb_otel | 2.0.0 | OpenTelemetry metrics and trace export for PostgreSQL and EDB extensions. | STAT | Proprietary | — | — | |
| edb_stat_monitor | 2.1.0 | Bucketed query execution statistics for PostgreSQL and EDB Postgres. | STAT | Proprietary | — | — | |
| edb_wait_states | 1.6.0 | Persistent sampling of backend wait events and related query context. | STAT | Proprietary | — | — | |
| jessevent@supa_profile | 1.0.0 | Database table and column statistical profiler | STAT | — | SQL | — | |
| logfmt | 1.0.0 | logfmt log collector | STAT | PostgreSQL | SQL | — | |
| memleak_analyzer | 1.0 | A PostgreSQL extension designed to analyze and localize logical memory leaks inside PostgreSQL backend sessions and background workers. | STAT | MIT | C | — | |
| mods_since_analyze | 1.0.0 | Estimation of number of changed tuples | STAT | PostgreSQL | C | — | |
| neon_utils | 1.0 | Monitor Neon Autoscaling compute allocation with num_cpus(). | STAT | — | C | 14–18 | |
| pageinspect | 1.12 | inspect the contents of database pages at a low level | STAT | PostgreSQL | C | 14–18 | |
| pathprobe | 1.1 | PostgreSQL planner path probing extension for planner-aware SQL agents | STAT | — | C | — | |
| pg_buffercache | 1.5 | examine the shared buffer cache | STAT | PostgreSQL | C | 14–18 | |
| pg_freespacemap | 1.2 | examine the free space map (FSM) | STAT | PostgreSQL | C | 14–18 | |
| pg_logicalinspect | 1.0 | Logical decoding components inspection | STAT | PostgreSQL | C | 18 |