Clusters

The clusters system table includes information about the clusters that have been created within your organization.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.monitoring.clusters;

The system.monitoring.clusters table includes the following columns:

Column	Type	Description
cluster_id	string	The unique identifier for the cluster.
cluster_name	string	The name given to the cluster on creation.
crashes	bigint	The number of server crashes that happened in the job’s cluster since midnight (UTC) to now.
last_report_time	string	The date and time when the cluster metadata was last updated.
memory_load_percent	bigint	The percentage of time that the server is doing garbage collection rather than working.
reload_from_disk_percent	bigint	The percent of bytes re-loaded into memory from disk since midnight (UTC) to now.
tasks_in_queue	bigint	The number of job tasks pending execution in the cluster queue.
utilization_percent	bigint	The percentage of the server's processing capacity that is in use.