Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
179 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pgx_trace_hooks | 0.0.0 | Trace PostgreSQL executor and utility-hook invocations through a preloaded pgrx library | STAT | MIT | Rust | 15 | 15 |
| statsd | 0.2.0 | C client functions for sending counters, gauges, and timings to StatsD over UDP. | STAT | BSD-3-Clause | C | 10–18 | 14 |
| explanation | 0.3.0 | EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree. | STAT | BSD-3-Clause | SQL | 10–14 | 13 |
| pg_plan_tree_dot | 1.1 | Graphviz DOT rendering of PostgreSQL execution-plan trees. | STAT | BSD-3-Clause | C | 10–12 | 13 |
| pg_sortstats | 0.0.1 | Collect per-query sort statistics and estimate required work_mem | STAT | PostgreSQL | C | — | 13 |
| pgexporter_ext | 0.3.1 | Expose additional operating-system and host metrics for pgexporter. | STAT | BSD-3-Clause | C | 13–18 | 13 |
| pgtrace | 0.3 | Event-driven query, lock, failure, and latency observability from PostgreSQL executor hooks. | STAT | MIT | C | 15–16 | 13 |
| call_graph | 1.4 | Track PostgreSQL function calls automatically and aggregate them into call graphs and optional table-usage statistics. | STAT | MIT | C | — | 12 |
| pg_grab_statement | 1.0 | Record detailed SQL statements from successfully committed transactions. | STAT | GPL-2.0 | C | 10–18 | 12 |
| pg_log_statements | 0.0.2 | Enables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters. | STAT | PostgreSQL | C | 10–16 | 12 |
| pg_log_userqueries | 1.0.0 | Module to log user queries | STAT | PostgreSQL | C | — | 12 |
| generic_plan | 1.0 | Generate a generic plan for a parameterized SQL statement. | STAT | PostgreSQL | SQL | — | 11 |
| log_functions | 1.0.0 | Module to log functions | STAT | PostgreSQL | C | — | 10 |
| memstat | 1.0 | Memory context statistics for local and instance backends | STAT | — | C | — | 10 |
| pg_stat_sql_plans | 0.2 | Track execution statistics by normalized SQL query and plan ID. | STAT | PostgreSQL | C | 14–18 | 10 |
| pg_subxact_counters | 1.0 | Global counters for PostgreSQL subtransaction activity | STAT | PostgreSQL | C | 13–16 | 10 |
| config_log | 0.1.7 | custom background worker process to log changes to postgresql.conf to a table | STAT | PostgreSQL | C | 10–18 | 9 |
| pg_octopus | 0.1 | Runs a background worker that periodically connects to configured PostgreSQL nodes and records their health status. | STAT | PostgreSQL | C | 10–18 | 9 |
| pg_stat_insights | 3.0 | Query planning/execution statistics with replication, index, trend, and contention analysis. | STAT | MIT | C | 16–18 | 9 |
| query_recorder | 1.0.1 | query_recorder: record executed SQL queries to rotating files for later analysis or replay | STAT | BSD-2-Clause | C | — | 9 |
| pg_logfebe | 1.0 | log via febe framing protocol to a unix socket | STAT | BSD-2-Clause | C | — | 8 |
| pgotel | 1.0 | PostgreSQL extension exposing OpenTelemetry functionality for other extensions. | STAT | Apache-2.0 | C++ | — | 8 |
| progress | 0.0.1 | progress: query-progress estimation for a patched PostgreSQL 9.3 development branch | STAT | PostgreSQL | C | — | 8 |
| pg_feedback | 1.0 | PostgreSQL extension that generates a report about database usage | STAT | PostgreSQL | C | — | 7 |
| pg_session_stats | 0.0.1 | Records per-session and parallel-worker CPU, process status, and I/O data into an external SQLite database. | STAT | GPL-3.0 | C | 12 | 7 |
| pg_shmemviz | 0.1 | Capture shared-memory snapshots for offline structural visualization | STAT | GPL-2.0-or-later | C | 20 | 7 |
| pg_sqlog | 1.6 | Provide SQL interface to logs | STAT | BSD-3-Clause | SQL | 14–18 | 7 |
| pg_logqueryid | 0.0.1 | Logs pg_stat_statements query IDs alongside auto_explain output. | STAT | PostgreSQL | C | 10–18 | 6 |
| pg_metricus | 1.0 | Sends custom metrics from PL/pgSQL code to socket-based aggregators such as Brubeck or Graphite. | STAT | MIT | C | — | 6 |
| 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 |
| explain_ui | 0.0.2 | easily jump into a visual plan UI for any SQL query | STAT | — | Rust | 14–18 | 5 |
| 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 |
| pg_stat_backtrace | 1.0.0 | Capture or log C-level stack backtraces of PostgreSQL processes | STAT | PostgreSQL | C | 14–18 | 3 |
| supa_agent_trace | 0.1.0 | A browser extension and agent for Supabase | STAT | MIT | SQL | — | 3 |
| toastinfo | 1.7 | show details on toasted datums | STAT | PostgreSQL | C | 14–18 | 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 |