diskspace_*

The diskspace_* tables of the gpperfmon database store disk space metrics. There are three tables with the same columns:

diskspace_now is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. Current disk space metrics are stored in diskspace_now during the period between data collection from the gpperfmon agents and automatic commit to the diskspace_history table.
diskspace_tail is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for disk space metrics that have been cleared from diskspace_now but have not yet been committed to diskspace_history. It typically contains a few minutes worth of data. This table is for internal use only.
diskspace_history is a regular table that stores historical disk space metrics. It is partitioned into monthly partitions. Partitions are automatically added in two-month increments as needed.

Column	Type	Description
ctime	timestamp(0) without time zone	Time of disk space measurement
hostname	varchar(64)	The hostname associated with the disk space measurement
filesystem	text	Name of the file system for the disk space measurement
total_bytes	bigint	Total bytes in the file system
bytes_used	bigint	Total bytes used in the file system
bytes_available	bigint	Total bytes available in the file system

Column

Type

Description

ctime

timestamp(0) without time zone

Time of disk space measurement

hostname

varchar(64)

The hostname associated with the disk space measurement

filesystem

text

Name of the file system for the disk space measurement

total_bytes

bigint

Total bytes in the file system

bytes_used

bigint

Total bytes used in the file system

bytes_available

bigint

Total bytes available in the file system