explain - 获取查询的访问计划
query.explain( [options] )
SdbQuery
获取查询的访问计划。
| 参数名 | 参数类型 | 描述 | 是否必填 |
|---|---|---|---|
| options | BSON 对象 | 访问计划执行参数 | 否 |
options 参数详细说明如下：
| 参数名 | 参数类型 | 描述 | 默认值 |
|---|---|---|---|
| Run | 布尔型 | 表示是否执行访问计划。 Run 选项为 true 表示执行访问计划，获取数据和时间信息。 Run 选项为 false 表示只获取访问计划的信息，并不执行。 |
false |
| Detail | 布尔型 | 表示是否展示更详细的访问计划，展示涉及访问计划的协调节点、数据节点及相关的上下文信息。 Detail 选项为 true 表示展示详细的访问计划。 Detail 选项为 true 时默认展示一层详细的访问计划，需要使用 Expand 选项展示所有详细的访问计划。 Detail 选项为 false 表示不展示详细的访问计划。 |
false |
| Estimate | 布尔型 | 表示是否展示详细的访问计划中的估算部分。 Estimate 选项为 true 表示展示详细的访问计划中的估算部分。 Estimate 选项为 false 表示不展示详细的访问计划中的估算部分。 如果 Estimate 选项显式设置，Detail 自动设置为 true。 |
Detail 选项的值 |
| Expand | 布尔型 | 表示是否展示详细的访问计划中的多层信息。 Expand 选项为 true 表示展示详细的访问计划中的多层信息。 Expand 选项为 false 表示仅展示一层详细的访问计划，该层的子层将不展开。 如果 Expand 选项显式设置，Detail 自动设置为 true。 |
false |
| Flatten | 布尔型 | 表示是否展开每个节点和每个子表的访问计划的输出结果作为一条记录。 Flatten 选项为 true 表示展开输出结果。 Flatten 选项为 false 表示不展开输出结果，并组合成数组挂在上一级节点或者主表上展示。 如果 Flatten 选项显式设置，Detail 选项和 Expand 选项自动设置为 true。 |
false |
| Filter | 字符串 或者 数组 | 表示对估算结果（Estimate 选项）的细节进行过滤。 Filter 选项为可以选择 "None"、"Output"、"Input"、"Filter"、"All"，或者其组合数组。 Filter 选项为 [] 或者 null 表示为 "None"。 1. "None" 表示不输出估算结果的任何细节。 2. "Input" 表示输出估算结果的输入细节。 3. "Filter" 表示输出估算结果的过滤细节。 4. "Output" 表示输出估算结果的输出细节。 5. "All" 表示输出估算结果的全部细节。 如果 Filter 选项显式设置，Detail 选项和 Estimate 选项自动设置为 true。 |
"All" |
| CMDLocation | BSON 对象 | 表示对访问计划的结果按照数据组进行过滤，使用命令位置参数项。 CMDLocation 选项仅支持 "GroupID" 和 "GroupName" 选项。 详细见 命令位置参数。 如果 CMDLocation 选项显式设置，Detail 选项自动设置为 true。 |
空 |
| SubCollections | 字符串 或者 数组 | 表示对访问计划的结果按照子表进行过滤。 SubCollections 选项只在带有主子表的访问计划时生效。 SubCollections 选项可以选择某个子表名，或者子表名的数组，表示只显示指定子表的访问计划。 SubCollections 选项为 [] 或者 null 表示为不进行过滤。 如果 SubCollections 选项显式设置，Detail 选项自动设置为 true。 |
空 |
| Search | 布尔型 | 表示是否查看查询优化器搜索过的访问计划，并查看查询优化器选择的结果。 Search 选项为 true 表示展示查询优化器的选择过程。 Search 选项为 false 表示不展示查询优化器的选择过程。 如果 Search 选项显式设置，Detail 选项和 Expand 选项自动设置为 true。 |
false |
| Evaluate | 布尔型 | 表示是否查看查询优化器搜索过的访问计划的计算过程。 Evaluate 选项为 true 表示展示查询优化器的计算过程。 Evaluate 选项为 false 表示不展示查询优化器的计算过程。 如果 Evaluate 选项显式设置，Detail 选项、Search 选项和 Expand 选项自动设置成 true。 |
false |
| Abbrev | 布尔型 | 表示是否对过长的字符串进行简略输出。 | false |
返回访问计划的游标，类型为 object 。
如果出错则抛异常，并输出错误信息，可以通过 getLastErrMsg() 获取错误信息或通过 getLastError() 获取错误码。 关于错误处理可以参考常见错误处理指南。
常见错误可参考错误码。
v2.0 及以上版本。
普通表的访问计划
{
"Name": "sample.employee",
"ScanType": "ixscan",
"IndexName": "$shard",
"UseExtSort": false,
"Query": {
"$and": [
{
"a": {
"$gt": 1
}
}
]
},
"IXBound": {
"a": [
[
1,
{
"$maxElement": 1
}
]
]
},
"NeedMatch": false,
"IndexCover": true,
"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,
"IndexCover": 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,
"IndexCover": true,
"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,
"IndexCover": false,
"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,
"IndexCover": false,
"ReturnNum": 50007,
"ElapsedTime": 0.41887,
"IndexRead": 0,
"DataRead": 50055,
"UserCPU": 0.1400000000000006,
"SysCPU": 0.009999999999999787
}使用 Detail 选项查看查询的详细访问计划
> db.sample.employee.find( { a : { $gt : 100 } } ).explain( { Detail : true } )
{
"NodeName": "hostname:11800",
"GroupName": "SYSCoord",
"Role": "coord",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 0,
"ReturnNum": 0,
"ElapsedTime": 0.00123,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"PlanPath": {
"Operator": "COORD-MERGE",
"Sort": {},
"NeedReorder": false,
"DataNodeNum": 2,
"DataNodeList": [
{
"Name": "hostname:11810",
"EstTotalCost": 1.484
},
{
"Name": "hostname:11820",
"EstTotalCost": 0.7418349999999999
}
],
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 1.5214865,
"TotalCost": 1.5214865,
"Output": {
"Records": 74973,
"RecordSize": 29,
"Sorted": false
}
},
"ChildOperators": [
{
"NodeName": "hostname:11810",
"GroupName": "group1",
"Role": "data",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000078,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "HitCache",
"MainCLPlan": false,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
}
},
{
"NodeName": "hostname:11820",
"GroupName": "group2",
"Role": "data",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000081,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "HitCache",
"MainCLPlan": false,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
}
}
]
}
}使用 Detail 选项查看查询的详细访问计划，并使用 Run 选项执行查询
> db.sample.employee.find( { a : { $gt : 100 } } ).explain( { Detail : true, Run : true } )
{
"NodeName": "hostname:11800",
"GroupName": "SYSCoord",
"Role": "coord",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 0,
"ReturnNum": 99899,
"ElapsedTime": 0.82863,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0.01999999999999999,
"SysCPU": 0.009999999999999995,
"PlanPath": {
"Operator": "COORD-MERGE",
"Sort": {},
"NeedReorder": false,
"DataNodeNum": 2,
"DataNodeList": [
{
"Name": "hostname:11820",
"EstTotalCost": 0.7418349999999999,
"QueryTimeSpent": 0.733299,
"WaitTimeSpent": 0.013556
},
{
"Name": "hostname:11810",
"EstTotalCost": 1.484,
"QueryTimeSpent": 0.82677,
"WaitTimeSpent": 0.084652
}
],
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 1.5214865,
"TotalCost": 1.5214865,
"Output": {
"Records": 74973,
"RecordSize": 29,
"Sorted": false
}
},
"Run": {
"ContextID": 29314,
"StartTimestamp": "2017-12-14-15.24.51.254623",
"QueryTimeSpent": 0.821182,
"GetMores": 112,
"ReturnNum": 99899,
"WaitTimeSpent": 0.075
},
"ChildOperators": [
{
"NodeName": "hostname:11820",
"GroupName": "group2",
"Role": "data",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 49892,
"ElapsedTime": 0.733493,
"IndexRead": 0,
"DataRead": 49945,
"UserCPU": 0.14,
"SysCPU": 0.01000000000000001,
"CacheStatus": "HitCache",
"MainCLPlan": false,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
}
},
{
"NodeName": "hostname:11810",
"GroupName": "group1",
"Role": "data",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 50007,
"ElapsedTime": 0.82666,
"IndexRead": 0,
"DataRead": 50055,
"UserCPU": 0.1499999999999986,
"SysCPU": 0.01000000000000023,
"CacheStatus": "HitCache",
"MainCLPlan": false,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
}
}
]
}
}使用 Detail 选项查看查询的详细访问计划，并且使用 Search 选项查看查询优化器的搜索过程
> db.sample.employee.find( { a : { $gt : 100 } } ).explain( { Detail : true, Search : true } )
{
"NodeName": "hostname:11800",
"GroupName": "SYSCoord",
"Role": "coord",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 0,
"ReturnNum": 0,
"ElapsedTime": 0.037223,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"PlanPath": {
"Operator": "COORD-MERGE",
"Sort": {},
"NeedReorder": false,
"DataNodeNum": 2,
"DataNodeList": [
{
"Name": "hostname:11820",
"EstTotalCost": 0.7418349999999999
},
{
"Name": "hostname:11810",
"EstTotalCost": 1.334165
}
],
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 1.3591655,
"TotalCost": 1.3591655,
"Output": {
"Records": 50001,
"RecordSize": 29,
"Sorted": false
}
},
"ChildOperators": [
{
"NodeName": "hostname:11820",
"GroupName": "group2",
"Role": "data",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000048,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "NoCache",
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": false,
"FuzzyOptr": false
},
"PlanPath": {
"Operator": "TBSCAN",
"Collection": "sample.employee",
"Query": {
"$and": [
{
"a": {
"$gt": 100
}
}
]
},
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.7418349999999999,
"TotalCost": 0.7418349999999999,
"CLEstFromStat": false,
"Input": {
"Pages": 37,
"Records": 49945,
"RecordSize": 29
},
"Filter": {
"MthSelectivity": 0.4999994999999995
},
"Output": {
"Records": 24973,
"RecordSize": 29,
"Sorted": false
}
}
},
"Search": {
"Options": {
"sortbuf": 256,
"optcostthreshold": 20
},
"SearchPaths": [
{
"IsUsed": false,
"IsCandidate": false,
"Score": 1,
"ScanType": "ixscan",
"IndexName": "$id",
"UseExtSort": false,
"Direction": 1,
"IXBound": {
"_id": [
[
{
"$minElement": 1
},
{
"$maxElement": 1
}
]
]
},
"NeedMatch": true,
"IndexCover": false,
"IXEstFromStat": false
},
{
"IsUsed": false,
"IsCandidate": false,
"Score": 0.4999994999999995,
"ScanType": "ixscan",
"IndexName": "$shard",
"UseExtSort": false,
"Direction": 1,
"IXBound": {
"a": [
[
100,
{
"$decimal": "MAX"
}
]
]
},
"NeedMatch": false,
"IXEstFromStat": false
},
{
"IsUsed": true,
"IsCandidate": true,
"Score": 0.4999994999999995,
"TotalCost": 1483670,
"ScanType": "tbscan",
"IndexName": "",
"UseExtSort": false
}
]
}
},
{
"NodeName": "hostname:11810",
"GroupName": "group1",
"Role": "data",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000064,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "NoCache",
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": false,
"FuzzyOptr": false
},
"PlanPath": {
"Operator": "TBSCAN",
"Collection": "sample.employee",
"Query": {
"$and": [
{
"a": {
"$gt": 100
}
}
]
},
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 1.334165,
"TotalCost": 1.334165,
"CLEstFromStat": false,
"Input": {
"Pages": 74,
"Records": 50055,
"RecordSize": 29
},
"Filter": {
"MthSelectivity": 0.4999994999999995
},
"Output": {
"Records": 25028,
"RecordSize": 29,
"Sorted": false
}
}
},
"Search": {
"Options": {
"sortbuf": 256,
"optcostthreshold": 20
},
"SearchPaths": [
{
"IsUsed": false,
"IsCandidate": false,
"Score": 1,
"ScanType": "ixscan",
"IndexName": "$id",
"UseExtSort": false,
"Direction": 1,
"IXBound": {
"_id": [
[
{
"$minElement": 1
},
{
"$maxElement": 1
}
]
]
},
"NeedMatch": true,
"IndexCover": false,
"IXEstFromStat": false
},
{
"IsUsed": false,
"IsCandidate": false,
"Score": 0.4999994999999995,
"ScanType": "ixscan",
"IndexName": "$shard",
"UseExtSort": false,
"Direction": 1,
"IXBound": {
"a": [
[
100,
{
"$decimal": "MAX"
}
]
]
},
"NeedMatch": false,
"IndexCover": false,
"IXEstFromStat": false
},
{
"IsUsed": true,
"IsCandidate": true,
"Score": 0.4999994999999995,
"TotalCost": 2668330,
"ScanType": "tbscan",
"IndexName": "",
"UseExtSort": false
}
]
}
}
]
}
}使用 Detail 选项查看查询的详细访问计划，并且使用 CMDLocation 选项查看查询在 group1 上的访问计划
> db.sample.employee.find( { a : { $gt : 100 } } ).explain( { Detail : true, CMDLocation : { GroupName : 'group1' } } )
{
"NodeName": "hostname:11800",
"GroupName": "SYSCoord",
"Role": "coord",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 0,
"ReturnNum": 0,
"ElapsedTime": 0.011374,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"PlanPath": {
"Operator": "COORD-MERGE",
"Sort": {},
"NeedReorder": false,
"DataNodeNum": 2,
"DataNodeList": [
{
"Name": "hostname:11810",
"EstTotalCost": 1.484
},
{
"Name": "hostname:11820",
"EstTotalCost": 0.7418349999999999
}
],
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 1.5214865,
"TotalCost": 1.5214865,
"Output": {
"Records": 74973,
"RecordSize": 29,
"Sorted": false
}
},
"ChildOperators": [
{
"NodeName": "hostname:11810",
"GroupName": "group1",
"Role": "data",
"Collection": "sample.employee",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000088,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "HitCache",
"MainCLPlan": false,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
}
}
]
}
}使用 Detail 选项查看表分区的详细访问计划，并使用 Expand 选项展开所有细节
> db.maincs.maincl.find( { a : { $gt : 100 } } ).explain( { Detail : true, Expand : true } )
{
"NodeName": "hostname:11800",
"GroupName": "SYSCoord",
"Role": "coord",
"Collection": "maincs.maincl",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 0,
"ReturnNum": 0,
"ElapsedTime": 0.002748,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"PlanPath": {
"Operator": "COORD-MERGE",
"Sort": {},
"NeedReorder": false,
"DataNodeNum": 2,
"DataNodeList": [
{
"Name": "hostname:11810",
"EstTotalCost": 0.9624999999999999
},
{
"Name": "hostname:11820",
"EstTotalCost": 0.9624999999999999
}
],
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.9874999999999999,
"TotalCost": 0.9874999999999999,
"Output": {
"Records": 50000,
"RecordSize": 43,
"Sorted": false
}
},
"ChildOperators": [
{
"NodeName": "hostname:11810",
"GroupName": "group1",
"Role": "data",
"Collection": "maincs.maincl",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.00062,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"PlanPath": {
"Operator": "MERGE",
"Sort": {},
"NeedReorder": false,
"SubCollectionNum": 2,
"SubCollectionList": [
{
"Name": "subcs.subcl2",
"EstTotalCost": 0.475
},
{
"Name": "subcs.subcl1",
"EstTotalCost": 0.475
}
],
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.9624999999999999,
"TotalCost": 0.9624999999999999,
"Output": {
"Records": 25000,
"RecordSize": 43,
"Sorted": false
}
},
"SubCollections": [
{
"Collection": "subcs.subcl2",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000042,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "HitCache",
"MainCLPlan": true,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
},
"PlanPath": {
"Operator": "TBSCAN",
"Collection": "subcs.subcl2",
"Query": {
"$and": [
{
"a": {
"$gt": 100
}
}
]
},
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.475,
"TotalCost": 0.475,
"CLEstFromStat": false,
"Input": {
"Pages": 25,
"Records": 25000,
"RecordSize": 43
},
"Filter": {
"MthSelectivity": 0.4999994999999995
},
"Output": {
"Records": 12500,
"RecordSize": 43,
"Sorted": false
}
}
}
},
{
"Collection": "subcs.subcl1",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000049,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "HitCache",
"MainCLPlan": true,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
},
"PlanPath": {
"Operator": "TBSCAN",
"Collection": "subcs.subcl1",
"Query": {
"$and": [
{
"a": {
"$gt": 100
}
}
]
},
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.475,
"TotalCost": 0.475,
"CLEstFromStat": false,
"Input": {
"Pages": 25,
"Records": 25000,
"RecordSize": 43
},
"Filter": {
"MthSelectivity": 0.4999994999999995
},
"Output": {
"Records": 12500,
"RecordSize": 43,
"Sorted": false
}
}
}
}
]
}
},
{
"NodeName": "hostname:11820",
"GroupName": "group2",
"Role": "data",
"Collection": "maincs.maincl",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.00067,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"PlanPath": {
"Operator": "MERGE",
"Sort": {},
"NeedReorder": false,
"SubCollectionNum": 2,
"SubCollectionList": [
{
"Name": "subcs.subcl2",
"EstTotalCost": 0.475
},
{
"Name": "subcs.subcl1",
"EstTotalCost": 0.475
}
],
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.9624999999999999,
"TotalCost": 0.9624999999999999,
"Output": {
"Records": 25000,
"RecordSize": 43,
"Sorted": false
}
},
"SubCollections": [
{
"Collection": "subcs.subcl2",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000034,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "HitCache",
"MainCLPlan": true,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
},
"PlanPath": {
"Operator": "TBSCAN",
"Collection": "subcs.subcl2",
"Query": {
"$and": [
{
"a": {
"$gt": 100
}
}
]
},
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.475,
"TotalCost": 0.475,
"CLEstFromStat": false,
"Input": {
"Pages": 25,
"Records": 25000,
"RecordSize": 43
},
"Filter": {
"MthSelectivity": 0.4999994999999995
},
"Output": {
"Records": 12500,
"RecordSize": 43,
"Sorted": false
}
}
}
},
{
"Collection": "subcs.subcl1",
"Query": {
"a": {
"$gt": 100
}
},
"Sort": {},
"Selector": {},
"Hint": {},
"Skip": 0,
"Return": -1,
"Flag": 2048,
"ReturnNum": 0,
"ElapsedTime": 0.000048,
"IndexRead": 0,
"DataRead": 0,
"UserCPU": 0,
"SysCPU": 0,
"CacheStatus": "HitCache",
"MainCLPlan": true,
"CacheLevel": "OPT_PLAN_PARAMETERIZED",
"Parameters": [
100
],
"MatchConfig": {
"EnableMixCmp": false,
"Parameterized": true,
"FuzzyOptr": false
},
"PlanPath": {
"Operator": "TBSCAN",
"Collection": "subcs.subcl1",
"Query": {
"$and": [
{
"a": {
"$gt": 100
}
}
]
},
"Selector": {},
"Skip": 0,
"Return": -1,
"Estimate": {
"StartCost": 0,
"RunCost": 0.475,
"TotalCost": 0.475,
"CLEstFromStat": false,
"Input": {
"Pages": 25,
"Records": 25000,
"RecordSize": 43
},
"Filter": {
"MthSelectivity": 0.4999994999999995
},
"Output": {
"Records": 12500,
"RecordSize": 43,
"Sorted": false
}
}
}
}
]
}
}
]
}
}
