EXA_USAGE_HOURLY

This system table contains the hourly aggregated usage information of the DBMS for a cluster, sorted by the interval start. All users have access to the table.

Column Name Description
CLUSTER_NAME Name of the cluster
INTERVAL_START Timetamp at the start of the aggregation interval
USERS_AVG Average number of users connected to the DBMS
USERS_MAX Maximum number of users connected to the DBMS
QUERIES_AVG Average number of concurrent queries
QUERIES_MAX Maximum number of concurrent queries
IDLE Percentage of last period where no query is running at all