4.4. pgpro_pwr (Workload Reporting) #
pgpro_pwr is designed to discover most resource-intensive activities in your database. This extension is based on Postgres Pro's Statistics Collector views and the pgpro_stats or pg_stat_statements extension.
To build workload reports using pgpro_pwr on a Shardman cluster, perform the following installation:
Install the dblink module and the pgpro_stats extension on each Shardman cluster node.
Install pgpro_pwr compatible with Shardman on each Shardman cluster node as follows:
sudo apt install pgpro-pwr-sdm-14
Complete pgpro_pwr documentation can be found here.