health_* tables store system health metrics for the EMC Data Computing Appliance. There are three health tables, all having the same columns:
Note: This table only applies to Greenplum Data Computing Appliance platforms.
health_nowis an external table whose data files are stored in
$MASTER_DATA_DIRECTORY/gpperfmon/data. Current system health data is stored in
system_nowduring the period between data collection from the Command Center agents and automatic commitment to the
health_tailis an external table whose data files are stored in
$MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for system health data that has been cleared from
system_nowbut has not yet been committed to
system_history. It typically only contains a few minutes worth of data.
health_historyis a regular table that stores historical system health metrics. It is pre-partitioned into monthly partitions. Partitions are automatically added in two month increments as needed. Administrators must drop old partitions for the months that are no longer needed.
|ctime||timestamp(0) without time zone||Time this snapshot of health information about this system was created.|
|hostname||varchar(64)||Segment or master hostname associated with this health information.|
||int||The symptom code related to the current health/status of an element or component of the system.|
||int||A more granular symptom code related to the health/status of a element or component of the system.|
||text||A description of the health/status of this symptom code.|
||text||The SNMP object ID of the element/component where the event occurred, where applicable.|
||text||The current status of the system. The status is always
||text||The text of the error message created as a result of this event.|