Alternatives to AWR Report

William Ivanski
William Ivanski
  • Updated

There is a number of tools, extensions and other features that EDB provides in place of Oracle's Automatic Workload Repository (AWR) reports.

PEM - Postgres Enterprise Manager provides features targeted to administration, monitoring and tuning of Postgres databases.

EDB also provides an extension called edb_wait_states which adds a background worker which collects and stores, for every session, the wait events the session is waiting on. For more details about the edb_wait_states extension, please check here. The data gathered by the edb_wait_states can then be viewed in PEM graphical user interface through the Performance Diagnostic Dashboard.

Is also possible to take advantage of the data gathered by edb_wait_states using EDB's Postgres Workload Report also known as PWR. PWR is a Python-based tool, that works in concert with Lasso used for building PostgreSQL workload reports in HTML, Markdown, DOCX, and PDF format. These reports mimic the reports provided by the Automatic Workload Repository (AWR) reporting tool from Oracle.

The EDB Postgres Advanced Server also provides a feature called DRITA - Dynamic Runtime Instrumentation Tools Architecture, which is able to compare performance through multiple snapshots. The data gathered by DRITA can then be visualized through PEM System Wait Dashboard.

DRITA is also able to generate performance reports, similar to Oracle's AWR reports, through the edbreport(...) function as you can see here.

Was this article helpful?

0 out of 0 found this helpful