查询快照

查询快照可以列出数据库中正在进行的查询信息和历史慢查询信息。当 mongroupmask 参数设置为“slowQuery:detail”或“all:detail”时，查询耗时超过 monslowquerythreshold 参数所规定阈值的历史查询信息会被缓存。用户可以通过指定 viewHistory 选项，查看当前或历史查询信息。默认为查看历史慢查询信息。

Note:

每一个数据节点上正在进行的每一个查询操作为一条记录。

标识

SDB_SNAP_QUERIES

协调节点字段信息

ClientInfo 字段中信息

数据节点字段信息

SlowSyncInfo 字段中信息

示例

• 查看协调节点的查询信息

  > db.snapshot(SDB_SNAP_QUERIES)

  输出结果如下：

  {
   "NodeName": "sdbserver:11810",
   "NodeID": [
     2,
     4
   ],
   "StartTimestamp": "2024-03-19-20.53.23.574220",
   "EndTimestamp": "--",
   "TID": 52917,
   "OpType": "QUERY",
   "Name": "foo.bar",
   "QueryTimeSpent": 2.839,
   "DispatchTimeSpent": 0,
   "MsgSentTime": 0.167,
   "ReplyTimeSpent": 0.157,
   "QueryCataTime": 0,
   "RemoteNodeWaitTime": 2.197,
   "BlockTime": 0,
   "SortTime": 0,
   "TotalMsgSent": 5,
   "TotalReplyCount": 1,
   "QueryCataCount": 0,
   "ReturnNum": 1600,
   "QueryID": "0x0000ceb500049feb00000008",
   "RelatedNID": 4,
   "RelatedTID": 52917,
   "SessionID": 7352,
   "ClientInfo": {
     "ClientTID": 52911,
     "ClientHost": "192.168.30.64"
   },
   "RelatedNode": [
     1003
   ],
   "LastOpInfo": "Collection:foo.bar, Matcher:{ \"a\": { \"$type\": 2, \"$et\": \"double\" } }, Selector:{}, OrderBy:{ \"_id\": 1 }, Hint:{}, Skip:0, Limit:-1, Flag:0x00004200(16896)"
  }

• 查看数据节点的查询信息

  > var data = new Sdb("sdbserver", 11820)
  > data.snapshot(SDB_SNAP_QUERIES)

  输出结果下：

  {
   "NodeName": "sdbserver:11820",
   "NodeID": [
     1002,
     1003
   ],
   "StartTimestamp": "2024-03-19-20.57.51.001284",
   "EndTimestamp": "--",
   "TID": 57980,
   "OpType": "QUERY",
   "Name": "foo.bar",
   "QueryTimeSpent": 4.027,
   "DispatchTimeSpent": 0.102,
   "MsgSentTime": 0,
   "ReplyTimeSpent": 0.077,
   "QueryCataTime": 0,
   "RemoteNodeWaitTime": 0,
   "BlockTime": 0,
   "SortTime": 0,
   "TotalMsgSent": 0,
   "TotalReplyCount": 1,
   "ReturnNum": 100,
   "QueryID": "0x00010176000452c700000071",
   "RelatedNID": 4,
   "RelatedTID": 65910,
   "SessionID": 1444,
   "AccessPlanID": 2491,
   "HashCode": 6179654,
   "DataRead": 100,
   "DataWrite": 0,
   "IndexRead": 0,
   "IndexWrite": 0,
   "LobRead": 0,
   "LobWrite": 0,
   "LobTruncate": 0,
   "LobAddressing": 0,
   "TransLockWaitTime": 0,
   "LatchWaitTime": 0,
   "SyncWaitTime": 0,
   "FileOPTime": 3.01,
   "LogOPTime": 0,
   "TransLockWaitCount": 0,
   "LatchWaitCount": 0,
   "SyncWaitCount": 0,
   "LastOpInfo": "Collection:foo.bar, Matcher:{ \"a\": { \"$type\": 2, \"$et\": \"double\" } }, Selector:{}, OrderBy:{ \"_id\": 1 }, Hint:{}, Skip:0, Limit:-1, Flag:0x00004200(16896)"
  }

• 查看历史查询记录

  > db.snapshot(SDB_SNAP_QUERIES, new SdbSnapshotOption().options({"viewHistory":true}))

  输出结果如下：

  {
   "NodeName": "sdbserver:11810",
   "NodeID": [
     2,
     4
   ],
   "StartTimestamp": "2024-03-19-21.05.04.882779",
   "EndTimestamp": "2024-03-19-21.05.05.981709",
   "TID": 70878,
   "OpType": "QUERY",
   "Name": "foo.bar",
   "QueryTimeSpent": 1061.201,
   "DispatchTimeSpent": 0,
   "MsgSentTime": 0.981,
   "ReplyTimeSpent": 0.393,
   "QueryCataTime": 0,
   "RemoteNodeWaitTime": 1058.26,
   "BlockTime": 0,
   "SortTime": 0,
   "TotalMsgSent": 22,
   "TotalReplyCount": 2,
   "QueryCataCount": 0,
   "ReturnNum": 21,
   "QueryID": "0x000114de000486fd00000005",
   "RelatedNID": 4,
   "RelatedTID": 70878,
   "SessionID": 9448,
   "ClientInfo": {
     "ClientTID": 70777,
     "ClientHost": "192.168.30.64"
   },
   "RelatedNode": [
     3,
     1003,
     1005,
     1008
   ],
   "LastOpInfo": "Collection:foo.bar, Matcher:{ \"a\": 10000 }, Selector:{}, OrderBy:{}, Hint:{}, Skip:0, Limit:-1, Flag:0x00004200(16896)"
  }