select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_stat_monitor · The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information. · 2.4.0 · Monitoring · BSD-3-Clause · C · Packagedpg_tracing · Distributed Tracing for PostgreSQL · 0.1.3 · Monitoring · MIT · C · Packagedpg_rusage · Gathering of template plugins for PostgreSQL: background workers, logical replication things, etc. · 1.0 · Monitoring · Unknown · C · Not packagedpg_profile · PostgreSQL load profile repository and report builder · 4.16 · Monitoring · BSD-2-Clause · C · Packagedpg_netstat · pg netstat: network traffic monitor · 0.1.0 · Monitoring · Unknown · Rust · Not packagedpg_prometheus · Prometheus metric sample type and helpers for PostgreSQL. · 0.2.2 · Monitoring · Apache-2.0 · C · Not packagedpg_show_plans · show query plans of all currently running SQL statements · 2.1.8 · Monitoring · PostgreSQL · C · Packagedpgsentinel · active session history · 1.4.2 · Monitoring · PostgreSQL · C · Packagedpg_wait_sampling · sampling based statistics of wait events · 1.1.11 · Monitoring · PostgreSQL · C · Packagedsystem_stats · EnterpriseDB system statistics for PostgreSQL · 4.1 · Monitoring · PostgreSQL · C · Packagedpg_query_state · Tool for query progress monitoring in PostgreSQL · 1.2 · Monitoring · PostgreSQL · C · Not packagedopm_core · Central module of the OPM suite · 2.6 · Monitoring · PostgreSQL · C · Not packagedpg_stat_ch · Export PostgreSQL query telemetry to ClickHouse · 0.4 · Monitoring · Apache-2.0 · C++ · Packagedpg_turret · Capture PostgreSQL logs and export structured events to HTTP, Kafka, or Sentry · 0.0.0 · Monitoring · MIT · Rust · Not packagedpg_statviz · Capture PostgreSQL statistics snapshots for time-series analysis and visualization · 1.2 · Monitoring · PostgreSQL · SQL · Packagedpgfr_record · Server-side PostgreSQL performance flight recorder · 2.29.2 · Monitoring · Apache-2.0 · SQL · Packagedbg_mon · Background worker for monitoring PostgreSQL · Monitoring · MIT · C · Not packagedpowa · PostgreSQL Workload Analyser-core · 5.3.0 · Monitoring · PostgreSQL · PLpgSQL · Packagedpg_track_settings · Track settings changes · 2.1.2 · Monitoring · PostgreSQL · SQL · Packageddsef · DiffStats and ExplainFull: detailed SQL reports for third party help & support · 2024.4.9 · Monitoring · PostgreSQL · SQL · Not packagedpg_stat_plans · Track per-plan call counts, execution times, and example EXPLAIN texts. · 2.1.0 · Monitoring · PostgreSQL · C · Packagedbgw_replstatus · Small PostgreSQL background worker to report whether a node is a replication master or standby · 1.0.8 · Monitoring · PostgreSQL · C · Packagedpg_proctab · PostgreSQL extension to access the OS process table · 2.0.1 · Monitoring · BSD-3-Clause · C · Packagedpg_stat_log · Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. · 0.1 · Monitoring · PostgreSQL · C · Packagedpgtelemetry · Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics. · 1.7 · Monitoring · PostgreSQL · SQL · Not packagedmeta · Normalized, friendlier system catalog for PostgreSQL · 0.4.0 · Monitoring · BSD-2-Clause · SQL · Packagedpg_relusage · Log all the queries that reference a particular column · 0.0.1 · Monitoring · PostgreSQL · C · Packagedpg_backtrace · Show backtrace for errors and signals · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_otel_tracer · Rust based Postgres extension that adds query lifecycle events to OTEL traces. · 0.1.0 · Monitoring · Unknown · Rust · Not packagedpg_stats · Customized statistics views · 1.0 · Monitoring · Unknown · SQL · Not packagedpgsampler · Experimental PostgreSQL background worker that collects time-series status and performance metrics. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_sampletolog · Samples statements or whole transactions into PostgreSQL logs through executor and utility hooks. · 2.0.0 · Monitoring · PostgreSQL · C · Not packagedpg_stat_sysinfo · Query host load, CPU, memory, swap, and disk statistics from PostgreSQL, with optional shared-memory caching. · 0.0.1 · Monitoring · MIT · Rust · Not packagedpg_datasentinel · Observability and activity monitoring extension for PostgreSQL · 1.0 · Monitoring · BSD-3-Clause · C · Packagedpg_logging · Captures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions. · 0.2 · Monitoring · PostgreSQL · C · Not packagedpg_sslstatus · Historical SSL connection-status views for PostgreSQL releases before 9.5. · 1.0 · Monitoring · Unknown · C · Not packagedpgx_trace_hooks · Trace PostgreSQL executor and utility-hook invocations through a preloaded pgrx library · 0.0.0 · Monitoring · MIT · Rust · Not packagedpg_plan_tree_dot · Graphviz DOT rendering of PostgreSQL execution-plan trees. · 1.1 · Monitoring · BSD-3-Clause · C · Not packagedpg_sortstats · Collect per-query sort statistics and estimate required work_mem · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpgtrace · Event-driven query, lock, failure, and latency observability from PostgreSQL executor hooks. · 0.3 · Monitoring · MIT · C · Not packagedcall_graph · Track PostgreSQL function calls automatically and aggregate them into call graphs and optional table-usage statistics. · 1.4 · Monitoring · MIT · C · Not packagedpg_log_statements · Enables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters. · 0.0.2 · Monitoring · PostgreSQL · C · Not packagedpg_log_userqueries · Module to log user queries · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedgeneric_plan · Generate a generic plan for a parameterized SQL statement. · 1.0 · Monitoring · PostgreSQL · SQL · Not packagedlog_functions · Module to log functions · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedmemstat · Memory context statistics for local and instance backends · 1.0 · Monitoring · Unknown · C · Not packagedpg_stat_sql_plans · Track execution statistics by normalized SQL query and plan ID. · 0.2 · Monitoring · PostgreSQL · C · Not packagedpg_subxact_counters · Global counters for PostgreSQL subtransaction activity · 1.0 · Monitoring · PostgreSQL · C · Not packagedconfig_log · custom background worker process to log changes to postgresql.conf to a table · 0.1.7 · Monitoring · PostgreSQL · C · Not packagedpg_octopus · Runs a background worker that periodically connects to configured PostgreSQL nodes and records their health status. · 0.1 · Monitoring · PostgreSQL · C · Not packagedpg_logfebe · log via febe framing protocol to a unix socket · 1.0 · Monitoring · BSD-2-Clause · C · Not packagedpgotel · PostgreSQL extension exposing OpenTelemetry functionality for other extensions. · 1.0 · Monitoring · Apache-2.0 · C++ · Not packagedprogress · progress: query-progress estimation for a patched PostgreSQL 9.3 development branch · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpg_feedback · PostgreSQL extension that generates a report about database usage · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_sqlog · Provide SQL interface to logs · 1.6 · Monitoring · BSD-3-Clause · SQL · Packagedpg_logqueryid · Logs pg_stat_statements query IDs alongside auto_explain output. · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpg_metricus · Sends custom metrics from PL/pgSQL code to socket-based aggregators such as Brubeck or Graphite. · 1.0 · Monitoring · MIT · C · Not packagedpg_queryid · Compute configurable external query fingerprints for PostgreSQL · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedquerymem · pgEdge Labs: The querymem Postgres extension for estimating query memory usage · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_eyes · SQL monitoring functions and views for PostgreSQL database activity · 1.4 · Monitoring · MIT · SQL · Not packagedpg_mon · PostgreSQL extension for query monitoring with execution-time histograms and plan information in a shared view · 1.0 · Monitoring · MIT · C · Not packagedpg_track_slow_queries · Tracks slow queries and their execution plans · 1.0 · Monitoring · PostgreSQL · C · Not packagedtimeit · High-resolution benchmarking of PostgreSQL built-in functions and SQL expressions. · 1.0 · Monitoring · PostgreSQL · C · Not packageddb_info · Functions and views reporting database size, ownership, tablespaces, extensions, and object counts. · 0.2.0 · Monitoring · PostgreSQL · SQL · Not packagedpgx_warnings · PostgreSQL extension that watches and collects all warnings and errors from the PostgreSQL log file and sends notifications to the Telegram channel. · 1.0 · Monitoring · Unknown · C · Not packagedpg_llm_helper · Captures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_memorycontext · Examines PostgreSQL memory context information. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_stat_backtrace · Capture or log C-level stack backtraces of PostgreSQL processes · 1.0.0 · Monitoring · PostgreSQL · C · Packagedtoastinfo · show details on toasted datums · 1.7 · Monitoring · PostgreSQL · C · Packagedpercona_pg_telemetry · Percona telemetry extension for PostgreSQL · 1.2 · Monitoring · MIT · Shell · Not packagedpg_contextdump · Reports allocated-memory statistics for PostgreSQL memory contexts. · 1.0 · Monitoring · Unknown · C · Not packagedpg_dbwa · Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. · 0.3.1 · Monitoring · MIT · SQL · Not packagedpg_get_queryid · get last queryid generated/used by pg_stat_statements for a given backend pid · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_inet_addr · Lists the IPv4 and IPv6 addresses and netmasks assigned to the PostgreSQL server host network interfaces. · 1.0 · Monitoring · BSD-3-Clause · C · Not packagedpg_log · displays log content from SQL · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedpg_metrics · Collects named counters from PostgreSQL backends in shared memory and exposes them through SQL metric functions. · 1.0 · Monitoring · Unknown · C · Not packagedpg_monitoring · Provides a common SQL interface for collecting PostgreSQL replication, table-load and database-load monitoring statistics. · 0.2 · Monitoring · PostgreSQL · SQL · Not packagedpg_procfs · displays /proc data from SQL · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedstat_record · Background-worker snapshot recorder and reporting suite for PostgreSQL server statistics. · 0.4.0 · Monitoring · Unknown · C · Not packagedstatsmgr · C extension that snapshots PostgreSQL cumulative WAL, SLRU, checkpoint, archiver, I/O, and background-writer statistics in dynamic shared memory. · 0.1-alpha · Monitoring · PostgreSQL · C · Not packagedautovacuum_informations · PostgreSQL extension that adds functions for reporting the autovacuum launcher PID and autovacuum worker information. · 1.0 · Monitoring · Unknown · C · Not packagedloginfo · Functions and views for PostgreSQL to query the postgres log · 1.0 · Monitoring · GPL-3.0 · C · Not packagedpg_dbsm · track database size · 0.0.1 · Monitoring · Unknown · C · Not packagedpg_mem_counters · Maintains named total and requests-per-minute counters in PostgreSQL shared memory. · 1.0 · Monitoring · MIT · C · Not packagedpg_plan_guard · Detect drift from approved PostgreSQL 19 plan-advice baselines · 1.1 · Monitoring · PostgreSQL · PLpgSQL · Not packagedpg_stat_errors · Cluster-wide error-class counters with a bounded sample of recent errors. · 1.2 · Monitoring · PostgreSQL · C · Not packagedpg_stat_ssi_failures · Cluster-wide counter for PostgreSQL SSI serialization failures. · 0.1 · Monitoring · Unknown · C · Not packagedpg_stat_usage · track usage statistics of stored procedure calls · 1.0 · Monitoring · BSD-2-Clause · C · Not packagedpg_sweep · Collect PostgreSQL database and table statistics as JSON for monitoring. · 0.0.0 · Monitoring · MIT · Rust · Not packagedpgscale · Background worker exposing PostgreSQL statistics views through a simple HTTP endpoint. · 1.0 · Monitoring · Unknown · C · Not packagedxl_global_views · Creates global pgxl_ views over Postgres-XL nodes based on pg_ views. · 0.0.1 · Monitoring · PostgreSQL · SQL · Not packagedapgcc · No-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases. · 1.0 · Monitoring · Unknown · C · Not packagedaurora_stat_utils · Aurora PostgreSQL statistics utility functions for wait-event reporting. · 1.0 · Monitoring · Unknown · C · Not packagedauto_explain · Provides a means for logging execution plans of slow statements automatically · - · Monitoring · PostgreSQL · C · Packageddventimi@pg_flight_recorder · Server-side flight recorder for PostgreSQL performance monitoring · 2.26.3 · Monitoring · Unknown · SQL · Not packagededb_otel · OpenTelemetry metrics and trace export for PostgreSQL and EDB extensions. · 2.0.0 · Monitoring · Proprietary · Unknown · Not packagededb_stat_monitor · Bucketed query execution statistics for PostgreSQL and EDB Postgres. · 2.1.0 · Monitoring · Proprietary · Unknown · Not packagedlogfmt · logfmt log collector · 1.0.0 · Monitoring · PostgreSQL · SQL · Not packagedmemleak_analyzer · A PostgreSQL extension designed to analyze and localize logical memory leaks inside PostgreSQL backend sessions and background workers. · 1.0 · Monitoring · MIT · C · Not packagedmods_since_analyze · Estimation of number of changed tuples · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedpageinspect · inspect the contents of database pages at a low level · 1.12 · Monitoring · PostgreSQL · C · Packagedpathprobe · PostgreSQL planner path probing extension for planner-aware SQL agents · 1.1 · Monitoring · Unknown · C · Not packagedpg_buffercache · examine the shared buffer cache · 1.5 · Monitoring · PostgreSQL · C · Packagedpg_freespacemap · examine the free space map (FSM) · 1.2 · Monitoring · PostgreSQL · C · Packagedpg_logicalinspect · Logical decoding components inspection · 1.0 · Monitoring · PostgreSQL · C · Packagedpg_logtap · Structured PostgreSQL log capture and delivery to Vector, HTTP, TCP, or files. · 0.3.0 · Monitoring · MIT · Zig · Not packagedpg_microbench · Perf stat-like hardware performance counters for PostgreSQL planner, executor, utility, and SPI query phases using Linux perf_event_open · 1.0 · Monitoring · MIT · C · Not packagedpg_overexplain · Allow EXPLAIN to dump even more details · 1.0 · Monitoring · PostgreSQL · C · Packagedpg_pulse · Active Session History (ASH) for PostgreSQL · 1.0 · Monitoring · Unknown · C · Not packagedpg_stat_conn · Cumulative connection, disconnection, and authentication-failure counts by database and role. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_stat_error · TencentDB provider-managed error statistics extension; version 1.0 is currently listed for PostgreSQL 10-13. · 1.0 · Monitoring · Unknown · C · Not packagedpg_stat_statements · track planning and execution statistics of all SQL statements executed · 1.11 · Monitoring · PostgreSQL · C · Packagedpg_stat_statements2 · Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall · 1.2 · Monitoring · PostgreSQL · C · Not packagedpg_sysload · Expose Linux system load averages from PostgreSQL · 0.0.0 · Monitoring · Unknown · Rust · Not packagedpg_visibility · examine the visibility map (VM) and page-level visibility info · 1.2 · Monitoring · PostgreSQL · C · Packagedpg_walinspect · functions to inspect contents of PostgreSQL Write-Ahead Log · 1.1 · Monitoring · PostgreSQL · C · Packagedpgao · Monitor and analyze PostgreSQL clusters at scale. · 0.1.0 · Monitoring · MIT · Go · Not packagedpgrowlocks · show row-level locking information · 1.2 · Monitoring · PostgreSQL · C · Packagedpgstattuple · show tuple-level statistics · 1.5 · Monitoring · PostgreSQL · C · Packagedplaninstr · Planner hook for measuring PostgreSQL planning time, intended mainly for debugging. · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpr_grapher · Grapher process for OPM · 1.1 · Monitoring · PostgreSQL · JavaScript · Not packagedsslinfo · information about SSL certificates · 1.2 · Monitoring · PostgreSQL · C · Packagedstreaming_lag · A custom background worker process to measure lag in units of time · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedtencentdb_stat · TencentDB provider extension for collecting PostgreSQL QPS statistics. · 1.0 · Monitoring · Unknown · C · Not packagedtencentdb_system_stat · TencentDB extension that exposes per-process CPU and memory usage for PostgreSQL monitoring. · 1.0 · Monitoring · Unknown · C · Not packaged

125 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
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
pg_logtap 0.3.0 Structured PostgreSQL log capture and delivery to Vector, HTTP, TCP, or files. STAT MIT Zig 15–18
pg_microbench 1.0 Perf stat-like hardware performance counters for PostgreSQL planner, executor, utility, and SPI query phases using Linux perf_event_open STAT MIT C
pg_overexplain 1.0 Allow EXPLAIN to dump even more details STAT PostgreSQL C 18
pg_pulse 1.0 Active Session History (ASH) for PostgreSQL STAT C
pg_stat_conn 1.0 Cumulative connection, disconnection, and authentication-failure counts by database and role. STAT PostgreSQL C 15–18
pg_stat_error 1.0 TencentDB provider-managed error statistics extension; version 1.0 is currently listed for PostgreSQL 10-13. STAT C 10–13
pg_stat_statements 1.11 track planning and execution statistics of all SQL statements executed STAT PostgreSQL C 14–18
pg_stat_statements2 1.2 Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall STAT PostgreSQL C
pg_sysload 0.0.0 Expose Linux system load averages from PostgreSQL STAT Rust 11–16
pg_visibility 1.2 examine the visibility map (VM) and page-level visibility info STAT PostgreSQL C 14–18
pg_walinspect 1.1 functions to inspect contents of PostgreSQL Write-Ahead Log STAT PostgreSQL C 15–18
pgao 0.1.0 Monitor and analyze PostgreSQL clusters at scale. STAT MIT Go
pgrowlocks 1.2 show row-level locking information STAT PostgreSQL C 14–18
pgstattuple 1.5 show tuple-level statistics STAT PostgreSQL C 14–18
planinstr 0.0.1 Planner hook for measuring PostgreSQL planning time, intended mainly for debugging. STAT PostgreSQL C
pr_grapher 1.1 Grapher process for OPM STAT PostgreSQL JavaScript
sslinfo 1.2 information about SSL certificates STAT PostgreSQL C 14–18
streaming_lag 0.0.1 A custom background worker process to measure lag in units of time STAT PostgreSQL C
tencentdb_stat 1.0 TencentDB provider extension for collecting PostgreSQL QPS statistics. STAT C 10–14
tencentdb_system_stat 1.0 TencentDB extension that exposes per-process CPU and memory usage for PostgreSQL monitoring. STAT C 11–18