health_*

The 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_now is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. Current system health data is stored in system_now during the period between data collection from the Command Center agents and automatic commitment to the system_history table.
health_tail is 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_now but has not yet been committed to system_history. It typically only contains a few minutes worth of data.
health_history is 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.

Column	Type	Description
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.
`symptom_code`	int	The symptom code related to the current health/status of an element or component of the system.
`detailed_symptom_code`	int	A more granular symptom code related to the health/status of a element or component of the system.
`description`	text	A description of the health/status of this symptom code.
`snmp_oid`	text	The SNMP object ID of the element/component where the event occurred, where applicable.
`status`	text	The current status of the system. The status is always `OK` unless a connection to the server/switch cannot be made, in which case the status is `FAILED`.
`message`	text	The text of the error message created as a result of this event.