Node connector v5 much slower than v3.2.7

Working with Data Drivers & ODMs
, ,
#1

Hello there. I am upgrading from node connector 3.2.7 to 5.0.x.
My mongo server is on 6.0.4. My node version is v18.13.0.

On a moderately large query, the new connector is considerably slower.

Below I have include…

  • the code
  • the results (empirically around 1.6 times longer with the newer driver over multiple runs).
  • the logs (perhaps suggesting latency at the client between getMore calls: ~20ms rather than ~10ms)

Is there some new connection or query parameters that I should be using, perhaps?
Many thanks!

Code

MONGO_URL = 'mongodb://xxxx:yyyyyy!@0.0.0.0/zzzz';
const { MongoClient } = require('mongodb');
(async () => {
  const client = await MongoClient.connect(MONGO_URL, { useNewUrlParser: true });
  const db = await client.db();
  const audit = db.collection('Audit');
  const start = Date.now();
  const count = (await audit.find().toArray()).length;
  console.log(Date.now() - start, 'ms', count, 'recs');
})();

V3.2.7 Results
154 ms 11196 recs

V5.0.1 Results
248 ms 11196 recs

V3.2.7 logs

{"t":{"$date":"2023-05-19T18:11:16.189+00:00"},"s":"I",  "c":"NETWORK",  "id":22943,   "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.17.0.1:34096","uuid":"77810513-8218-4bd2-8c76-7f6dc494e062","connectionId":11,"connectionCount":1}}
{"t":{"$date":"2023-05-19T18:11:16.191+00:00"},"s":"I",  "c":"NETWORK",  "id":51800,   "ctx":"conn11","msg":"client metadata","attr":{"remote":"172.17.0.1:34096","client":"conn11","doc":{"driver":{"name":"nodejs","version":"3.2.7"},"os":{"type":"Linux","name":"linux","architecture":"arm64","version":"5.15.49-linuxkit"},"platform":"Node.js v18.13.0, LE, mongodb-core: 3.2.7"}}}
{"t":{"$date":"2023-05-19T18:11:16.191+00:00"},"s":"D1", "c":"ACCESS",   "id":20226,   "ctx":"conn11","msg":"Returning user from cache","attr":{"user":{"user":"peek","db":"peek"}}}
{"t":{"$date":"2023-05-19T18:11:16.194+00:00"},"s":"D1", "c":"ACCESS",   "id":20226,   "ctx":"conn11","msg":"Returning user from cache","attr":{"user":{"user":"peek","db":"peek"}}}
{"t":{"$date":"2023-05-19T18:11:16.194+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.$cmd","command":{"saslStart":1,"mechanism":"SCRAM-SHA-256","payload":"xxx","autoAuthorize":1,"$db":"peek"},"numYields":0,"reslen":211,"locks":{},"authorization":{"startedUserCacheAcquisitionAttempts":1,"completedUserCacheAcquisitionAttempts":1,"userCacheWaitTimeMicros":2},"remote":"172.17.0.1:34096","protocol":"op_query","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.198+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.$cmd","command":{"saslContinue":1,"conversationId":1,"payload":"xxx","$db":"peek"},"numYields":0,"reslen":140,"locks":{},"remote":"172.17.0.1:34096","protocol":"op_query","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.199+00:00"},"s":"D1", "c":"ACCESS",   "id":20226,   "ctx":"conn11","msg":"Returning user from cache","attr":{"user":{"user":"peek","db":"peek"}}}
{"t":{"$date":"2023-05-19T18:11:16.199+00:00"},"s":"I",  "c":"ACCESS",   "id":20250,   "ctx":"conn11","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":false,"principalName":"peek","authenticationDatabase":"peek","remote":"172.17.0.1:34096","extraInfo":{}}}
{"t":{"$date":"2023-05-19T18:11:16.199+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.$cmd","command":{"saslContinue":1,"conversationId":1,"payload":"xxx","$db":"peek"},"numYields":0,"reslen":94,"locks":{},"authorization":{"startedUserCacheAcquisitionAttempts":1,"completedUserCacheAcquisitionAttempts":1,"userCacheWaitTimeMicros":2},"remote":"172.17.0.1:34096","protocol":"op_query","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.204+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":101,"numYields":0,"nreturned":101,"queryHash":"17830885","queryFramework":"classic","reslen":37956,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1}},"Global":{"acquireCount":{"r":1}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.208+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":442742,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.227+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":463903,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.237+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":443412,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.255+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":482736,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.266+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":485793,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.276+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":475154,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.286+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":516914,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.299+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":526351,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.309+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":525263,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.321+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":508402,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.331+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":452847,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:11:16.351+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn11","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":7259635789622636012,"collection":"Audit","batchSize":1000,"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"returnKey":false,"showRecordId":false,"$db":"peek"},"planSummary":"COLLSCAN","cursorid":7259635789622636012,"keysExamined":0,"docsExamined":95,"cursorExhausted":true,"numYields":0,"nreturned":95,"queryHash":"17830885","reslen":41793,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1}},"Global":{"acquireCount":{"r":1}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:34096","protocol":"op_msg","durationMillis":0}}

V5.0.1 logs

{"t":{"$date":"2023-05-19T18:05:08.374+00:00"},"s":"I",  "c":"NETWORK",  "id":22943,   "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.17.0.1:36362","uuid":"6d25fb37-6878-4ea0-a0ed-e6496619c659","connectionId":2,"connectionCount":1}}
{"t":{"$date":"2023-05-19T18:05:08.376+00:00"},"s":"I",  "c":"NETWORK",  "id":51800,   "ctx":"conn2","msg":"client metadata","attr":{"remote":"172.17.0.1:36362","client":"conn2","doc":{"driver":{"name":"nodejs","version":"5.5.0"},"platform":"Node.js v18.13.0, LE","os":{"name":"linux","architecture":"arm64","version":"5.15.49-linuxkit","type":"Linux"}}}}
{"t":{"$date":"2023-05-19T18:05:08.379+00:00"},"s":"I",  "c":"NETWORK",  "id":22943,   "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.17.0.1:36368","uuid":"c97a3041-4b94-45a1-ae8e-a2d74d80acaf","connectionId":3,"connectionCount":2}}
{"t":{"$date":"2023-05-19T18:05:08.381+00:00"},"s":"I",  "c":"NETWORK",  "id":51800,   "ctx":"conn3","msg":"client metadata","attr":{"remote":"172.17.0.1:36368","client":"conn3","doc":{"driver":{"name":"nodejs","version":"5.5.0"},"platform":"Node.js v18.13.0, LE","os":{"name":"linux","architecture":"arm64","version":"5.15.49-linuxkit","type":"Linux"}}}}
{"t":{"$date":"2023-05-19T18:05:08.381+00:00"},"s":"D1", "c":"ACCESS",   "id":20226,   "ctx":"conn3","msg":"Returning user from cache","attr":{"user":{"user":"peek","db":"peek"}}}
{"t":{"$date":"2023-05-19T18:05:08.381+00:00"},"s":"D1", "c":"ACCESS",   "id":20226,   "ctx":"conn3","msg":"Returning user from cache","attr":{"user":{"user":"peek","db":"peek"}}}
{"t":{"$date":"2023-05-19T18:05:08.387+00:00"},"s":"D1", "c":"ACCESS",   "id":20226,   "ctx":"conn3","msg":"Returning user from cache","attr":{"user":{"user":"peek","db":"peek"}}}
{"t":{"$date":"2023-05-19T18:05:08.387+00:00"},"s":"I",  "c":"ACCESS",   "id":20250,   "ctx":"conn3","msg":"Authentication succeeded","attr":{"mechanism":"SCRAM-SHA-256","speculative":true,"principalName":"peek","authenticationDatabase":"peek","remote":"172.17.0.1:36368","extraInfo":{}}}
{"t":{"$date":"2023-05-19T18:05:08.387+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.$cmd","command":{"saslContinue":1,"conversationId":1,"payload":"xxx","$db":"peek"},"numYields":0,"reslen":125,"locks":{},"authorization":{"startedUserCacheAcquisitionAttempts":1,"completedUserCacheAcquisitionAttempts":1,"userCacheWaitTimeMicros":2},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.392+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":101,"numYields":0,"nreturned":101,"queryHash":"17830885","queryFramework":"classic","reslen":37956,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1}},"Global":{"acquireCount":{"r":1}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.399+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":442742,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.430+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":463903,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.459+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":443412,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.478+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":482736,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.495+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":485793,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.512+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":475154,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.534+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":516914,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.555+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":526351,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.581+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":525263,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.602+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":508402,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.619+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":1000,"numYields":1,"nreturned":1000,"queryHash":"17830885","reslen":452847,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":2}},"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
{"t":{"$date":"2023-05-19T18:05:08.636+00:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn3","msg":"Slow query","attr":{"type":"command","ns":"peek.Audit","command":{"getMore":104885741916121744,"collection":"Audit","batchSize":1000,"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"originatingCommand":{"find":"Audit","filter":{},"lsid":{"id":{"$uuid":"2673876e-e4b2-4c6b-bb05-4fcb06845ab3"}},"$db":"peek"},"planSummary":"COLLSCAN","cursorid":104885741916121744,"keysExamined":0,"docsExamined":95,"cursorExhausted":true,"numYields":0,"nreturned":95,"queryHash":"17830885","reslen":41793,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":1}},"Global":{"acquireCount":{"r":1}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"remote":"172.17.0.1:36368","protocol":"op_msg","durationMillis":0}}
#2

The behaviour is not improved by upgrade to 5.5.0

#3

The biggest drop in performance I have found is with the introduction of V4/