Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
135 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_queryid | 0.0.1 | Compute configurable external query fingerprints for PostgreSQL | STAT | PostgreSQL | C | 14–18 | 6 |
| pgsyswatch | 1.0 | Host process, CPU, memory, swap, network, and load statistics exposed through SQL. | STAT | Apache-2.0 | C | — | 6 |
| querymem | 1.0 | pgEdge Labs: The querymem Postgres extension for estimating query memory usage | STAT | PostgreSQL | C | — | 6 |
| pg_eyes | 1.4 | SQL monitoring functions and views for PostgreSQL database activity | STAT | MIT | SQL | 10–18 | 5 |
| pg_mon | 1.0 | PostgreSQL extension for query monitoring with execution-time histograms and plan information in a shared view | STAT | MIT | C | 11–17 | 5 |
| pg_track_slow_queries | 1.0 | Tracks slow queries and their execution plans | STAT | PostgreSQL | C | 10–18 | 5 |
| query_histogram | 1.1 | Collects shared-memory histograms of statement and transaction runtimes through executor and utility hooks. | STAT | BSD-2-Clause | C | — | 5 |
| streamvis_udfs | 1.0 | A logging client and server for self-hosted data logging and visualization | STAT | — | Python | — | 5 |
| timeit | 1.0 | High-resolution benchmarking of PostgreSQL built-in functions and SQL expressions. | STAT | PostgreSQL | C | — | 5 |
| db_info | 0.2.0 | Functions and views reporting database size, ownership, tablespaces, extensions, and object counts. | STAT | PostgreSQL | SQL | 11–18 | 4 |
| pgx_warnings | 1.0 | PostgreSQL extension that watches and collects all warnings and errors from the PostgreSQL log file and sends notifications to the Telegram channel. | STAT | — | C | — | 4 |
| pg_llm_helper | 1.0 | Captures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function. | STAT | PostgreSQL | C | 17 | 3 |
| pg_memorycontext | 1.0 | Examines PostgreSQL memory context information. | STAT | PostgreSQL | C | 10–18 | 3 |
| supa_agent_trace | 0.1.0 | A browser extension and agent for Supabase | STAT | MIT | SQL | — | 3 |
| mv_stats | 0.3.0 | Tracks creation, alteration, refresh, and reset statistics for materialized views. | STAT | — | SQL | 10–18 | 2 |
| percona_pg_telemetry | 1.2 | Percona telemetry extension for PostgreSQL | STAT | MIT | Shell | — | 2 |
| pg_contextdump | 1.0 | Reports allocated-memory statistics for PostgreSQL memory contexts. | STAT | — | C | 11 | 2 |
| pg_dbwa | 0.3.1 | Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. | STAT | MIT | SQL | — | 2 |
| 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 |