PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_stat_monitor	2.4.0	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.	STAT	BSD-3-Clause	C	14–18	588
pg_tracing	0.1.3	Distributed Tracing for PostgreSQL	STAT	MIT	C	14–18	406
pg_rusage	1.0	Gathering of template plugins for PostgreSQL: background workers, logical replication things, etc.	STAT	—	C	—	349
pg_profile	4.16	PostgreSQL load profile repository and report builder	STAT	BSD-2-Clause	C	14–18	312
pg_netstat	0.1.0	pg netstat: network traffic monitor	STAT	—	Rust	—	259
pg_prometheus	0.2.2	Prometheus metric sample type and helpers for PostgreSQL.	STAT	Apache-2.0	C	—	217
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_stat_ch	0.4	Export PostgreSQL query telemetry to ClickHouse	STAT	Apache-2.0	C++	16–18	123
pg_turret	0.0.0	Capture PostgreSQL logs and export structured events to HTTP, Kafka, or Sentry	STAT	MIT	Rust	13–18	121
pg_statviz	1.2	Capture PostgreSQL statistics snapshots for time-series analysis and visualization	STAT	PostgreSQL	SQL	14–18	108
pgfr_record	2.29.2	Server-side PostgreSQL performance flight recorder	STAT	Apache-2.0	SQL	15–18	81
bg_mon	—	Background worker for monitoring PostgreSQL	STAT	MIT	C	10–18	75
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_proctab	2.0.1	PostgreSQL extension to access the OS process table	STAT	BSD-3-Clause	C	14–18	29
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
meta	0.4.0	Normalized, friendlier system catalog for PostgreSQL	STAT	BSD-2-Clause	SQL	14–18	24
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
pg_otel_tracer	0.1.0	Rust based Postgres extension that adds query lifecycle events to OTEL traces.	STAT	—	Rust	—	19
pg_stats	1.0	Customized statistics views	STAT	—	SQL	—	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_stat_sysinfo	0.0.1	Query host load, CPU, memory, swap, and disk statistics from PostgreSQL, with optional shared-memory caching.	STAT	MIT	Rust	14–15	18
pg_datasentinel	1.0	Observability and activity monitoring extension for PostgreSQL	STAT	BSD-3-Clause	C	15–18	17
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_sslstatus	1.0	Historical SSL connection-status views for PostgreSQL releases before 9.5.	STAT	—	C	—	15
pgx_trace_hooks	0.0.0	Trace PostgreSQL executor and utility-hook invocations through a preloaded pgrx library	STAT	MIT	Rust	15	15
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
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_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

2.4.0

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.

Quick links

PostgreSQL Extension Catalogue