System Views
GridGain provides a number of built-in SQL views that contain information about cluster nodes and node metrics. These views are available in the SYS schema. See the Understanding Schemas page for the information on how to access a non-default schema.
NODES
The NODES view contains information about the cluster nodes.
Column | Data Type | Description |
---|---|---|
NODE_ID |
UUID |
Node ID. |
CONSISTENT_ID |
VARCHAR |
Node’s consistent ID. |
VERSION |
VARCHAR |
Node version. |
IS_CLIENT |
BOOLEAN |
Indicates whether the node is a client. |
IS_DAEMON |
BOOLEAN |
Indicates whether the node is a daemon node. |
NODE_ORDER |
INT |
Node order within the topology. |
ADDRESSES |
VARCHAR |
The addresses of the node. |
HOSTNAMES |
VARCHAR |
The host names of the node. |
NODE_ATTRIBUTES
The NODE_ATTRIBUTES view contains the attributes of all nodes.
Column | Data Type | Description |
---|---|---|
NODE_ID |
UUID |
Node ID. |
NAME |
VARCHAR |
Attribute name. |
VALUE |
VARCHAR |
Attribute value. |
BASELINE_NODES
The BASELINE_NODES view contains information about the nodes that are part of the current baseline topology.
Column | Data Type | Description |
---|---|---|
CONSISTENT_ID |
VARCHAR |
Node consistent ID. |
ONLINE |
BOOLEAN |
Indicates whether the node is up and running. |
NODE_METRICS
The NODE_METRICS view provides various metrics about the state of nodes, resource consumption and other metrics.
Column | Data Type | Description |
---|---|---|
NODE_ID |
UUID |
Node ID. |
LAST_UPDATE_TIME |
TIMESTAMP |
Last time the metrics were updated. |
MAX_ACTIVE_JOBS |
INT |
Maximum number of concurrent jobs this node ever had at one time. |
CUR_ACTIVE_JOBS |
INT |
Number of currently active jobs running on the node. |
AVG_ACTIVE_JOBS |
FLOAT |
Average number of active jobs concurrently executing on the node. |
MAX_WAITING_JOBS |
INT |
Maximum number of waiting jobs this node ever had at one time. |
CUR_WAITING_JOBS |
INT |
Number of queued jobs currently waiting to be executed. |
AVG_WAITING_JOBS |
FLOAT |
Average number of waiting jobs this node ever had at one time. |
MAX_REJECTED_JOBS |
INT |
Maximum number of jobs rejected at once during a single collision resolution operation. |
CUR_REJECTED_JOBS |
INT |
Number of jobs rejected as a result of the most recent collision resolution operation. |
AVG_REJECTED_JOBS |
FLOAT |
Average number of jobs this node rejected as a result of collision resolution operations. |
TOTAL_REJECTED_JOBS |
INT |
Total number of jobs this node has rejected as a result of collision resolution operations since the node startup. |
MAX_CANCELED_JOBS |
INT |
Maximum number of cancelled jobs this node ever had running concurrently. |
CUR_CANCELED_JOBS |
INT |
Number of cancelled jobs that are still running. |
AVG_CANCELED_JOBS |
FLOAT |
Average number of cancelled jobs this node ever had running concurrently. |
TOTAL_CANCELED_JOBS |
INT |
Number of jobs cancelled since the node startup. |
MAX_JOBS_WAIT_TIME |
TIME |
Maximum time a job ever spent waiting in a queue before being executed. |
CUR_JOBS_WAIT_TIME |
TIME |
Longest wait time among the jobs that are currently waiting for execution. |
AVG_JOBS_WAIT_TIME |
TIME |
Average time jobs spend in the queue before being executed. |
MAX_JOBS_EXECUTE_TIME |
TIME |
Maximum job execution time. |
CUR_JOBS_EXECUTE_TIME |
TIME |
Longest time a current job has been executing for. |
AVG_JOBS_EXECUTE_TIME |
TIME |
Average job execution time on this node. |
TOTAL_JOBS_EXECUTE_TIME |
TIME |
Total time all finished jobs took to execute on this node since the node startup. |
TOTAL_EXECUTED_JOBS |
INT |
Total number of jobs handled by the node since the node startup. |
TOTAL_EXECUTED_TASKS |
INT |
Total number of tasks handled by the node. |
TOTAL_BUSY_TIME |
TIME |
Total time this node spent executing jobs. |
TOTAL_IDLE_TIME |
TIME |
Total time this node spent idling (not executing any jobs). |
CUR_IDLE_TIME |
TIME |
Time this node has spent idling since executing the last job. |
BUSY_TIME_PERCENTAGE |
FLOAT |
Percentage of job execution vs idle time. |
IDLE_TIME_PERCENTAGE |
FLOAT |
Percentage of idle vs job execution time. |
TOTAL_CPU |
INT |
Number of CPUs available to the Java Virtual Machine. |
CUR_CPU_LOAD |
DOUBLE |
Percentage of CPU usage expressed as a fraction in the range [0, 1]. |
AVG_CPU_LOAD |
DOUBLE |
Average percentage of CPU usage expressed as a fraction in the range [0, 1]. |
CUR_GC_CPU_LOAD |
DOUBLE |
Average time spent in GC since the last update of the metrics. By default, metrics are updated every 2 seconds. |
HEAP_MEMORY_INIT |
LONG |
Amount of heap memory in bytes that the JVM initially requests from the operating system for memory management. Shows |
HEAP_MEMORY_USED |
LONG |
Current heap size that is used for object allocation. The heap consists of one or more memory pools. This value is the sum of used heap memory values of all heap memory pools. |
HEAP_MEMORY_COMMITED |
LONG |
Amount of heap memory in bytes that is committed for the JVM to use. This amount of memory is guaranteed for the JVM to use. The heap consists of one or more memory pools. This value is the sum of committed heap memory values of all heap memory pools. |
HEAP_MEMORY_MAX |
LONG |
Maximum amount of heap memory in bytes that can be used for memory management. The column displays |
HEAP_MEMORY_TOTAL |
LONG |
Total amount of heap memory in bytes. The column displays |
NONHEAP_MEMORY_INIT |
LONG |
Amount of non-heap memory in bytes that the JVM initially requests from the operating system for memory management. The column displays |
NONHEAP_MEMORY_USED |
LONG |
Current non-heap memory size that is used by Java VM. The non-heap memory consists of one or more memory pools. This value is the sum of used non-heap memory values of all non-heap memory pools. |
NONHEAP_MEMORY_COMMITED |
LONG |
Amount of non-heap memory in bytes that is committed for the JVM to use. This amount of memory is guaranteed for the JVM to use. The non-heap memory consists of one or more memory pools. This value is the sum of committed non-heap memory values of all non-heap memory pools. |
NONHEAP_MEMORY_MAX |
LONG |
Returns the maximum amount of non-heap memory in bytes that can be used for memory management. The column displays |
NONHEAP_MEMORY_TOTAL |
LONG |
Total amount of non-heap memory in bytes that can be used for memory management. The column displays |
UPTIME |
TIME |
Uptime of the JVM. |
JVM_START_TIME |
TIMESTAMP |
Start time of the JVM. |
NODE_START_TIME |
TIMESTAMP |
Start time of the node. |
LAST_DATA_VERSION |
LONG |
In-Memory Data Grid assigns incremental versions to all cache operations. This column contains the latest data version on the node. |
CUR_THREAD_COUNT |
INT |
Number of live threads including both daemon and non-daemon threads. |
MAX_THREAD_COUNT |
INT |
Maximum live thread count since the JVM started or peak was reset. |
TOTAL_THREAD_COUNT |
LONG |
Total number of threads started since the JVM started. |
CUR_DAEMON_THREAD_COUNT |
INT |
Number of live daemon threads. |
SENT_MESSAGES_COUNT |
INT |
Number of node communication messages sent. |
SENT_BYTES_COUNT |
LONG |
Amount of bytes sent. |
RECEIVED_MESSAGES_COUNT |
INT |
Number of node communication messages received. |
RECEIVED_BYTES_COUNT |
LONG |
Amount of bytes received. |
OUTBOUND_MESSAGES_QUEUE |
INT |
Outbound messages queue size. |
TRANSACTIONS
This view exposes information about currently running transactions.
NAME |
TYPE |
DESCRIPTION |
ORIGINATING_NODE_ID |
UUID |
|
STATE |
string |
|
XID |
UUID |
|
LABEL |
string |
|
START_TIME |
long |
|
ISOLATION |
string |
|
CONCURRENCY |
string |
|
KEYS_COUNT |
int |
|
CACHE_IDS |
string |
|
COLOCATED |
boolean |
|
DHT |
boolean |
|
DURATION |
long |
|
IMPLICIT |
boolean |
|
IMPLICIT_SINGLE |
boolean |
|
INTERNAL |
boolean |
|
LOCAL |
boolean |
|
LOCAL_NODE_ID |
UUID |
|
NEAR |
boolean |
|
ONE_PHASE_COMMIT |
boolean |
|
OTHER_NODE_ID |
UUID |
|
SUBJECT_ID |
UUID |
|
SYSTEM |
boolean |
|
THREAD_ID |
long |
|
TIMEOUT |
long |
|
TOP_VER |
string |
SQL_QUERIES
This view exposes information about currently running SQL queries.
NAME |
TYPE |
DESCRIPTION |
QUERY_ID |
UUID |
Query ID |
SQL |
string |
Query text |
ORIGIN_NODE_ID |
UUID |
Node that started query |
START_TIME |
date |
Query start time |
DURATION |
long |
Query execution duration |
INITIATOR_ID |
string |
User defined query initiator ID |
LOCAL |
boolean |
True if local only |
SCHEMA_NAME |
string |
Schema name |
DISK_ALLOCATION_CURRENT |
long |
Disk allocation for the query at the current moment |
DISK_ALLOCATION_MAX |
long |
Maximum disk allocation during the query run |
DISK_ALLOCATION_TOTAL |
long |
Total disk allocation during the query run |
MEMORY_CURRENT |
long |
Current memory usage |
MEMORY_MAX |
long |
Maximum memory allocation during the query run |
DISTRIBUTED_JOINS |
boolean |
True if distributed joins for the query are enabled |
ENFORCE_JOIN_ORDER |
boolean |
True if the join order enforcement for the query is enabled |
LAZY |
boolean |
True if lazy loading of the query results is enabled |
SQL_QUERIES_HISTORY
NAME |
TYPE |
DESCRIPTION |
SCHEMA_NAME |
string |
Schema name |
SQL |
string |
Query text |
LOCAL |
boolean |
True if local only |
EXECUTIONS |
long |
Count of executions |
FAILURES |
long |
Count of failures |
DURATION_MIN |
long |
Minimal duration of execution |
DURATION_MAX |
long |
Maximum duration of execution |
LAST_START_TIME |
date |
Last execution date |
DISK_ALLOCATION_MIN |
long |
Minimum disk allocation among the query runs |
DISK_ALLOCATION_MAX |
long |
Maximum disk allocation among the query runs |
DISK_ALLOCATION_TOTAL_MIN |
long |
Minimum total disk allocation among the query runs |
DISK_ALLOCATION_TOTAL_MAX |
long |
Maximum total disk allocation among the query runs |
MEMORY_MIN |
long |
Minimum memory allocation among the query runs |
MEMORY_MAX |
long |
Maximum memory allocation among the query runs |
DISTRIBUTED_JOINS |
boolean |
True if distributed joins were enabled during the query execution |
ENFORCE_JOIN_ORDER |
boolean |
True if the join order enforcement was enabled during the query execution |
LAZY |
boolean |
True if lazy loading of the query results was enabled during the query execution |
SCHEMAS
This view exposes information about SQL schemas.
NAME |
TYPE |
DESCRIPTION |
NAME |
string |
Name of the schema |
PREDEFINED |
boolean |
If true schema is predefined |
TASKS
This view exposes information about currently running compute tasks started by a node. For instance, let’s assume that an application started a compute task using the Ignite thick client and the task’s job was executed on one of the server nodes. In this case, the thick client will report statistics related to the task via this system view while the server node will be updating the thick client with task-related execution details.
NAME |
TYPE |
DESCRIPTION |
ID |
UUID |
Task id |
SESSION_ID |
UUID |
Session ID |
TASK_NODE_ID |
UUID |
Task originating node id |
TASK_NAME |
string |
Task name |
TASK_CLASS_NAME |
string |
Task class name |
AFFINITY_PARTITION_ID |
int |
Cache partition id |
AFFINITY_CACHE_NAME |
string |
Cache name |
START_TIME |
long |
Start time |
END_TIME |
long |
End time |
EXEC_NAME |
string |
Thread pool name executing task |
INTERNAL |
boolean |
True if task is internal |
USER_VERSION |
string |
Task user version |
JOBS
This system view shows a list of compute jobs started by a node as part of a compute task.
To view the status of the compute task refer to the TASKS
system view.
NAME |
TYPE |
DESCRIPTION |
ID |
UUID |
Job ID |
SESSION_ID |
UUID |
Job’s session ID. Note, |
ORIGIN_NODE_ID |
UUID |
The id of the node that started the job |
TASK_NAME |
string |
The name of the task |
TASK_CLASSNAME |
string |
Class name of the task |
AFFINITY_CACHE_IDS |
string |
IDs of one or more caches if the job is executed against one of the |
AFFINITY_PARTITION_ID |
int |
IDs of one or more partitions if the job is executed via one of the |
CREATE_TIME |
long |
Job’s creation time |
START_TIME |
long |
Job’s start time |
FINISH_TIME |
long |
Job’s finish time |
EXECUTOR_NAME |
string |
The name of the task’s executor |
IS_FINISHING |
boolean |
|
IS_INTERNAL |
boolean |
|
IS_STARTED |
boolean |
|
IS_TIMEDOUT |
boolean |
|
STATE |
string |
Possible values: |
TABLES
The TABLES view contains information about the SQL tables.
Column | Data Type | Description |
---|---|---|
CACHE_GROUP_ID |
INT |
The id of the cache group. |
CACHE_GROUP_NAME |
VARCHAR |
The name of the cache group. |
CACHE_ID |
INT |
The ID of the cache corresponding to the table. |
CACHE_NAME |
VARCHAR |
The name of the cache corresponding to the table. |
SCHEMA_NAME |
VARCHAR |
The name of the schema. |
TABLE_NAME |
VARCHAR |
The name of the table. |
AFFINITY_KEY_COLUMN |
VARCHAR |
The column that is used as the affinity key. |
KEY_ALIAS |
VARCHAR |
The alias for the key fields. |
VALUE_ALIAS |
VARCHAR |
The alias for the value field. |
KEY_TYPE_NAME |
VARCHAR |
The type of the key field. |
VALUE_TYPE_NAME |
VARCHAR |
The type of the value field. |
CACHE_GROUPS
The CACHE_GROUPS view contains information about the cache groups.
Column | Data Type | Description |
---|---|---|
CACHE_GROUP_ID |
INT |
The ID of the cache group. |
CACHE_GROUP_NAME |
VARCHAR |
The name of the cache group. |
IS_SHARED |
BOOLEAN |
If this group contains more than one cache. |
CACHE_COUNT |
INT |
The number of caches in the cache group. |
CACHE_MODE |
VARCHAR |
The cache mode. |
ATOMICITY_MODE |
VARCHAR |
The atomicity mode of the cache group. |
AFFINITY |
VARCHAR |
The string representation (as returned by the |
PARTITIONS_COUNT |
INT |
The number of partitions. |
NODE_FILTER |
VARCHAR |
The string representation (as returned by the |
DATA_REGION_NAME |
VARCHAR |
The name of the data region. |
TOPOLOGY_VALIDATOR |
VARCHAR |
The string representation (as returned by the |
PARTITION_LOSS_POLICY |
VARCHAR |
|
REBALANCE_MODE |
VARCHAR |
|
REBALANCE_DELAY |
LONG |
|
REBALANCE_ORDER |
INT |
|
BACKUPS |
INT |
The number of backup partitions configured for the cache group. |
CACHE_GROUP_PAGE_LISTS
Column |
Data type |
Description |
CACHE_GROUP_ID |
int |
Cache group ID |
PARTITION_ID |
int |
Partition ID |
NAME |
string |
Page list name |
BUCKET_NUMBER |
int |
Bucket number |
BUCKET_SIZE |
long |
Count of pages in the bucket |
STRIPES_COUNT |
int |
Count of stripes used by this bucket. Stripes are used to avoid contention. |
CACHED_PAGES_COUNT |
int |
Count of pages in an on-heap page list cache for this bucket. |
PAGE_FREE_SPACE |
int |
Free space (in bytes) available to use for each page in this bucket. |
DATA_REGION_PAGE_LISTS
Column |
Data type |
Description |
NAME |
string |
Page list name |
BUCKET_NUMBER |
int |
Bucket number |
BUCKET_SIZE |
long |
Count of pages in the bucket |
STRIPES_COUNT |
int |
Count of stripes used by this bucket. Stripes are used to avoid contention. |
CACHED_PAGES_COUNT |
int |
Count of pages in an on-heap page list cache for this bucket. |
PAGE_FREE_SPACE |
int |
Free space (in bytes) available to use for each page in this bucket. |
STRIPED_THREADPOOL_QUEUE
This view exposes information about tasks waiting for the execution in the system striped thread pool.
NAME |
TYPE |
DESCRIPTION |
DESCRIPTION |
string |
toString representation of the task |
STRIPE_INDEX |
int |
Index of the stripe thread |
TASK_NAME |
string |
Class name of the task |
THREAD_NAME |
string |
Name of the stripe thread |
SCAN_QUERIES
This view exposes information about currently running scan queries.
NAME |
TYPE |
DESCRIPTION |
CACHE_GROUP_ID |
int |
Cache group ID |
CACHE_GROUP_NAME |
string |
Cache group name |
CACHE_ID |
int |
Cache ID |
CACHE_NAME |
string |
Cache name |
CANCELED |
boolean |
True if canceled |
DURATION |
long |
Query duration |
FILTER |
string |
toString representation of filter |
KEEP_BINARY |
boolean |
True if keepBinary enabled |
LOCAL |
boolean |
True if query local only |
ORIGIN_NODE_ID |
UUID |
Node id started query |
PAGE_SIZE |
int |
Page size |
PARTITION |
int |
Query partition ID |
QUERY_ID |
long |
Query ID |
START_TIME |
long |
Query start time |
SUBJECT_ID |
UUID |
User ID started query |
TASK_NAME |
string |
|
TOPOLOGY |
string |
Topology version |
TRANSFORMER |
string |
toString representation of transformer |
CONTINUOUS_QUERIES
This view exposes information about currently running continuous queries.
NAME |
TYPE |
DESCRIPTION |
AUTO_UNSUBSCRIBE |
boolean |
True if query should be stopped when node disconnected or originating node left |
BUFFER_SIZE |
int |
Event batch buffer size |
CACHE_NAME |
string |
Cache name |
DELAYED_REGISTER |
boolean |
True if query would be started when corresponding cache started |
INTERVAL |
long |
Notify interval |
IS_EVENTS |
boolean |
True if used for subscription to remote events |
IS_MESSAGING |
boolean |
True if used for subscription to messages. |
IS_QUERY |
boolean |
True if user started continuous query. |
KEEP_BINARY |
boolean |
True if keepBinary enabled |
LAST_SEND_TIME |
long |
Last time event batch sent to query originating node |
LOCAL_LISTENER |
string |
toString representation of local listener |
LOCAL_TRANSFORMED_LISTENER |
string |
toString representation of local transformed listener |
NODE_ID |
UUID |
Originating node id |
NOTIFY_EXISTING |
boolean |
True if listener should be notified about existing entries |
OLD_VALUE_REQUIRED |
boolean |
True if old entry value should be included in event |
REMOTE_FILTER |
string |
toString representation of remote filter |
REMOTE_TRANSFORMER |
string |
toString representation of remote transformer |
ROUTINE_ID |
UUID |
Query ID |
TOPIC |
string |
Query topic name |
CLIENT_CONNECTIONS
This view exposes information about currently opened client connections: JDBC, ODBC, Thin clients.
NAME |
TYPE |
DESCRIPTION |
CONNECTION_ID |
long |
ID of the connection |
LOCAL_ADDRESS |
IP |
address IP address of the local node |
REMOTE_ADDRESS |
IP |
address IP address of the remote node |
TYPE |
string |
Type of the connection |
USER |
string |
User name |
VERSION |
string |
Protocol version |
CLIENT_CONNECTION_ATTRIBUTES
The CLIENT_CONNECTION_ATTRIBUTES view exposes user defined attributes of client connections (thin, JDBC, ODBC). Attributes for the connection are provided by clients. For example, attributes for java thin client can be specified using ClientConfiguration.setUserAttributes
method.
Column |
Data Type |
Description |
CONNECTION_ID |
long |
ID of the connection |
NAME |
VARCHAR |
Name of the attribute |
VALUE |
VARCHAR |
Attribute value |
INDEXES
The INDEXES view contains information about SQL indexes.
Column | Data Type | Description |
---|---|---|
INDEX_NAME |
VARCHAR |
The name of the index. |
INDEX_TYPE |
VARCHAR |
The type of the index. |
COLUMNS |
VARCHAR |
The columns included in the index. |
SCHEMA_NAME |
VARCHAR |
The schema name. |
TABLE_NAME |
VARCHAR |
The table name. |
CACHE_GROUP_ID |
VARCHAR |
The cache group ID. |
CACHE_GROUP_NAME |
VARCHAR |
The cache group name. |
CACHE_NAME |
VARCHAR |
The cache name. |
CACHE_ID |
INT |
Cache ID. |
INLINE_SIZE |
INT |
The inline size in bytes. |
IS_PK |
BOOLEAN |
Indicates whether the index is for the primary key. |
IS_UNIQUE |
BOOLEAN |
Indicates if the index is unique. |
STATISTICS_CONFIGURATION
The STATISTICS_CONFIGURATION view contains information about SQL statistics configuration.
Column | Data Type | Description |
---|---|---|
SCHEMA |
VARCHAR |
Schema name. |
TYPE |
VARCHAR |
Object type. |
NAME |
VARCHAR |
Object name. |
COLUMN |
VARCHAR |
Column name. |
MAX_PARTITION_OBSOLESCENCE_PERCENT |
TINYINT |
Maximum percentage of obsolescent rows in statistics. See the SQL Statistics page for more details. |
MANUAL_NULLS |
BIGINT |
If not null - overrided number of null values. |
MANUAL_DISTINCT |
BIGINT |
If not null - overrided number of distinct values. |
MANUAL_TOTAL |
BIGINT |
If not null - overrided total number of values. |
MANUAL_SIZE |
INT |
If not null - overrided average size of non null values in column. |
VERSION |
BIGINT |
Configuration version. |
STATISTICS_LOCAL_DATA
The STATISTICS_LOCAL_DATA view contains SQL statistics for locally managed (or stored) data. This view is node-specific, so each node has an instance of the view that contains information about its local data statistics.
Column | Data Type | Description |
---|---|---|
SCHEMA |
VARCHAR |
Schema name. |
TYPE |
VARCHAR |
Object type. |
NAME |
VARCHAR |
Object name. |
COLUMN |
VARCHAR |
Column name. |
ROWS_COUNT |
BIGINT |
Count of column rows. |
DISTINCT |
BIGINT |
Number of unique non-null values. |
NULLS |
BIGINT |
Number of null values. |
TOTAL |
BIGINT |
Total number of values in column. |
SIZE |
INTEGER |
Average value size in bytes. |
VERSION |
BIGINT |
Statistics version. |
LAST_UPDATE_TIME |
VARCHAR |
Maximum time of all partition statistics which was used to generate local one. |
STATISTICS_PARTITION_DATA
The STATISTICS_PARTITION_DATA view contains information about SQL statistics on every partition data stored on a local node.
Column | Data Type | Description |
---|---|---|
SCHEMA |
VARCHAR |
Schema name. |
TYPE |
VARCHAR |
Object type. |
NAME |
VARCHAR |
Object name. |
COLUMN |
VARCHAR |
Column name. |
PARTITION |
INTEGER |
Partition number. |
ROWS_COUNT |
BIGINT |
Count of column rows. |
UPDATE_COUNTER |
BIGINT |
Partition counter update when statistics are collected. |
DISTINCT |
BIGINT |
Number of unique non-null values. |
NULLS |
BIGINT |
Number of null values. |
TOTAL |
BIGINT |
Total number of values in column. |
SIZE |
INTEGER |
Average value size in bytes. |
VERSION |
BIGINT |
Statistics version. |
LAST_UPDATE_TIME |
VARCHAR |
Maximum time of all partition statistics which was used to generate local one. |
Examples
To query the system views using the SQLLine tool, connect to the SYS schema as follows:
./sqlline.sh -u jdbc:ignite:thin://127.0.0.1/SYS
If your node is running on a remote server, replace 127.0.0.1
with the IP address of the server.
Run a query:
-- get the list of nodes
select * from NODES;
-- view the CPU load as a percentage for a specific node
select CUR_CPU_LOAD * 100 from NODE_METRICS where NODE_ID = 'a1b77663-b37f-4ddf-87a6-1e2d684f3bae'
The same example using Java Thin Client:
ClientConfiguration cfg = new ClientConfiguration().setAddresses("127.0.0.1:10800");
try (IgniteClient igniteClient = Ignition.startClient(cfg)) {
// getting the id of the first node
UUID nodeId = (UUID) igniteClient.query(new SqlFieldsQuery("SELECT * from NODES").setSchema("SYS"))
.getAll().iterator().next().get(0);
double cpu_load = (double) igniteClient
.query(new SqlFieldsQuery("select CUR_CPU_LOAD * 100 from NODE_METRICS where NODE_ID = ? ")
.setSchema("SYS").setArgs(nodeId.toString()))
.getAll().iterator().next().get(0);
System.out.println("node's cpu load = " + cpu_load);
} catch (ClientException e) {
System.err.println(e.getMessage());
} catch (Exception e) {
System.err.format("Unexpected failure: %s\n", e);
}
You can also query system views in the Control Center UI, form the SQL screen. Add SYS.
before the view name; for example: select * FROM SYS.CLIENT_CONNECTIONS;
.
© 2024 GridGain Systems, Inc. All Rights Reserved. Privacy Policy | Legal Notices. GridGain® is a registered trademark of GridGain Systems, Inc.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.