LIST STATS

Syntax

LIST STATS [FROM start_date TO end_date] [NODE nodeid] [MEMORY]

Privileges

CLUSTERADMIN

Description

The LIST STATS command retrieves statistic information from the connected node (or from a specific nodeid if the NODE parameter is used). If no range date is specified with the FROM/TO parameters, then stats from the last hour are returned. If the MEMORY argument is used, then a new PHYSICAL_MEMORY key is added to the result.

Return

A Rowset with the following columns:

  • datetime: the data time of the stat
  • key: stat name
  • value: stat value

Example

> LIST STATS
---------------------|-----------------|--------------------|
 datetime            | key             | value              |
---------------------|-----------------|--------------------|
 2023-02-09 09:21:51 | BYTES_IN        | 312                |
 2023-02-09 09:21:51 | BYTES_OUT       | 943                |
 2023-02-09 09:21:51 | CPU_LOAD        | 0.0185958557811852 |
 2023-02-09 09:21:51 | CURRENT_CLIENTS | 1                  |
 2023-02-09 09:21:51 | CURRENT_MEMORY  | 1640640            |
 2023-02-09 09:21:51 | MAX_CLIENTS     | 1                  |
 2023-02-09 09:21:51 | MAX_MEMORY      | 1802512            |
 2023-02-09 09:21:51 | NUM_COMMANDS    | 7                  |
 2023-02-09 09:21:51 | NUM_READS       | 0                  |
 2023-02-09 09:21:51 | NUM_WRITES      | 0                  |
 2023-02-09 09:22:51 | BYTES_IN        | 312                |
 2023-02-09 09:22:51 | BYTES_OUT       | 943                |
 2023-02-09 09:22:51 | CPU_LOAD        | 0.0184632834613829 |
 2023-02-09 09:22:51 | CURRENT_CLIENTS | 1                  |
 2023-02-09 09:22:51 | CURRENT_MEMORY  | 1640640            |
 2023-02-09 09:22:51 | MAX_CLIENTS     | 1                  |
 2023-02-09 09:22:51 | MAX_MEMORY      | 1802512            |
 2023-02-09 09:22:51 | NUM_COMMANDS    | 7                  |
 2023-02-09 09:22:51 | NUM_READS       | 0                  |
 2023-02-09 09:22:51 | NUM_WRITES      | 0                  |
 2023-02-09 09:23:51 | BYTES_IN        | 312                |
 2023-02-09 09:23:51 | BYTES_OUT       | 943                |
 2023-02-09 09:23:51 | CPU_LOAD        | 0.0184403868930122 |
 2023-02-09 09:23:51 | CURRENT_CLIENTS | 1                  |
 2023-02-09 09:23:51 | CURRENT_MEMORY  | 1640640            |
 2023-02-09 09:23:51 | MAX_CLIENTS     | 1                  |
 2023-02-09 09:23:51 | MAX_MEMORY      | 1802512            |
 2023-02-09 09:23:51 | NUM_COMMANDS    | 7                  |
 2023-02-09 09:23:51 | NUM_READS       | 0                  |
 2023-02-09 09:23:51 | NUM_WRITES      | 0                  |
 2023-02-09 09:24:52 | BYTES_IN        | 312                |
 2023-02-09 09:24:52 | BYTES_OUT       | 943                |
 2023-02-09 09:24:52 | CPU_LOAD        | 0.0183631842713955 |
 2023-02-09 09:24:52 | CURRENT_CLIENTS | 1                  |
 2023-02-09 09:24:52 | CURRENT_MEMORY  | 1640640            |
 2023-02-09 09:24:52 | MAX_CLIENTS     | 1                  |
 2023-02-09 09:24:52 | MAX_MEMORY      | 1802512            |
 2023-02-09 09:24:52 | NUM_COMMANDS    | 7                  |
 2023-02-09 09:24:52 | NUM_READS       | 0                  |
 2023-02-09 09:24:52 | NUM_WRITES      | 0                  |
---------------------|-----------------|--------------------|