Postgres Workload Report

Postgres Workload Report (PWR) is a Python-based tool used for building PostgreSQL workload reports in HTML, Markdown, DOCX, and PDF mode, mimicking the reports provided by the Automatic Workload Repository (AWR) reporting tool from Oracle.

Using a Postgres connection, you can execute Postgres Workload Report from any machine with access to the server for which you want a report. Postgres Workload Report uses Lasso for collecting data, so Lasso is a prerequisite. The edb-pwr package has an explicit dependency on edb-lasso being installed.

On the Postgres server, you should have edb_wait_states version 1.2 or later installed and loaded. The extension also must be created, preferably on the main database, so the edb_wait_states functions are available for Postgres Workload Report to collect saved snapshot data.

For more information about PWR, see:

• Installing Postgres Workload Report

• Configuring Postgres Workload Report

• Using Postgres Workload Report

• Release notes
  • Postgres Workload Report 1.0.0 release notes
• Installing Postgres Workload Report
• Configuring Postgres Workload Report
  • pwr configuration file
    • input_dir
    • output_dir
    • report_name
    • log_file
    • log_level
    • log_format
    • assets_dir
• Using Postgres Workload Report
  • Prerequisites
  • Source information for reports
  • Example for the execute option
  • Example for the report option