We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Lo dice mongodb:
dm-manager-mongodb-1 | {"t":{"$date":"2023-05-13T10:19:33.661+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn331","msg":"Slow query","attr":{"type":"command","ns":"dm-manager.staffs","command":{"aggregate":"staffs","pipeline":[{"$match":{"qualification":{"$in":["PO","PA"]}}},{"$match":{"isInternal":true}},{"$match":{"$or":[{"startDate":{"$lt":{"$date":"2023-05-13T10:19:33.539Z"}}},{"startDate":null}]}},{"$match":{"$or":[{"endDate":{"$gt":{"$date":"2023-05-13T10:19:33.539Z"}}},{"endDate":null}]}},{"$lookup":{"from":"people","localField":"person","foreignField":"_id","as":"person","pipeline":[{"$project":{"firstName":1,"lastName":1,"affiliations":1,"email":1,"phone":1,"affiliation":1}},{"$lookup":{"from":"institutions","localField":"affiliations","foreignField":"_id","as":"affiliations","pipeline":[{"$project":{"name":1}}]}},{"$lookup":{"from":"staffs","localField":"_id","foreignField":"person","as":"staffs","pipeline":[{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$endDate",null]},{"$gte":["$endDate","$$NOW"]}]},{"$or":[{"$eq":["$startDate",null]},{"$lte":["$startDate","$$NOW"]}]}]}}},{"$project":{"qualification":1,"isInternal":1}}]}}]}},{"$unwind":{"path":"$person","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"users","localField":"createdBy","foreignField":"_id","as":"createdBy","pipeline":[{"$project":{"firstName":1,"lastName":1,"username":1,"email":1,"photoUrl":1}}]}},{"$unwind":{"path":"$createdBy","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"users","localField":"updatedBy","foreignField":"_id","as":"updatedBy","pipeline":[{"$project":{"firstName":1,"lastName":1,"username":1,"email":1,"photoUrl":1}}]}},{"$unwind":{"path":"$updatedBy","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"roomassignments","let":{"start":"$startDate","end":"$endDate"},"localField":"person._id","foreignField":"person","as":"roomAssignments","pipeline":[{"$lookup":{"from":"rooms","localField":"room","foreignField":"_id","as":"room"}},{"$project":{"startDate":1,"endDate":1,"room._id":1,"room.code":1,"room.building":1,"room.floor":1,"room.number":1}},{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$$end",null]},{"$eq":["$startDate",null]},{"$lte":["$startDate","$$end"]}]},{"$or":[{"$eq":["$$start",null]},{"$eq":["$endDate",null]},{"$gte":["$endDate","$$start"]}]}]}}},{"$unwind":{"path":"$room","preserveNullAndEmptyArrays":true}},{"$sort":{"endDate":1}}]}},{"$addFields":{"roomAssignment":{"$ifNull":[{"$arrayElemAt":["$roomAssignments",-1]},null]}}},{"$match":{}},{"$match":{}},{"$sort":{"person.lastName":1,"person.firstName":1}},{"$facet":{"counting":[{"$group":{"_id":null,"count":{"$sum":1}}}],"limiting":[{"$skip":0}]}},{"$unwind":"$counting"},{"$project":{"total":"$counting.count","data":"$limiting"}}],"cursor":{},"lsid":{"id":{"$uuid":"ec5301e2-5fd1-4c52-a323-0ace79454c6f"}},"$db":"dm-manager"},"planSummary":"IXSCAN { startDate: 1, endDate: 1 }","keysExamined":19055,"docsExamined":55695,"hasSortStage":true,"cursorExhausted":true,"numYields":0,"nreturned":1,"queryHash":"EFB32084","planCacheKey":"376D234A","queryFramework":"classic","reslen":50552,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":830}},"Global":{"acquireCount":{"r":830}},"Mutex":{"acquireCount":{"r":830}}},"storage":{},"remote":"192.168.16.3:58386","protocol":"op_msg","durationMillis":120}}
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Lo dice mongodb:
dm-manager-mongodb-1 | {"t":{"$date":"2023-05-13T10:19:33.661+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn331","msg":"Slow query","attr":{"type":"command","ns":"dm-manager.staffs","command":{"aggregate":"staffs","pipeline":[{"$match":{"qualification":{"$in":["PO","PA"]}}},{"$match":{"isInternal":true}},{"$match":{"$or":[{"startDate":{"$lt":{"$date":"2023-05-13T10:19:33.539Z"}}},{"startDate":null}]}},{"$match":{"$or":[{"endDate":{"$gt":{"$date":"2023-05-13T10:19:33.539Z"}}},{"endDate":null}]}},{"$lookup":{"from":"people","localField":"person","foreignField":"_id","as":"person","pipeline":[{"$project":{"firstName":1,"lastName":1,"affiliations":1,"email":1,"phone":1,"affiliation":1}},{"$lookup":{"from":"institutions","localField":"affiliations","foreignField":"_id","as":"affiliations","pipeline":[{"$project":{"name":1}}]}},{"$lookup":{"from":"staffs","localField":"_id","foreignField":"person","as":"staffs","pipeline":[{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$endDate",null]},{"$gte":["$endDate","$$NOW"]}]},{"$or":[{"$eq":["$startDate",null]},{"$lte":["$startDate","$$NOW"]}]}]}}},{"$project":{"qualification":1,"isInternal":1}}]}}]}},{"$unwind":{"path":"$person","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"users","localField":"createdBy","foreignField":"_id","as":"createdBy","pipeline":[{"$project":{"firstName":1,"lastName":1,"username":1,"email":1,"photoUrl":1}}]}},{"$unwind":{"path":"$createdBy","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"users","localField":"updatedBy","foreignField":"_id","as":"updatedBy","pipeline":[{"$project":{"firstName":1,"lastName":1,"username":1,"email":1,"photoUrl":1}}]}},{"$unwind":{"path":"$updatedBy","preserveNullAndEmptyArrays":true}},{"$lookup":{"from":"roomassignments","let":{"start":"$startDate","end":"$endDate"},"localField":"person._id","foreignField":"person","as":"roomAssignments","pipeline":[{"$lookup":{"from":"rooms","localField":"room","foreignField":"_id","as":"room"}},{"$project":{"startDate":1,"endDate":1,"room._id":1,"room.code":1,"room.building":1,"room.floor":1,"room.number":1}},{"$match":{"$expr":{"$and":[{"$or":[{"$eq":["$$end",null]},{"$eq":["$startDate",null]},{"$lte":["$startDate","$$end"]}]},{"$or":[{"$eq":["$$start",null]},{"$eq":["$endDate",null]},{"$gte":["$endDate","$$start"]}]}]}}},{"$unwind":{"path":"$room","preserveNullAndEmptyArrays":true}},{"$sort":{"endDate":1}}]}},{"$addFields":{"roomAssignment":{"$ifNull":[{"$arrayElemAt":["$roomAssignments",-1]},null]}}},{"$match":{}},{"$match":{}},{"$sort":{"person.lastName":1,"person.firstName":1}},{"$facet":{"counting":[{"$group":{"_id":null,"count":{"$sum":1}}}],"limiting":[{"$skip":0}]}},{"$unwind":"$counting"},{"$project":{"total":"$counting.count","data":"$limiting"}}],"cursor":{},"lsid":{"id":{"$uuid":"ec5301e2-5fd1-4c52-a323-0ace79454c6f"}},"$db":"dm-manager"},"planSummary":"IXSCAN { startDate: 1, endDate: 1 }","keysExamined":19055,"docsExamined":55695,"hasSortStage":true,"cursorExhausted":true,"numYields":0,"nreturned":1,"queryHash":"EFB32084","planCacheKey":"376D234A","queryFramework":"classic","reslen":50552,"locks":{"FeatureCompatibilityVersion":{"acquireCount":{"r":830}},"Global":{"acquireCount":{"r":830}},"Mutex":{"acquireCount":{"r":830}}},"storage":{},"remote":"192.168.16.3:58386","protocol":"op_msg","durationMillis":120}}
The text was updated successfully, but these errors were encountered: