PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
neon	1.9	Neon-specific statistics and Local File Cache metrics for Neon Postgres computes.	STAT	Apache-2.0	C	14–18	23k
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_qualstats	2.1.4	An extension collecting statistics about quals	STAT	BSD-3-Clause	C	14–18	340
pg_profile	4.16	PostgreSQL load profile repository and report builder	STAT	BSD-2-Clause	C	14–18	312
pg_stat_kcache	2.3.2	Kernel statistics gathering	STAT	BSD-3-Clause	C	14–18	277
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
pgmonitor	2.2.0	Collector-friendly metric views and background refresh worker	STAT	Apache-2.0	C	14–18	93
gg_tables_tracking	1.0	Greengage relation-size change tracking for monitoring and maintenance.	STAT	Apache-2.0	C	—	84
gg_wait_sampling	1.1	Greengage wait-event sampling with history and query attribution.	STAT	Apache-2.0	C	—	84
bg_mon	—	Background worker for monitoring PostgreSQL	STAT	MIT	C	10–18	75
pg_store_plans	1.10	track plan statistics of all SQL statements executed	STAT	BSD-3-Clause	C	14–18	69
pgnodemx	2.0.1	Capture node OS metrics via SQL queries	STAT	Apache-2.0	C	14–18	55
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_track_optimizer	0.9.2	Track planning decisions in comparison with execution reality	STAT	MIT	C	17–18	33
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
pg_meminfo	1.0	Backend memory and process usage inspection from SQL.	STAT	MIT	C	—	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
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_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
pgmeminfo	1.0.0	show memory usage	STAT	MIT	C	14–18	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
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
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

neon

1.9

Neon-specific statistics and Local File Cache metrics for Neon Postgres computes.

14–18

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