SHOW DEVICE METRICS

This view returns the current metrics of the cluster devices. Ordered by the (metric_name, device_id) columns. Data can be filtered with the IN DEVICE device_id parameter. The following table lists the output’s columns:

Column name	Data type	Description
METRIC_NAME	`VARCHAR(255)`	Unique short name for the metric. This is the filter column.
METRIC_ID	`INT`	The unique metric identifier. Correlates to SHOW METRIC DESCRIPTION.
MODULE_ID	`INT`	The identifier of the module
DEVICE_ID	`VARCHAR(32)`	The unique device identifier.
VALUE	`INT`	Current value for the metric (rounded up)
QUERY_TIMESTAMP	`TIMESTAMP`	Represent the query time. The output of `current_timestamp` function.

SHOW MODULE METRICS The SYSTEM Command

SQL Specification

Data Types

SQL Syntax Conventions

Data Definition Language (DDL) Commands

Data Manipulation Language Commands

Transaction Control Language Commands

Data Query Language

Hints

SQL Functions and Operators

Managing Users

System Monitoring

Appendices

SHOW DEVICE METRICS