diskspace_* tables store diskspace metrics.
diskspace_nowis an external table whose data files are stored in
$MASTER_DATA_DIRECTORY/gpperfmon/data. Current diskspace metrics are stored in
database_nowduring the period between data collection from the Command Center agents and automatic commitment to the
diskspace_tailis an external table whose data files are stored in
$MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for diskspace metrics that have been cleared from
diskspace_nowbut has not yet been committed to
diskspace_history. It typically only contains a few minutes worth of data.
diskspace_historyis a regular table that stores historical diskspace 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.
||timestamp(0) without time zone||Time of diskspace measurement.|
||varchar(64)||The hostname associated with the diskspace measurement.|
||text||Name of the filesystem for the diskspace measurement.|
||bigint||Total bytes in the file system.|
||bigint||Total bytes used in the file system.|
||bigint||Total bytes available in file system.|