STATEMENTMETRICSINFO System Table Description

Description

Information about the metrics available in the METRICS column of the CONNECTIONS system table.

Fields

Field Type Description

NAME

string

The name of the metric, as it appears in the METRICS column of SYSTEM tables.

TYPE

string

Type of metric value.
Possible values:

  • counter

  • timer

UNITS

string

Units of the metric value.

Possible values:

  • integer (a count)

  • bytes (number of bytes)

  • microseconds (duration in microseconds)

MINIMUM

bigint

Minimum value the metric may contain. If there is no minimum, the value is <null>.

MAXIMUM

bigint

Maximum value the metric may contain. If there is no maximum, the value is <null>.

DESCRIPTION

string

A description of the metric

Indexes

None

Example

SELECT NAME,TYPE FROM SYSTEM.STATEMENTMETRICSINFO;
       NAME          TYPE
-------------------- -------
total-time           timer
row-lock-time        timer
table-lock-time      timer
total-memory         counter
atom-memory          counter
atoms-cached         counter
atoms-fetched        counter
open-time            timer
complete-time        timer
network-size         counter
load-size            counter
load-time            timer