Mongo Shell 查询优化

最新推荐文章于 2023-02-23 16:38:58 发布

列御寇

最新推荐文章于 2023-02-23 16:38:58 发布

阅读量153

点赞数

分类专栏： MongoDB 文章标签： mongodb elasticsearch nosql

本文链接：https://blog.csdn.net/qq_39045558/article/details/124762043

版权

MongoDB 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

Mongo Shell 查询优化

参考文章

分析查询表现
说明结果，这个链接有explain()方法的详细说明

评估查询性能

db.collection.expalin("executionStats")提供了关于查询的性能统计信息，这些信息可用于衡量查询是否以及如何使用索引。

db.getCollection("aat_machine_defective_rate_config").find({}).explain("executionStats")，在mongo shell执行上述命令后返回了对查询语句的分析，如下：

返回的结果：

{
	"queryPlanner" : {
		"mongosPlannerVersion" : 1,
		"winningPlan" : {
			"stage" : "SINGLE_SHARD",
			"shards" : [
				{
					"shardName" : "data_set2",
					"connectionString" : "shard2/192.168.xx:27001",
					"serverInfo" : {
						"host" : "mongo3",
						"port" : 27002,
						"version" : "4.0.2",
						"gitVersion" : "fc1573ba18aee42f97a3bb13b67af7d837826b47"
					},
					"plannerVersion" : 1,
					"namespace" : "xx.xxxxxx",
					"indexFilterSet" : false,
					"parsedQuery" : {
						
					},
					"winningPlan" : {
						"stage" : "COLLSCAN",
						"direction" : "forward"
					},
					"rejectedPlans" : [ ]
				}
			]
		}
	},
	"executionStats" : {
		"nReturned" : 3,
		"executionTimeMillis" : 0,
		"totalKeysExamined" : 0,
		"totalDocsExamined" : 3,
		"executionStages" : {
			"stage" : "SINGLE_SHARD",
			"nReturned" : 3,
			"executionTimeMillis" : 0,
			"totalKeysExamined" : 0,
			"totalDocsExamined" : 3,
			"totalChildMillis" : NumberLong(0),
			"shards" : [
				{
					"shardName" : "data_set2",
					"executionSuccess" : true,
					"executionStages" : {
						"stage" : "COLLSCAN",
						"nReturned" : 3,
						"executionTimeMillisEstimate" : 0,
						"works" : 5,
						"advanced" : 3,
						"needTime" : 1,
						"needYield" : 0,
						"saveState" : 0,
						"restoreState" : 0,
						"isEOF" : 1,
						"invalidates" : 0,
						"direction" : "forward",
						"docsExamined" : 3
					}
				}
			]
		}
	},
	"ok" : 1,
	"operationTime" : Timestamp(1649919959, 1),
	"$clusterTime" : {
		"clusterTime" : Timestamp(1649919959, 6),
		"signature" : {
			"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
			"keyId" : NumberLong(0)
		}
	}
}