我大约有100w的数据量skip后非常慢请帮忙看下

2 years ago

source link: https://www.oschina.net/question/3482383_2324295
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

我大约有100w的数据量skip后非常慢请帮忙看下

Mrdadam 发布于昨天 14:54

答案 1

"find" : "content",
"filter" : {
"status" : 2,
"channelId" : {
"in" : [ 5120, 5121, 30722, 898, 899, 32196, 17928, 907, 1037, 912, 914, 29011, 29012, 32596, 32663, 920, 924, 1057, 32290, 931, 32875, 5103, 5105, 5106, 5107, 5110, 952, 1470 ] }, "releaseDate" : { "$lte" : ISODate("2021-11-05T14:32:57.511Z") } }, "sort" : { "topLevel" : -1, "releaseDate" : -1 }, "projection" : { "_id" : true, "titleImg" : true, "shortTitle" : true, "quoteTitle" : true, "title" : true, "titleColor" : true, "description" : true, "url" : true, "txt" : true, "releaseDate" : true, "editor" : true, "author" : true, "tagStr" : true, "editorCharge" : true, "mediaPath" : true, "origin" : true, "views" : true }, "skip" : 117964, "limit" : 22, "in" : [ 5120, 5121, 30722, 898, 899, 32196, 17928, 907, 1037, 912, 914, 29011, 29012, 32596, 32663, 920, 924, 1057, 32290, 931, 32875, 5103, 5105, 5106, 5107, 5110, 952, 1470 ] }, "releaseDate" : { "$lte" : ISODate("2021-11-05T14:32:57.511Z") } }, "sort" : { "topLevel" : -1, "releaseDate" : -1 }, "projection" : { "_id" : true, "titleImg" : true, "shortTitle" : true, "quoteTitle" : true, "title" : true, "titleColor" : true, "description" : true, "url" : true, "txt" : true, "releaseDate" : true, "editor" : true, "author" : true, "tagStr" : true, "editorCharge" : true, "mediaPath" : true, "origin" : true, "views" : true }, "skip" : 117964, "limit" : 22, "db" : "cmsyy",
"$clusterTime" : {
"clusterTime" : Timestamp(1636093976, 1),
"signature" : {
"hash" : BinData(0,"xxpLvCV1uDJz9hffulWXJsaQp1Y="),
"keyId" : NumberLong("7006251150622064643")
}
},
"lsid" : {
"id" : UUID("597026cf-e23c-4efa-8191-90ddd1de5944")
}
},
"keysExamined" : 118014,
"docsExamined" : 22,
"fromMultiPlanner" : true,
"replanned" : true,
"replanReason" : "cached plan was less efficient than expected: expected trial execution to take 22 works but it took at least 220 works",
"cursorExhausted" : true,
"numYield" : 816,
"nreturned" : 22,
"queryHash" : "E975BCE5",
"planCacheKey" : "5CCAD883",
"locks" : {
"ReplicationStateTransition" : {
"acquireCount" : {
"w" : NumberLong(818)
}
},
"Global" : {
"acquireCount" : {
"r" : NumberLong(818)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(817)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(817)
}
},
"Mutex" : {
"acquireCount" : {
"r" : NumberLong(1)
}
}
},
"flowControl" : {

},
"storage" : {
"data" : {
"bytesRead" : NumberLong(1378154),
"timeReadingMicros" : NumberLong(1251)
}
},
"responseLength" : 64078,
"protocol" : "op_msg",
"millis" : 2995,