System Monitoring
SHOW SYSTEM VIEWS
This view has a single row for every system view and a short description of its content.
The output is ordered by the view_name column.
The following table lists the output’s columns:
| Column name | Data type | Description |
|---|---|---|
VIEW_NAME | VARCHAR(127) | The system view name. A filter column. |
FILTER_COLUMN | VARCHAR(127) | The column by which clients can filter the view |
IN_PARAM | VARCHAR(20) | The object type by which the view can be filtered (TABLE | INDEX | DEVICE | NULL) |
ORDER_BY_COLUMNS | VARCHAR(127) | The columns by which the view is ordered |
DESCRIPTION | VARCHAR(1000) | A short description on the view content |
The following table lists the available system views and their description:
| view name | filter column | IN_param | ordered by columns | description |
|---|---|---|---|---|
show columns | column_name | TABLE | table_name,column_name | show the columns of all the tables in the database |
show constraints | table_name | TABLE | table_name | show all the constraints in the database |
show database metrics | metric_name | DEVICE | metric_name | shows all the database metrics and their values |
show device metrics | metric_name | DEVICE | metric_name,device_id | show all the devices metrics and their values |
show devices | device_id | -- | device_id | show all the devices of the database |
show index devices | device_id | INDEX | device_id | show all the devices of a specific index |
show indexes | index_name | TABLE | table_name,index_name | show all the indexes in the database |
show metric description | metric_name | -- | metric_name | show all the database metrics and their description |
show module metrics | metric_name | -- | metric_name,module_id | show all the modules metrics and their values |
show modules | Module_role | -- | Module_role,node_name | show all the modules in the cluster |
show nodes | node_name | -- | node_name | show all the nodes in the cluster |
show system views | view_name | -- | view_name | show this view |
show table devices | device_id | TABLE | device_id | show the devices of a specific table |
show tables | table_name | -- | table_name | show all the tables in the database |
show transactions | null | -- | start_time | show all the active transactions in the database |
show users | user_name | -- | user_name | show all the users in the database |