Manage running 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, Lenses supports the following statements:
- SHOW QUERIES
- SHOW ALL QUERIES
- KILL QUERY
Following statement lists all executing queries.
The response contains:
- the unique identifiers for each running the query
- the query running
- the user executing the request
- when it was started as well as metrics on records read and data scanned.
To stop a query:
KILL QUERY <id>
The query identifier can be obtained by the previous command.
To list current and historical queries:
SHOW ALL QUERIES