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

Show running queries 

Following statement lists all executing queries.

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

Stopping a query 

To stop a query:

KILL QUERY <id>

The query identifier can be obtained by the previous command.

Show historical queries 

To list current and historical queries:

SHOW ALL QUERIES