Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
67 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_show_plans | 2.1.8 | show query plans of all currently running SQL statements | STAT | PostgreSQL | C | 14–18 | 208 |
| pgsentinel | 1.4.2 | active session history | STAT | PostgreSQL | C | 14–18 | 190 |
| pg_wait_sampling | 1.1.11 | sampling based statistics of wait events | STAT | PostgreSQL | C | 14–18 | 180 |
| system_stats | 4.1 | EnterpriseDB system statistics for PostgreSQL | STAT | PostgreSQL | C | 14–18 | 179 |
| pg_query_state | 1.2 | Tool for query progress monitoring in PostgreSQL | STAT | PostgreSQL | C | 10–18 | 160 |
| opm_core | 2.6 | Central module of the OPM suite | STAT | PostgreSQL | C | — | 146 |
| pg_statviz | 1.2 | Capture PostgreSQL statistics snapshots for time-series analysis and visualization | STAT | PostgreSQL | SQL | 14–18 | 108 |
| powa | 5.3.0 | PostgreSQL Workload Analyser-core | STAT | PostgreSQL | PLpgSQL | 14–18 | 75 |
| pg_track_settings | 2.1.2 | Track settings changes | STAT | PostgreSQL | SQL | 14–18 | 55 |
| dsef | 2024.4.9 | DiffStats and ExplainFull: detailed SQL reports for third party help & support | STAT | PostgreSQL | SQL | — | 52 |
| pg_stat_plans | 2.1.0 | Track per-plan call counts, execution times, and example EXPLAIN texts. | STAT | PostgreSQL | C | 16–18 | 51 |
| bgw_replstatus | 1.0.8 | Small PostgreSQL background worker to report whether a node is a replication master or standby | STAT | PostgreSQL | C | 14–18 | 34 |
| pg_stat_log | 0.1 | Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. | STAT | PostgreSQL | C | 18 | 27 |
| pgtelemetry | 1.7 | Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics. | STAT | PostgreSQL | SQL | 10–17 | 27 |
| pg_relusage | 0.0.1 | Log all the queries that reference a particular column | STAT | PostgreSQL | C | 14–18 | 22 |
| pg_backtrace | 1.0 | Show backtrace for errors and signals | STAT | PostgreSQL | C | — | 19 |
| pgsampler | 1.0 | Experimental PostgreSQL background worker that collects time-series status and performance metrics. | STAT | PostgreSQL | C | — | 19 |
| pg_sampletolog | 2.0.0 | Samples statements or whole transactions into PostgreSQL logs through executor and utility hooks. | STAT | PostgreSQL | C | 10–11 | 18 |
| pg_logging | 0.2 | Captures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions. | STAT | PostgreSQL | C | 10–11 | 15 |
| pg_sortstats | 0.0.1 | Collect per-query sort statistics and estimate required work_mem | STAT | PostgreSQL | C | — | 13 |
| 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 |
| 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 |
| 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_logqueryid | 0.0.1 | Logs pg_stat_statements query IDs alongside auto_explain output. | STAT | PostgreSQL | C | 10–18 | 6 |
| pg_queryid | 0.0.1 | Compute configurable external query fingerprints for PostgreSQL | STAT | PostgreSQL | C | 14–18 | 6 |
| querymem | 1.0 | pgEdge Labs: The querymem Postgres extension for estimating query memory usage | STAT | PostgreSQL | C | — | 6 |
| pg_track_slow_queries | 1.0 | Tracks slow queries and their execution plans | STAT | PostgreSQL | C | 10–18 | 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 |
| 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 |
| toastinfo | 1.7 | show details on toasted datums | STAT | PostgreSQL | C | 14–18 | 3 |
| 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_log | 1.0.0 | displays log content from SQL | STAT | PostgreSQL | 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 |
| 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 |
| pg_plan_guard | 1.1 | Detect drift from approved PostgreSQL 19 plan-advice baselines | STAT | PostgreSQL | PLpgSQL | 19 | 1 |
| pg_stat_errors | 1.2 | Cluster-wide error-class counters with a bounded sample of recent errors. | STAT | PostgreSQL | C | — | 1 |
| xl_global_views | 0.0.1 | Creates global pgxl_ views over Postgres-XL nodes based on pg_ views. | STAT | PostgreSQL | SQL | — | 1 |
| auto_explain | - | Provides a means for logging execution plans of slow statements automatically | STAT | PostgreSQL | C | 14–18 | |
| logfmt | 1.0.0 | logfmt log collector | STAT | PostgreSQL | SQL | — |