This section introduces the supported commands to control the running queries. As an administrator, you want to know the queries executed currently. For that, the engine supports the following statements: SHOW QUERIES, SHOW ALL QUERIES, KILL QUERY.
Show running queries¶
Following statement lists all executing queries.
The response lists for each entry the unique identifier for the query, the code running, the user executing the request, when it was started as well as metrics on records read and data scanned.
Stopping a SQL query¶
If a query is running and it needs to be stopped, it can be achieved by executing
KILL QUERY <id>
The query identifier can be obtained by the previous command. Once this command is executed, the running query is terminated.
With this statement, a user can see the list of currently executing queries as well as the recently executed ones:
SHOW ALL QUERIES