Dashboards v9

PEM displays performance statistics through a number of dashboards. Each dashboard contains a series of summary views that contain charts, graphs, and tables that display the statistics related to the selected object.

Dashboards overview

The PEM client displays the Global Overview dashboard when it connects to the PEM server. Additional dashboards provide statistical information about monitored objects.

Accessing in-app help for UI details

The in-app help provides comprehensive details about the PEM web interface, including the menu items, charts and graphs on the dashboards, and the options on the dialog boxes. The in-app help also includes instructions for creating database objects.

  • To access the landing page for the help, select Help > Online help.
  • To access context-sensitive help for a dialog box, select ?.

Opening dashboards

Dashboards are presented in a hierarchy comparable to the PEM client tree control. The dashboard for each object in the tree control displays the information for that object as well as for any monitored object that resides below that level in the tree control, if appropriate.

Each dashboard header displays the date and time that the server was started, if relevant, the date and time that the dashboard was last updated, and the current number of triggered alerts. Navigation menus displayed in the dashboard header provide easy access to other dashboards. Menus are organized hierarchically. Only those menus appropriate for the object currently highlighted in the tree control are available.

  • Select Global Overview from any dashboard to return to the Global Overview dashboard.
  • Select the name of an agent from the Agents menu to navigate to the Operating System Analysis dashboard for that agent.
  • Select a server name from the Servers menu to navigate to the Server Analysis dashboard for that server.
  • Select a database name from the Databases menu to navigate to the Database Analysis dashboard for that database.
  • Use the Dashboards menu to navigate to informational dashboards at the global level or for the selected agent, server, or database.

Dashboards display statistical information in the form of:

  • Tables that provide statistical information collected by a PEM probe.
  • Pie charts that display information collected by the most recent execution of a probe.
  • Bar graphs that display comparative statistics collected by the most recent execution of a probe.
  • Line graphs that display statistical data collected by PEM probes.

You can open a dashboard using either of these techniques:

  • from the Management > Dashboards menu, select an active dashboard name.
  • Right-click the name of a monitored object in the tree. From the Dashboards menu, select the name of the dashboard to review.

Each dashboard is displayed on the Monitoring tab in the main panel of the client window. After opening a dashboard, you can navigate to other dashboards in the same tab.

Each dashboard header includes navigation menus that allow you to navigate to other dashboards. Use your browser's forward and back buttons to scroll through previously viewed dashboards. Use Refresh to update the current dashboard.

To sort statistics that are provided in table form, select a column heading. Select it again to reverse the sort order. Each table offers a stable sort feature. For example, to sort a table by ascending Session ID in each user name group, sort first by the Session ID column, then sort by the User Name column.

Hover over the upper-right corner of each graph, chart, or table to reveal the PEM client toolbar icons. Hover over an icon to display a tooltip that briefly explains the icon's functionality:

  • Use the Refresh icon to update the information displayed on a dashboard.
  • Use the Save Chart as Image icon to save the selected chart as a .jpeg image.
  • Use the Full Screen icon to enlarge the chart to reveal granular details about the charted data.
  • Use the Personalize the chart configuration icon to access a control panel that allows you to select chart-specific display details.
  • Hover over the Explain icon to review a description of the information shared in the graph or chart.

In the lower-right corner of each graph or chart is a legend that identifies each item plotted in the graph or chart.

If it's displayed, select the information icon in the upper-left corner of a chart to display a note about the chart content and, if applicable, a link that allows you to enable one or more probes that retrieve content for the chart.

Available dashboards

PEM offers the following dashboards. For more information on each of the available dashboards, see the PEM client's online help.

Alerts dashboard

The Alerts dashboard displays the currently triggered alerts. If opened from the Global Overview, the dashboard displays the current alerts for all monitored nodes on the system. If opened from a node in a server, the report shows alerts related to that node and all monitored objects that reside below that object in the tree.

Audit Log Analysis dashboard

For EDB Postgres Advanced Server users, the Audit Log Analysis dashboard allows you to browse the audit logs that were collected from instances with audit logging and collection enabled.

PGD Admin dashboard

The PGD Admin dashboard displays overview information about the EDB Postgres Distributed node, group, and worker.

PGD Group Monitoring dashboard

The PGD Group Monitoring dashboard displays information about EDB Postgres Distributed group subscription and group replication slots.

PGD Node Monitoring dashboard

The PGD Node Monitoring dashboard displays information about EDB Postgres Distributed node slots, node replication rates, and conflict history summary for the selected node.

Database Analysis dashboard

The Database Analysis dashboard displays performance statistics for the selected database.

I/O Analysis dashboard

The I/O Analysis dashboard displays I/O activity across various areas such as object DML activity and log operations.

Memory Analysis dashboard

The Memory Analysis dashboard supplies statistics concerning various memory-related metrics for the Postgres server.

Object Activity Analysis dashboard

The Object Activity Analysis dashboard provides performance details on tables/indexes of a selected database.

Operating System Analysis dashboard

The Operating System Analysis dashboard supplies information regarding the performance of the underlying machine’s operating system.

Probe Log Analysis dashboard

The Probe Log Analysis dashboard displays any error messages returned by a PEM agent.

Server Analysis dashboard

The Server Analysis dashboard provides general performance information about the overall operations of a selected Postgres server.

Server Log Analysis dashboard

The Server Log Analysis dashboard allows you to filter and review the contents of server logs that are stored on the PEM server.

Session Activity Analysis dashboard

The Session Activity Analysis dashboard provides information about the session workload and lock activity for the selected server

Session Waits Analysis dashboard

The Session Waits Analysis dashboard provides an overview of the current DRITA wait events for an Advanced Server session.

Storage Analysis dashboard

The Storage Analysis dashboard displays space-related metrics for tablespaces and objects.

System Waits Analysis dashboard

The System Waits Analysis dashboard displays a graphical analysis of system wait information for an EDB Postgres Advanced Server session.

Streaming Replication Analysis dashboard

The Streaming Replication Analysis dashboard displays statistical information about WAL activity for a monitored server and allows you to monitor the status of Failover Manager clusters.

Dashboard configuration

Options on the Dashboard Configuration dialog box allow you to link the timelines of all of the line graphs on the dashboard. To open the Dashboard Configuration dialog box, select Settings in the dashboard header.

Use the Dashboard Configuration dialog box to control attributes of the charts displayed on the dashboard:

  • Set Link timelines of all the line charts to Enable to apply the specified timeline to line graphs displayed on the dashboard. If set to Disable, your preferences are preserved for later use but don't modify the amount of data displayed.
  • Use the Days selector to specify the number of days of gathered data to display on line graphs.
  • Use the Hour(s) selector to specify the number of hours of gathered data to display on line graphs.
  • Select Remember configuration for this dashboard to apply the customized time span to only the current dashboard only. Leave it cleared to apply the time span globally to line graphs on all dashboards.

Settings specified on the Dashboard Configuration dialog box are applied only to the current user's session.

After you specify your preferences, select Save.

Managing custom dashboards

PEM displays performance statistics on a number of system-defined dashboards. Each dashboard contains a series of summary views that contain charts, graphs, and tables that display statistics related to the selected object. You can use the Manage Dashboards tab to create and manage custom dashboards that display the information that's most relevant to your system.

To create a custom dashboard, select Create New Dashboard located in the Quick Links section of the Manage Dashboards tab.

To modify an existing dashboard, select Edit next to the dashboard name. The dashboard editor opens, displaying the definition of the dashboard. After you finish modifying the dashboard's definition, select Save.

To delete a dashboard, select Delete next to the dashboard name.

Creating a custom dashboard

You can use the PEM dashboard editor to create or modify a custom dashboard. The custom dashboard can include predefined charts, custom charts, or a mix of predefined and custom charts.

Use the Configure section to specify general information about the dashboard:

  • Specify a name for the dashboard in the Name field.
  • Use the Level list to specify the level of the PEM hierarchy in the PEM client on which to display the dashboard. You can access a dashboard using the Dashboards menu on a global level, an agent level, the server level, or the database level. Each selected level in the list exposes a different set of metrics on which to base the custom dashboard's charts.
  • Provide a description of the dashboard in the Description field.

Provide information in the Ops dashboard options box to use the dashboard as an Ops dashboard:

  • Set Ops Dashboard? to Yes to create a dashboard that's formatted to display on an Ops monitor.
  • Set Show Title? to Yes to display the dashboard name at the top of the Ops dashboard.
  • Use the Font list to select a custom font style for the title.
  • Use the Font size list to select a custom font size for the title.

Use the Permissions box to specify the users who can view the new dashboard:

  • Set Share with all to Yes to allow all teams to access the dashboard. Set it to No to enable the Access permissions field.
  • Use the Access permissions field to specify the roles that can view the new dashboard. In the field, select from the list of users to add a role to the list of users with dashboard access.

After you complete the Configure Dashboard section, select the arrow in the upper-right corner to close the section and access the Dashboard Layout Design section.

Select Edit in a section header to specify a section name. Then, select the plus sign (+) to add a chart to the section.

Use the arrows to the right of each chart category to display the charts available and select a chart.

Use the chart detail selectors to specify placement details for the chart:

  • Use the Chart width selector to indicate the width of the chart. Select 50% to display the chart in half of the dashboard or 100% to use the whole dashboard width.

  • Use the Chart alignment selector to indicate the position of the chart in the section, left, center, or right justified.

Tables are always displayed centered.

When creating or editing a custom dashboard, you can drag to rearrange the charts in a section or to move a chart to a different section.

To add another chart to your dashboard, select the plus sign (+) in the section header. After you finish editing the dashboard, select Save.

Creating an Ops dashboard

You can use the PEM dashboard editor to create a custom dashboard formatted for display on an Ops monitor. An Ops dashboard displays the specified charts and graphs while omitting header information and minimizing extra banners, titles, and borders.

To create an Ops dashboard, provide detailed information about the Ops display in the Ops dashboard options section of the Create Dashboard dialog box.

  • Set Ops Dashboard? to Yes to create a dashboard that's formatted for display on an Ops monitor.
  • Set Show Title? to Yes to display the dashboard name at the top of the Ops dashboard.
  • Use the Font list to select a custom font style for the title.
  • Use the Font size list to select a custom font size for the title.

After adding charts and tables to the Ops dashboard, select Save. You can then access the dashboard by navigating through the Dashboards menu of the hierarchy level specified in the Level field on the New Dashboard dialog box.