system queries
Loads the status of all queries that are currently being executed. The administrator can load all queries executed on the system, and the normal user account can only load queries executed by itself.
Syntax
system queries
Description
When you execute this command, the command returns a record containing the execution history of the query.
The record consists of the following fields.
Field | Type | Description |
---|---|---|
id | Integer | Query identifier |
query_string | String | Query string |
is_eof | Boolean | Whether the query is terminated (true : terminated, false : being executed) |
is_end | Boolean | Whether the query is terminated (true : terminated, false : being executed) |
is_cancelled | Voolean | Whether the query is canceled (true : canceled, false : not canceled) |
start_time | Long | Query start time (unit: epoch ) |
finish_time | Long | Query finish time (unit: epoch ) |
last_started | Date | Last refresh time |
elapsed | Long | Time required to execute the query (unit: ms ), If the query has not started, null |
background | Boolean | Whether to execute in the background (true : Background query, false : Not a background query) |
commands | Object | Execution status for each detailed command |
sub_queries | Array | Subquery list |
is_scheduled_query | Boolean | Whether the query is scheduled (true : Scheduled query , false: Not a scheduled query) |
login_name | String | The account that executes the query |
remote_ip | String | The access IP address of the account that executes the query |
rows | Long | The number of records returned as a result of executing the query |
Note
'is_end' is a legacy field left for backward compatibility. Use 'is_eof' instead of 'is_end' when referencing the results of the "system queries" command in a query.