Viewing system reports v9

Suggest edits

You can generate the System Configuration report and Core Usage report for all locally and remotely managed servers. To generate this report, select Management > Reports.

Reports has the following options:

  • Alert History Report (JSON)
  • System Configuration Report (JSON)
  • System Configuration Report (HTML)
  • Core Usage Report (JSON)
  • Core Usage Report (HTML)

Only superusers or the users with the pem_admin role can download the System Configuration or Core Usage reports.

Information in these reports shows the latest probe run time.

Alert History report

The Alert History report provides detailed information about the alerts history at the agent or server level in JSON format.

Select Management > Reports > Alert History Report. From the dialog box, select your options:

  • Agent/Server Name — Select the agents and servers from the list. The Overall System Report option is also available to generate a report for all the registered and active agents and servers.

  • Timeframe — Select the required timeframe from the list.

  • Alert Types — Select the alert types you want to generate the alert history report for.

System Configuration report

The System Configuration report provides detailed information about the PEM Agents group, PEM Server Directory group, and custom groups listed under the browser tree. These groups can contain Postgres Enterprise Manager, PEM agent, and database servers. You can download this report in HTML and JSON formats.

The Postgres Enterprise Manager Summary provides details about:

  • The Postgres Enterprise Manager backend database server version
  • Application version
  • User name accessing the application
  • Python version
  • Flask version
  • Platform specific information

The summary provides information about the number of agents and servers. The Group: PEM Agents panel provides details about the PEM agent, CPU cores, disk utilization, and memory information.

The Group: PEM Server Directory panel provides details about:

  • Database server version
  • Host
  • Port
  • Database name
  • Database size
  • Tablespace size

The group server name depends on the group name to which the server is added.

Core Usage report

The Core Usage report provides detailed information about the number of cores specific to:

  • Server type
  • Database version
  • Platform and group name

The report also gives detailed information about locally managed servers:

  • Type
  • Host
  • Port
  • Platform
  • Cores
  • RAM