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
gpperfmonagents 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.
||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.|
Parent topic: The gpperfmon Database