Managing Queries

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.

SHOW 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.

Show queries

With this statement, a user can see the list of currently executing queries as well as the recently executed ones:

SHOW ALL QUERIES