Skip to main content

Generate an AWR Report

An AWR report in PMP4PG is generated by selecting a begin snapshot and an end snapshot for a specific server. The report covers all activity that occurred between those two snapshots.

Accessing the AWR Viewer​

From the Global Dashboard or Server Detail page, click AWR Viewer for the server you want to analyze.

You can also navigate to AWR Viewer from the top menu and select your server using the server selector.

{screenshot: awr-viewer-main-page}

Selecting the Report Range​

Step 1 — Select the Server​

Use the server selector dropdown to choose the PostgreSQL instance you want to report on.

{screenshot: awr-server-selector}

Step 2 — Choose the Begin Snapshot​

The snapshot selector displays all available snapshots for the selected server, listed with:

  • Snapshot ID — sequential number
  • Date and Time — when the snapshot was taken
  • Interval — duration since the previous snapshot

Select the Begin Snapshot (the starting point of your report period).

{screenshot: awr-begin-snapshot-selector}

Step 3 — Choose the End Snapshot​

Select the End Snapshot (the end point of your report period). The end snapshot must be later than the begin snapshot.

{screenshot: awr-end-snapshot-selector}

tip

For a standard 30-minute workload report, select two consecutive snapshots. For a longer analysis (e.g., peak hours from 09:00 to 12:00), select snapshots 6 intervals apart.

Step 4 — Generate the Report​

Click Generate Report. The backend computes all deltas between the two selected snapshots and renders the full report.

{screenshot: awr-generate-button}

Report Header​

Once generated, the report opens on the page with a header summarizing the report parameters:

FieldDescription
ServerHostname and PostgreSQL version
Begin SnapshotID, date and time
End SnapshotID, date and time
Elapsed TimeDuration covered by the report
DB TimeTotal database time (sum of all active session time)
Generated AtReport generation timestamp

{screenshot: awr-report-header}

Report Navigation​

The AWR report is organized into sections, accessible via a Table of Contents at the top of the report:

{screenshot: awr-table-of-contents}

Snapshot Availability​

Snapshots are created every 30 minutes automatically by the PMP4PG backend. The first snapshot for a server is created 30 minutes after the agent starts sending data.

If no snapshots are available for a server, the snapshot selectors will be empty. Wait for the backend to generate at least two snapshots before using the AWR Viewer.

Next Steps​