$SNAPSHOT_DB

数据库快照可以列出当前数据库节点中主要的状态与性能监控参数。

通过协调节点查询快照，将返回所有节点的快照信息，每个数据节点或编目节点产生一条记录；通过数据节点或编目节点查询快照，将返回当前节点的快照信息。

标识

$SNAPSHOT_DB

字段信息

示例

查看数据库快照

> db.exec( "select * from $SNAPSHOT_DB" )

输出结果如下：

{
  "NodeName": "hostname:41000",
  "HostName": "hostname",
  "ServiceName": "41000",
  "GroupName": "group2",
  "IsPrimary": true,
  "ServiceStatus": true,
  "Status": "Normal",
  "FTStatus": "",
  "BeginLSN": {
    "Offset": -1,
    "Version": 0
  },
  "CurrentLSN": {
    "Offset": -1,
    "Version": 0
  },
  "CommittedLSN": {
    "Offset": -1,
    "Version": 0
  },
  "CompleteLSN": 0,
  "LSNQueSize": 0,
  "TransInfo": {
    "TotalCount": 0,
    "BeginLSN": -1
  },
  "NodeID": [
    1001,
    1001
  ],
  "Version": {
    "Major": 3,
    "Minor": 4,
    "Fix": 8,
    "Release": 43611,
    "GitVersion": "e0b89a77ec66e4ccecdc02b085029bca4c7aef4a",
    "Build": "2022-10-08-12.27.37(Enterprise Debug)"
  },
  "Edition": "Enterprise",
  "CurrentActiveSessions": 27,
  "CurrentIdleSessions": 9,
  "CurrentSystemSessions": 12,
  "CurrentTaskSessions": 6,
  "CurrentContexts": 1,
  "ReceivedEvents": 26,
  "Role": "data",
  "Disk": {
    "DatabasePath": "/opt/sequoiadb/database/data/11830/",
    "LoadPercent": 0,
    "TotalSpace": 754868568064,
    "FreeSpace": 622475874304
  },
  "TotalNumConnects": 0,
  "TotalQuery": 26,
  "TotalSlowQuery": 0,
  "TotalTransCommit": 0,
  "TotalTransRollback": 0,
  "TotalDataRead": 0,
  "TotalIndexRead": 0,
  "TotalDataWrite": 0,
  "TotalIndexWrite": 0,
  "TotalUpdate": 0,
  "TotalDelete": 0,
  "TotalInsert": 0,
  "ReplUpdate": 0,
  "ReplDelete": 0,
  "ReplInsert": 0,
  "TotalSelect": 0,
  "TotalRead": 0,
  "TotalLobGet": 0,
  "TotalLobPut": 0,
  "TotalLobDelete": 0,
  "TotalLobList": 0,
  "TotalLobReadSize": 0,
  "TotalLobWriteSize": 0,
  "TotalLobRead": 0,
  "TotalLobWrite": 0,
  "TotalLobTruncate": 0,
  "TotalLobAddressing": 0,
  "TotalReadTime": 0,
  "TotalWriteTime": 0,
  "ActivateTimestamp": "2022-10-09-09.34.53.243408",
  "ResetTimestamp": "2022-10-09-09.34.53.243408",
  "UserCPU": "6.480000",
  "SysCPU": "4.630000",
  "freeLogSpace": 1342177280,
  "vsize": 2973097984,
  "rss": 52417,
  "fault": 0,
  "TotalMapped": 142868480,
  "svcNetIn": 0,
  "svcNetOut": 0,
  "shardNetIn": 11188,
  "shardNetOut": 102525,
  "replNetIn": 0,
  "replNetOut": 0,
  "SchdlrType": 0,
  "SchdlrTypeDesp": "NONE",
  "Run": 1,
  "Wait": 0,
  "SchdlrMgrEvtNum": 0,
  "SchdlrTimes": 0,
  "MemPoolSize": 100581376
}
...