「SequoiaDB巨杉数据库」explain()概述4

示例

• 普通表的访问计划

  {
    "Name": "sample.employee",
    "ScanType": "ixscan",
    "IndexName": "$shard",
    "UseExtSort": false,
    "Query": {
      "$and": [
        {
          "a": {
            "$gt": 1
          }
        }
      ]
    },
    "IXBound": {
      "a": [
        [
          1,
          {
            "$maxElement": 1
          }
        ]
      ]
    },
    "NeedMatch": false,
    "NodeName": "hostname:11830",
    "GroupName": "group",
    "Role": "data",
    "ReturnNum": 0,
    "ElapsedTime": 0.000107,
    "IndexRead": 0,
    "DataRead": 0,
    "UserCPU": 0,
    "SysCPU": 0
  }

   

• 垂直分区的访问计划

  {
    "NodeName": "hostname:11830",
    "GroupName": "group",
    "Role": "data",
    "Name": "maincs.maincl",
    "SubCollections": [
      {
        "Name": "subcs.subcl1",
        "ScanType": "tbscan",
        "IndexName": "",
        "UseExtSort": false,
        "Query": {
          "$and": []
        },
        "IXBound": null,
        "NeedMatch": false,
        "ReturnNum": 0,
        "ElapsedTime": 0.000088,
        "IndexRead": 0,
        "DataRead": 0,
        "UserCPU": 0,
        "SysCPU": 0
      },
      {
        "Name": "subcs.subcl2",
        "ScanType": "tbscan",
        "IndexName": "",
        "UseExtSort": false,
        "Query": {
          "$and": []
        },
        "IXBound": null,
        "NeedMatch": false,
        "ReturnNum": 0,
        "ElapsedTime": 0.000089,
        "IndexRead": 0,
        "DataRead": 0,
        "UserCPU": 0,
        "SysCPU": 0
      }
    ]
  }

   

• 协调节点上的虚拟访问计划，即匹配符不能命中任何分区

  {
    "NodeName": "hostname:11810",
    "GroupName": "SYSCoord",
    "Role": "coord",
    "Collection": "maincs.maincl",
    "Query": {
      "a": 10000000
    },
  }

   

• 查看查询的普通访问计划，并使用 Run 选项执行查询

  db.sample.employee.find( { a : { $gt : 100 } } ).explain( { Run : true } )
  {
    "NodeName": "hostname:11810",
    "GroupName": "group1",
    "Role": "data",
    "Name": "sample.employee",
    "ScanType": "tbscan",
    "IndexName": "",
    "UseExtSort": false,
    "Query": {
      "$and": [
        {
          "a": {
            "$gt": 100
          }
        }
      ]
    },
    "IXBound": null,
    "NeedMatch": true,
    "ReturnNum": 49892,
    "ElapsedTime": 0.323423,
    "IndexRead": 0,
    "DataRead": 49945,
    "UserCPU": 0.1399999999999999,
    "SysCPU": 0
  }
  {
    "NodeName": "hostname:11820",
    "GroupName": "group2",
    "Role": "data",
    "Name": "sample.employee",
    "ScanType": "tbscan",
    "IndexName": "",
    "UseExtSort": false,
    "Query": {
      "$and": [
        {
          "a": {
            "$gt": 100
          }
        }
      ]
    },
    "IXBound": null,
    "NeedMatch": true,
    "ReturnNum": 50007,
    "ElapsedTime": 0.41887,
    "IndexRead": 0,
    "DataRead": 50055,
    "UserCPU": 0.1400000000000006,
    "SysCPU": 0.009999999999999787
  }

  点击巨杉数据库文档中心了解更多信息