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:
Global Overviewfrom any dashboard to return to the Global Overview dashboard.
Select the name of an agent from the
Agentsmenu to navigate to the Operating System Analysis dashboard for that agent.
Select a server name from the
Serversmenu to navigate to the Server Analysis dashboard for that server.
Select a database name from the
Databasesmenu to navigate to the Database Analysis dashboard for that database.
Dashboardsmenu 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.
Link timelines of all the line chartsslider to
Enableto 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.
Daysselector to specify the number of days of gathered data that should be displayed on line graphs.
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 dashboardto 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:
Refreshicon to update the information displayed on a dashboard.
Save Chart as Imageicon to save the selected chart as a .jpeg image.
Full Screenicon to enlarge the chart to reveal granular details about the charted data.
Personalize the chart configurationicon to access a control panel that allows you to select chart-specific display details.
Hover over the
Explainicon 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
Agentsmenu expands to display a list of agents. Select an agent from the list to access the
Operating System Analysisdashboard for that agent.
Serversmenu expands to display a list of monitored servers. Select a server from the list to access the
Server Analysisdashboard for that server.
Remote Serversmenu expands to display a list of servers that are monitored by a remote agent. Select a server from the list to access the
Server Analysisdashboard for the server.
Databasesmenu expands to display a list of databases. Select a database from the list to access the
Database Analysisdashboard for the database.
Dashboardsmenu 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:
- 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