Postgres Enterprise Manager™ uses metrics (retrieved by probes) to generate the statistical information displayed on the dashboards. Dashboards are presented in a hierarchy comparable to the PEM client tree control; the dashboard for each object within 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 organised 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 - Tables provide statistical information collected by a PEM probe.
- Pie charts - Pie charts display information collected by the most recent execution of a probe.
- Bar graphs - Bar graphs display comparative statistics collected by the most recent execution of a probe.
- Line graphs - Line graphs display statistical data collected by PEM probes.
Options on the Dashboard Configuration dialog allow you to link the time lines of all of the line graphs on the dashboard. To open the Dashboard Configuration dialog, click the wrench icon displayed in the dashboard header.
- Set the Link timelines of all the line charts slider to Enable to indicate that the specified timeline should be applied to line graphs displayed on the dashboard; if set to Disable, your preferences will be preserved for later use, but will not modify the amount of data displayed.
- Use the Days selector to specify the number of days of gathered data that should be displayed on line graphs.
- Use the Hour(s) selector to specify the number of hours of gathered data that should be displayed on line graphs.
- Check the box next to Remember configuration for this dashboard to indicate that the customized time span should be applied to the current dashboard only; if left unchecked, the time span will be applied globally to line graphs on all dashboards.
Please note that settings specified on the Dashboard Configuration dialog are applied only to the current user’s session.
When you’ve specified your preferences, click Save to preserve your changes and exit the dialog; click Cancel to exit the dialog without preserving your changes.
To sort statistics that are provided in table form, click on a column heading; click again to reverse the sort order. Each table offers a stable sort feature - For example, to sort a table by ascending Session ID within each user name group, sort first by the Session ID column, then sort by the User Name column.
Hover your mouse 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.
- Click 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 displayed, click the information icon in the upper-left hand corner of a chart to display a note about the chart content, and if applicable, a link that will allow you to enable one or more probes that retrieve content for the chart.
Navigation menus in the dashboard header provide easy access to other dashboards. The menus are organized hierarchically, allowing you to jump from object to object at any level:
- The Global Overview option opens the Global Overview dashboard.
- The Agents menu expands to display a list of agents. Select an agent from the list to access the Operating System Analysis dashboard for that agent.
- The Servers menu expands to display a list of monitored servers. Select a server from the list to access the Server Analysis dashboard for that server.
- The Remote Servers menu expands to display a list of servers that are monitored by a remote agent. Select a server from the list to access the Server Analysis dashboard for the server.
- The Databases menu expands to display a list of databases. Select a database from the list to access the Database Analysis dashboard for the database.
- The Dashboards menu expands to display a list of the dashboards that are available at the global level, or for the current agent, server or database. Select a dashboard from the list to navigate to that dashboard.
Creating custom charts and dashboards¶
PEM offers the following dashboards:
- Alerts Dashboard
- Audit Log Dashboard
- Database Analysis Dashboard
- Global Overview Dashboard
- I/O Analysis Dashboard
- Memory Analysis Dashboard
- Object Activity Analysis Dashboard
- Operating System Analysis Dashboard
- Probe Log Analysis Dashboard
- Server Analysis Dashboard
- Server Log Analysis Dashboard
- Session Activity Analysis Dashboard
- Session Wait Analysis Dashboard
- Storage Analysis Dashboard
- System Wait Analysis Dashboard
- Streaming Replication Analysis Dashboard
- The Alerts Dashboard
- The Audit Log Analysis Dashboard
- The Database Analysis Dashboard
- The Global Overview Dashboard
- The I/O Analysis Dashboard
- The Memory Analysis Dashboard
- The Objects Activity Analysis Dashboard
- The Operating System Analysis Dashboard
- The Probe Log Analysis Dashboard
- The Server Analysis Dashboard
- The Server Log Analysis Dashboard
- The Session Activity Analysis Dashboard
- The Session Waits Analysis Dashboard
- The Storage Analysis Dashboard
- The System Wait Analysis Dashboard
- The Streaming Replication Analysis Dashboard