Dashboard

The Dashboard displays when you first sign in to Pivotal Greenplum Command Center. The Dashboard provides a quick view of the current system status, Segment Health, Queries, CPU, Memory, and Disk usage. Clicking on a panel provides more detailed information about the metric. The Alerts panel shows the most recent messages from the Greenplum Database log file. If you run Greenplum Database on a Dell EMC Data Computing Appliance (DCA), the Dial-Homes panel shows the most recent dial-home events sent to Dell EMC Support. Some information is available only to Command Center users with Admin or Operator permission level.

System Information

The following system information is displayed at the top of the page.

Uptime
The elapsed time since the Greenplum Database system was last started.

GPDB Version
The version of the Greenplum Database software the monitored cluster is running.

Connections
The number of active Greenplum Database sessions (client connections).

Server
The name of this Greenplum Command Center instance.

Last Sync
Date and time the data was last synchronized. The Command Center user interface updates views with live data every 15 seconds.

System Summary

The System Summary section of the Dashboard provides a quick overview of the status of the database, segments, and hardware this Command Center instance monitors.

Database State

Database State is the current state of the Greenplum Database system. The state can be one of the following:

  • Normal: The database is functioning with no major errors or performance issues.
  • Segment(s) Down: The database is in change-tracking mode or resync mode. Overall performance and system reliability is greatly reduced. See the Pivotal Greenplum Database System Administrator Guide for information about resolving this condition.
  • Database Unreachable: The Greenplum Performance Monitor agent cannot connect to the database. The database is likely down. See the Pivotal Greenplum Database System Administrator Guide for troubleshooting information.
  • Unbalanced: Some segments are not running in their preferred roles. That is, primaries are running as mirrors and mirrors are running as primaries, resulting in unbalanced processing.
  • Resyncing: The database is performing a recovery or rebalance operation.

Segment Status

The bar graph in the Segment Status section shows the up or down status of all database segments in your Pivotal Greenplum Database system. A color indicator and associated number indicate the number of database segments that are currently in that particular state. Segments can have the following states:

  • Up (Green)
  • Down (Red)

Clicking the Segment Status panel displays the Segment Status Command Center page.

Hardware Status

This section is only populated if this Command Center is monitoring a Data Computing Appliance (DCA) environment.

The Hardware Status section is only populated if this Command Center is monitoring a Data Computing Appliance (DCA) environment.

This section allows you to view the overall health of your Greenplum Database cluster hardware.

It displays DCA-specific information about the status of the following items:

  • Greenplum Database Master Hosts
  • Greenplum Database Segment Hosts
  • Admin Switch
  • ETL hosts
  • Interconnect Switch Interfaces

The bar charts show numbers of these items currently in various states color-coded as follows:

  • Error (Red)
  • Warning (Yellow)
  • Normal (Green)
  • Unknown (Gray)
  • Unreachable (Blue)
  • Info (Cyan)

Click anywhere in the Hardware Status section to see details on the Hardware Status page.

Disk Usage Summary

This chart displays total disk usage and disk available for the Greenplum master host and segment hosts at the last synchronization. Hover over the chart to see the amount of disk used, free, and total.

Queries

This graph displays a summary view of active and queued queries for the last 60 minutes. Click on the colored dot next to the Running or Queued label to toggle the line on or off. At least one line must be visible at all times. Hover over the graph to display the number of queries for each visible line at that point in time.

CPU

This graph displays average CPU usage across the entire cluster, for the last 60 minutes. The graph displays separate lines for system processes and user processes. The user CPU usage includes the Greenplum database master, standby, and segment processes. Click on the colored dot next to the System or User label to toggle that line on or off. At least one line must be visible at all times.

Hovering the cursor over a line in the graph displays a small window with the percentage of CPU used at that point in time for the visible lines and the total if both the system and user lines are visible.

Memory

This graph displays the average percent of memory used across the entire cluster over the last 60 minutes. Hover over the line to display the percent of memory used at that point in time.

Alerts

Admin and Operator permission levels only

The Alerts panel displays recent messages from the Greenplum Database pg_log log file. The panel is updated at each synchronization. Filter the messages by severity level using the controls at the top right of the panel.