.show queries command

The .show queries command lists queries on the cluster that have reached a final state, and that the user invoking the command has access to see. Optionally, the command can return queries that are still running, queries by specific users, or queries grouped by user. To see both queries and commands completion, use .show queries-and-commands.

Permissions

A Database Admin or Database Monitor can see any command invoked on the database. Other users can only see their queries.

Syntax

.show queries

.show running queries [ by user UserPrincipalName]

Learn more about syntax conventions.

Parameters

Name Type Required Description
UserPrincipalName string The UPN of a specific user for which to return a list of queries.

Returns

  • Returns a table containing previously run queries across all databases in the cluster and their completion statistics. You can use KQL queries to explore the results.
  • Returns a list of currently executing queries by the current user, or by another user, or by all users.

Note

The text of the query is truncated after 64 KB.

The returned table schema is:

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 dataset
WorkloadGroup string Name of the workload group that query was associated with

Examples

Show completed queries

.show queries 
| project Text, Duration
| take 10

Output

Text Duration
StormEvents | sort by DeathsDirect desc 00:00:00.2343761
StormEvents | sort by DeathsDirect desc 00:00:00.2187503
StormEvents | sort by DeathsDirect desc 00:00:00.2343115
StormEvents | sort by DamageProperty desc 00:00:00.2656510
StormEvents | sort by StartTime desc 00:00:00.2343012
StormEvents | sort by StartTime desc 00:00:00.2813042
StormEvents | sort by StartTime desc 00:00:00.3594493
TestFunction(5) 00:00:00.0312024
traceAgg(now(5500d)) 00:00:00.0312952
traceAgg(now(-5500d)) 00:00:00.0312445

Show running queries by the current user

.show running queries 

Show running queries by a specified user

.show running queries by user <UserPrincipalName>