Queries management
.show queries
The .show queries command returns a list of queries that have reached a final state, and that the user invoking the command has access to see:
- A database admin or database monitor can see any command that was invoked on their database.
- Other users can only see queries that were invoked by them.
Syntax
.show queries
.show running queries
The .show running queries command returns a list of currently-executing queries
by the user, or by another user, or by all users.
Syntax
.show running queries
- (1) returns the currently-executing queries by the invoking user (requires read access).
.cancel query
The .cancel query command starts a best-effort attempt to cancel a specific
running query.
- Cluster admins can cancel any running query.
- Database admins can cancel any running query that was invoked on a database they have admin access on.
- All principals can cancel running queries that they started.
Syntax
.cancel query ClientRequestId [with ( reason = ReasonPhrase )]
ClientRequestId is the value of the running query's
ClientRequestIdproperty, as astringliteral.ReasonPhrase: If specified, a
stringliteral that describes the reason for canceling the running query. This information is included in the query results if it's successfully canceled.
Example
.cancel query "KE.RunQuery;8f70e9ab-958f-4955-99df-d2a288b32b2c"