Export ASH Report
PMP4PG allows you to generate and export a complete ASH report as a standalone HTML file. The exported report captures all the analysis panels for the selected time window and can be shared, archived or reviewed offline without access to the platform.
Generating the Report
Step 1 — Select the Time Window
Before generating the report, set the time window you want to analyze:
- Select a sliding window (last 15 min, 30 min, 1h, 2h, 4h, 8h)
- Or zoom into a specific interval on the Activity Timeline
The report will cover exactly the period displayed in the viewer.
{screenshot: ash-report-time-window-selection}
Step 2 — Click Export
Click the Export ASH Report button in the top-right area of the ASH Viewer.
{screenshot: ash-export-button}
The backend generates the report from the stored ASH samples for the selected period.
Step 3 — Download the HTML File
The browser downloads the generated HTML file automatically:
ash-report_pg-prod-01_2025-01-15_14h00-16h00.html
The filename includes the server name and the time range covered.
Report Contents
The exported HTML file is fully self-contained — all styles, data and charts are embedded. No internet connection or platform access is required to view it.
The report includes:
| Section | Content |
|---|---|
| Report Header | Server name, time range, generation timestamp, PostgreSQL version |
| Activity Timeline | Static chart of session activity over the period |
| Top SQL | Top 10 queries by executions, total time and average time |
| Top Wait Events | Wait event distribution table and chart |
| Session States | Session state breakdown |
| Top Dimensions | Top users, applications, databases |
| Lock Contention | Blocking session pairs observed during the period |
{screenshot: ash-report-html-preview}
Use Cases
| Use Case | How ASH Report Helps |
|---|---|
| Post-incident review | Share a precise record of what was happening during an incident |
| Performance audit | Provide a DBA with a time-bounded activity snapshot |
| Capacity planning meeting | Attach an ASH report to illustrate workload patterns |
| Change validation | Compare ASH reports before and after a deployment |
| Archive | Store point-in-time activity snapshots for compliance or reference |