草庐IT

preserveNullAndEmptyArrays

全部标签

mongodb - 如何更快地执行此 mongoDB 查找聚合?

我想在Robo3T上运行以下mongoDB查询,但需要很长时间才能得出结果:db.getCollection('check').aggregate([{$match:{$and:[{datetime:{"$gt":newISODate("2019-07-0101:00:10.000Z")}},]}},{$lookup:{from:"workstation",localField:"deviceid",foreignField:"_id",as:"workstation"}},{$unwind:{path:"$workstation",preserveNullAndEmptyArrays