Won't Do
Details
Details
Assignee
Unassigned
UnassignedReporter
Vinicius Grippa
Vinicius GrippaLabels
Needs QA
Yes
Priority
MediumCreated November 9, 2024 at 5:37 PM
Updated March 6, 2025 at 10:30 AM
Resolved December 10, 2024 at 12:21 PM
Skip to:
Medium
Request a feature to purge documents in the pbmLog collection to avoid performance issues. The query below runs COLLSCANs against the configuration replicas in the sharded clusters - almost surely also against the primary node in replica set deployments. If the collection gets many documents, it can contribute to stress during deployment.
{"t":{"$date":"2024-11-08T04:00:19.884-06:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn2662906","msg":"Slow query","attr":{"type":"command","ns":"admin.pbmLog","appName":"pbm-ctl","command":{"find":"pbmLog","filter":{"s":1,"rs":"XXXX","e":"pitr","ep":{"$timestamp":{"t":1731059915,"i":3}}},"limit":1,"sort":{"ts":-1,"ns":-1},"readConcern":{"level":"majority"},"lsid":{"id":{"$uuid":"713aca39-9617-45bf-8897-9b6da67c6668"}},"$clusterTime":{"clusterTime":{"$timestamp":{"t":1731060018,"i":2}},"signature":{"hash":{"$binary":{"base64":"AAAAAAAAAAAAAAAAAAAAAAAAAAA=","subType":"0"}},"keyId":0}},"$db":"admin"},"planSummary":"COLLSCAN","keysExamined":0,"docsExamined":222939,"hasSortStage":true,"cursorExhausted":true,"numYields":233,"nreturned":0,"queryHash":"349773B8","planCacheKey":"349773B8","queryFramework":"classic","reslen":255,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":234}},"Global":{"acquireCount":{"r":234}},"Mutex":{"acquireCount":{"r":1}}},"readConcern":{"level":"majority","provenance":"clientSupplied"},"storage":{},"remote":"15.108.52.150:17538","protocol":"op_msg","durationMillis":462}}We already have an FR to create indexes for this collection. Creating another index for the timestamp to delete documents older than DD-MM-YYYY might be necessary.