pg_stat_statements, pg_stat_monitor, pg_qualstats, hypopg, and other Postgres extensions for monitoring and query stats. Ranked by GitHub stars.
PostgreSQL Workload Analyser-core
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.
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.
An extension collecting statistics about quals
PostgreSQL load profile repository and report builder
PostgreSQL load profile repository and report builder
Kernel statistics gathering
show query plans of all currently running SQL statements
show query plans of all currently running SQL statements
active session history
sampling based statistics of wait events
EnterpriseDB system statistics for PostgreSQL
track plan statistics of all SQL statements executed
track plan statistics of all SQL statements executed
Capture node OS metrics via SQL queries
Track settings changes
Small PostgreSQL background worker to report whether a node is a replication master or standby
Small PostgreSQL background worker to report whether a node is a replication master or standby
Visualise database pages in ascii code
Normalized, friendlier system catalog for PostgreSQL
Log all the queries that reference a particular column
Log all the queries that reference a particular column
show details on toasted datums
Provide SQL interface to logs
easily jump into a visual plan UI for any SQL query
easily jump into a visual plan UI for any SQL query
Provides a means for logging execution plans of slow statements automatically
Provides a means for logging execution plans of slow statements automatically
inspect the contents of database pages at a low level
examine the free space map (FSM)
track planning and execution statistics of all SQL statements executed
track planning and execution statistics of all SQL statements executed
examine the visibility map (VM) and page-level visibility info
examine the visibility map (VM) and page-level visibility info
functions to inspect contents of PostgreSQL Write-Ahead Log
functions to inspect contents of PostgreSQL Write-Ahead Log
Monitoring extensions expose Postgres internals for performance analysis — query-level execution stats (pg_stat_statements, pg_stat_monitor), filesystem cache reads (pg_stat_kcache), predicate selectivity (pg_qualstats), wait events (pg_wait_sampling), buffer-pool contents (pg_buffercache), and hypothetical indexes for what-if analysis (hypopg). Together they're the foundation of any serious Postgres tuning effort and the data source for tools like PoWA, pganalyze, Datadog's Postgres integration, and AWS RDS Performance Insights.
Always enable pg_stat_statements — it's effectively required for any production Postgres deployment, surfaces the queries consuming the most time, and has near-zero overhead. Add pg_stat_monitor when you need time-bucketed query stats with histograms (Percona's enhanced replacement for pg_stat_statements). Add hypopg when you want to test an index without actually creating it — invaluable on large tables where CREATE INDEX takes hours. Skip the more niche stat extensions (pg_qualstats, pg_stat_kcache) until you have a specific performance problem that needs deeper instrumentation — they add overhead and noise to monitoring dashboards.
1bench is a modern GUI client for PostgreSQL — install extensions, write queries, and inspect schemas without leaving the IDE.
Try 1bench for PostgreSQL