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.
- To see both queries and commands completion, use .show queries-and-commands
Syntax
.show
queries
- Returns a table containing previously run queries and their completion statistics. You can use KQL queries to explore the results.
- Note: the text of the query is truncated after 64KB.
Output
The output schema is as follows:
ColumnName | ColumnType | Description |
---|---|---|
ClientActivityId | string | Client ID of the request |
Text | string | Query text, truncated at 64 KB |
Database | string | Name of the database on which the query was executed |
StartedOn | datetime | Timestamp when query execution started |
LastUpdatedOn | datetime | Timestamp of the last status update |
Duration | timespan | Server-side query duration |
State | string | Completion state |
RootActivityId | guid | Server-side request ID |
User | string | User ID that ran the query |
FailureReason | string | Failure reason. If query succeeded, this field is empty. |
TotalCpu | timespan | Total CPU consumed by the query |
CacheStatistics | dynamic | Data-cache usage statistics |
Application | string | Name of the application that was used to run the query |
MemoryPeak | long | Peak memory statistics |
ScannedExtentsStatistics | dynamic | Statistics of the scanned shards (extents) |
Principal | string | AAD-ID of the user or application that was used to run the query |
ClientRequestProperties | dynamic | Client request properties |
ResultSetStatistics | dynamic | Statistics describing returned data set |
WorkloadGroup | string | Name of the workload group that query was associated with |
Example
.show queries
| project Text, Duration
| take 3
Text | Duration |
---|---|
T |count | 00:00:00 |
T | summarize count() by column1 | 00:00:00.0312564 |
T | take 10 | 00:00:00.0155632 |
.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
- 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
ClientRequestId
property, as astring
literal.ReasonPhrase: If specified, a
string
literal 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"
Feedback
Submit and view feedback for