select open change scope Open full search

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

Extensions / Monitoring

powa

PostgreSQL Workload Analyser-core

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

Overview

Packagepowa
Version5.3.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typePreloaded
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespowa, pg_stat_statements
Stars75
Latest commit2026-08-16
Latest release2026-08-16
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
btree_gistsupport for indexing common datatypes in GiST

See also

pg_stat_plansTrack per-plan call counts, execution times, and example EXPLAIN texts.
pg_profilePostgreSQL load profile repository and report builder
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
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_store_planstrack plan statistics of all SQL statements executed
pg_track_settingsTrack settings changes
pg_track_optimizerTrack planning decisions in comparison with execution reality
auto_explainProvides a means for logging execution plans of slow statements automatically
pg_show_plansshow query plans of all currently running SQL statements
pg_qualstatsAn extension collecting statistics about quals