53.5. Reports #
Before performing instructions from this section, it is recommended to view available profiler graphs.
53.5.1. Building a Report #
Before performing this instruction:
To build a report:
Go to building a report in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Reports generating.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Reports generating.
Specify parameters of the new report (parameters marked with an asterisk are required):
Database: The database for which the report will be built.
Server: The profiler server whose directory contains samples.
Report: The format of the period that the report will cover.
Possible values:
By snapshot: The report will cover the period between two samples.
By time: The report will cover the time period between two dates.
Type.
Possible values:
Standard: Provides the database load statistics for a specified period.
Differential: Provides comparative database load statistics for two specified periods.
Interval or Interval 1 and Interval 2: The period covered by the report.
The period format depends on the value selected in Report:
If you select By snapshot, specify the first and last samples.
If you select By time, specify the start and end date and time.
Click Generate report.
53.5.2. Building a Report Using a Profiler Graph #
You can also build a report when viewing profiler graphs. In this case, the period between two samples cannot be used as the time period that the report will cover.
Before performing this instruction:
To build a report using a graph profiler:
Go to profiler graphs in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler.
From Instance, select the instance.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler.
From Database, select the database.
From Server, select the profiler server.
(Optional) In Period, specify the time period.
If you do not specify a value, the profiler graphs are displayed for the entire time range.
Click Select.
In the top-right corner of the profiler graph, click Select the period for the report.
Click and drag on the profiler graph to select the period for the report.
(Optional) To include comparative database load statistics for two specified periods in the report, click Select another period and repeat step 7.
Click Generate report.
53.5.3. Viewing All Built Reports #
Go to reports in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Reports.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Reports.
The table of reports with the following columns will be displayed:
Instance: The instance where the report is built.
Server: The profiler server whose directory contains samples.
Database: The database for which the report is generated.
Status.
Possible values:
done: The report is built.
pending: The report is being built.
error: An error occurred while building a report.
Period: The period covered by the report.
Execution start and Execution end: The start and end date and time of report building.
User: The user that built the report.
Actions.
For more information about available actions, refer to the corresponding instructions.
53.5.4. Viewing and Downloading a Report #
Go to reports in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Reports.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Reports.
Perform one of the following actions:
To view the report, click
next to it. For more information about the report contents, refer to the official Postgres Pro documentation.
To download the report, in the top-right corner of the page, click Download report.
53.5.5. Deleting a Report #
Important
Deleted reports cannot be restored.
To delete a report:
Go to reports in one of the following ways:
Using the monitoring section:
In the navigation panel, go to Monitoring → Profiler → Reports.
Using the configuration section of an instance:
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Profiler → Reports.
Click
next to the report. Click Delete.