命令和查询管理Commands and queries management
.show commands-and-queries.show commands-and-queries
.show
commands-and-queries
返回一个表,其中包含已达到最终状态的管理员命令和查询。.show
commands-and-queries
returns a table with admin commands and queries that have reached a final state. 这些命令和查询的可用时间为 30 天。These commands and queries are available for 30 days.
此命令的输出中显示的信息类似于 .show commands 和 .show queries 命令,但是它实际上上允许你以简单方式联接两个结果集。The information presented in the output of the command is similar to .show commands and .show queries, however it essentially lets you join both result sets in a simple manner.
语法Syntax
.show
commands-and-queries
.show
commands-and-queries
输出Output
输出架构如下所示:The output schema is as follows:
ColumnNameColumnName | ColumnTypeColumnType |
---|---|
ClientActivityIdClientActivityId | stringstring |
CommandTypeCommandType | stringstring |
文本Text | stringstring |
数据库Database | stringstring |
StartedOnStartedOn | datetimedatetime |
LastUpdatedOnLastUpdatedOn | datetimedatetime |
持续时间Duration | timespantimespan |
StateState | 字符串string |
FailureReasonFailureReason | stringstring |
RootActivityIdRootActivityId | GUIDguid |
UserUser | stringstring |
应用程序Application | stringstring |
主体Principal | stringstring |
ClientRequestPropertiesClientRequestProperties | 动态dynamic |
TotalCpuTotalCpu | timespantimespan |
MemoryPeakMemoryPeak | longlong |
CacheStatisticsCacheStatistics | 动态dynamic |
ScannedExtentsStatisticsScannedExtentsStatistics | 动态dynamic |
ResultSetStatisticsResultSetStatistics | 动态dynamic |
备注
对于查询,CommandType
的值为 Query
。For queries, the value of CommandType
is Query
.