Contains information about the dynamic system data metrics (see Dynamic System Data).

The output is ordered by the metric_name column.

Note: All the metrics are for the current time and not historical or cumulative.

The following table lists the output’s columns:

Column nameData typeDescription
METRIC_NAMEVARCHAR(255)

Unique short name for the metric. This is the filter column.

Note that some metrics appear in more than 1 view (in both SHOW DATABASE METRICS and SHOW MODULE METRICS).

METRIC_IDINTThe unique metric identifier.
DESCRIPTIONVARCHAR(4000)Metric description.

The following table lists the available metrics and their descriptions:

Metric idName in SHOW METRIC DESCRIPTION viewDescription in SHOW METRIC DESCRIPTION view
23Average CPU usage percentageThe average CPU usage percentage
22Average memory usage percentageThe average memory usage percentage
0Deadlock detections rateThe deadlock detections rate per second
1DELETE statements average latencyThe average execution time of successful DELETE statements in milliseconds
2DELETE statements rateThe rate of successful DELETE statements per second
1000Device row data consumption percentageThe amount of space used for table rows data, as percentage of the device capacity. (This metric includes capacity reserved for internal operations.)
1001Device metadata consumption percentageThe amount of space used for metadata associated with table rows, including indexes, as percentage of the device capacity.
3Inbound network throughputThe inbound (from the Client to Regatta) network throughput
4Index entry reads rateThe rate of index entry reads per second
5Index updates rateThe index updates rate per second
6INSERT statements average latencyThe average execution time of successful INSERT statements in milliseconds
7INSERT statements rateThe rate of successful INSERT statements per second
8Longest active statement timeThe time of the longest currently active statement in seconds
9Number of active transactionsThe number of active transactions
10Number of open clients connectionsThe number of open clients connections
11Outbound network throughputThe outbound (from Regatta to the Client) network throughput
12Row deletions rateThe rate of row deletions per second
13Row insertions rateThe rate of row insertions per second
14Row output rateThe rate of rows returned in result sets per second
15Row updates rateThe rate of row updates per second
16Statements error rateThe rate of failed statements per second
24SELECT statements average latencyThe average execution time of successful SELECT statements in milliseconds
25SELECT statements rateThe rate of successful SELECT statements per second
17Table row reads rateThe rate of row reads per second
28Transaction aborts rateThe rate of transactions aborted per second
19Transactions in conflict wait rateThe rate of transactions waiting to commit, due to conflicts with other transactions, per second
20UPDATE statements average latencyThe average execution time of successful UPDATE statements in milliseconds
21UPDATE statements rateThe rate of successful UPDATE statements per second
Note that INSERT AS SELECT is counted as both INSERT and SELECT statements.