I got this below log in the mongodb slow query log. I have mongodb version running 5.0 with 3 shards in PSS mode.
The query is running on the primary key and the total docuemnt size itself is only 4.4 Mb, But in the slow query log its showing 64MB data transferred, how can one document do so my data transfer.
{“t”:{“$date”:“2023-03-15T16:02:14.635+05:30”},“s”:“I”, “c”:“WRITE”, “id”:51803, “ctx”:“conn5559”,“msg”:“Slow query”,“attr”:{“type”:“update”,“ns”:“db_name.XXXXXXX”,“command”:{“q”:{“uid”:308793847},“u”:{“$push”:{“ps”:{“$each”:[{“mid”:5109,“aid”:1412,“trid”:“89461-5109-308793847-1412-230315072428”,“guid”:“3919037b-18ce-4973-ad00-1891bc7365e3”,“st”:“sent”,“dt”:230315072428,“adw”:4,“ad”:230315,“at”:72428}],“$slice”:-5000}}},“multi”:false,“upsert”:false},“planSummary”:“IXSCAN { uid: 1 }”,“keysExamined”:1,“docsExamined”:1,“nMatched”:1,“nModified”:1,“nUpserted”:0,“keysInserted”:1,“keysDeleted”:0,“numYields”:1,“queryHash”:“B34121E2”,“planCacheKey”:“CFF4BBD8”,“locks”:{“ParallelBatchWriterMode”:{“acquireCount”:{“r”:289}},“ReplicationStateTransition”:{“acquireCount”:{“w”:290}},“Global”:{“acquireCount”:{“w”:289}},“Database”:{“acquireCount”:{“w”:289}},“Collection”:{“acquireCount”:{“w”:289}},“Mutex”:{“acquireCount”:{“r”:670}}},“flowControl”:{“acquireCount”:155,“timeAcquiringMicros”:131},“storage”:{“data”:{“bytesRead”:64292681,“timeReadingMicros”:337574}},“remote”:“172.31.22.28:60864”,“durationMillis”:103}}
can someone help me on this.