命令和查询管理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 的值为 QueryFor queries, the value of CommandType is Query.