select open change scope Open full search

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

Extensions / Monitoring

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.

pgext.cloud · Source code · Website · License text · Control file · PGXN

Overview

Packagepg_stat_monitor
Version2.4.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_stat_monitor
Stars588
Latest commit2026-08-26
Latest release2026-05-13
Catalogue updated2026-09-19

Related extensions

See also

pg_profilePostgreSQL load profile repository and report builder
pg_wait_samplingsampling based statistics of wait events
pgsentinelactive session history
pg_datasentinelObservability and activity monitoring extension for PostgreSQL
powaPostgreSQL Workload Analyser-core
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
pg_store_planstrack plan statistics of all SQL statements executed
pg_stat_plansTrack per-plan call counts, execution times, and example EXPLAIN texts.
pg_track_settingsTrack settings changes
pg_track_optimizerTrack planning decisions in comparison with execution reality