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

"find" : "content",
"filter" : {
"status" : 2,
"channelId" : {
"$in" : [
5120,
5121,
30722,
898,
899,
32196,
17928,
907,
1037,
912,
914,
29011,
29012,
32596,
32663,100%通过率的网贷
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" : tru数据量化e,
"shortTitle" : true10085是什么电话服务,
"quoteTitle" : true,
"title" : true,
"titleColor" : true,
"description" : tr000001上证指数实时行情ue,
"ur数据透视表l" : true,
"txt" : true,
"releaseDate" : true,
"editor" : true,
"author" : true,
"tagStr" : true,
"editorCharge" : true,
"mediaPat10h" : true,
"origin" : tru数据结构e,
"views" : true
}10085,
"skipipo" : 117964,
"limit" : 22,
"$db" : "cmsyy",
"$clusterTime" : {
"clusterTime" : Timestamp(1636093976, 1),
"signipad2020ature" : {
"hash" : BinData(0,"xIPxpLvCV1uDJz9hffulWXJsaQp1Y="),
"keyId" : NumberLong("7006251150622064643")
}
},
"lsid" : {
"id" : UUID("597026cf-e23c-4efa-8191-90ddd1de5944"数据漫游是什么意思)
}
},
"keysExamined" : 118014,
"docsExamined" : 22,
"fromMultiPlanner" : true,
"repla10月是什么星座nned" : true,
"replanReason" : "cached plan was less efficient than expected: expected trial execution to take 22 works but it took at least 220 works",
"cursorExhaustediphone" : true,
"numY数据量化什么意思ield" : 816,
"nreturned" : 22,
"queryHash" : "E975BCE5",
"planCacheKey" : "5CCAD883",
"locks" : {
"ReplicationStateTransition" : {
"acquireCount" : {
"w" : NumberLo007工作制ng(818)
}
},
"Global" : {
"aipad2020cquireCount" : {
"r" : NumberLong(818)
}
},
"Database" : {
"acquire数据库Count" : {
"r" : NumberLong(80017)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(817)
}
},
"Mutex" : {
"acquireCount" : {
"r" : NumberLong(1)
}
}
},
"flowControl" : {

},
"storage" : {
"data" : {
"bytesRead" : Num数据量单位berLong(1378154),
"timeReadingMicros" : NumberLong(1251)
}
},
"resp007幽灵党onseLength" : 64078,
"protocol" : "op_msg",
"millis" : 2995,

回答

貌似mongo执行skip本来就慢