select open change scope Open full search

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

Extensions / Monitoring

pg_dbwa

Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots.

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_dbwa
Version0.3.1
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemadbwa
Stars2
Latest commit2016-09-25
Catalogue updated2026-08-30

Related extensions

Requires

dblinkconnect to other PostgreSQL databases from within a database
pg_eyesSQL monitoring functions and views for PostgreSQL database activity
pg_prttn_toolsProvides PL/pgSQL tools for managing inheritance-based partition tables.
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
plpgsqlPL/pgSQL procedural language

See also

pg_stat_statementstrack planning and execution statistics of all SQL statements executed
pg_grab_statementRecord detailed SQL statements from successfully committed transactions.
pg_sessionsTracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory.
pgtelemetryProvides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.
pg_stat_monitorThe 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.
pg_stat_statements2Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall
gbdchecksDatabase health-check functions and views for bloat, locks, query statistics, and privileges.
pg_eyesSQL monitoring functions and views for PostgreSQL database activity
pgmonitorCollector-friendly metric views and background refresh worker
memstatMemory context statistics for local and instance backends