database_* tables store query workload information for a Greenplum Database instance. There are three database tables, all having the same columns:
database_nowis an external table whose data files are stored in
$MASTER_DATA_DIRECTORY/gpperfmon/data. Current query workload data is stored in
database_nowduring the period between data collection from the data collection agents and automatic commitment to the
database_tailis an external table whose data files are stored in
$MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for query workload data that has been cleared from
database_nowbut has not yet been committed to
database_history. It typically only contains a few minutes worth of data.
database_historyis a regular table that stores historical database-wide query workload data. It is pre-partitioned into monthly partitions. Partitions are automatically added in two month increments as needed.
||timestamp||Time this row was created.|
||int||The total number of queries in Greenplum Database at data collection time.|
||int||The number of active queries running at data collection time.|
||int||The number of queries waiting in a resource group or resource queue, depending upon which resource management scheme is active, at data collection time.|
Parent topic: The gpperfmon Database