mongodb查询记录

 db.getCollection("PackageHistory").aggregate([
    {
        $match: {
            "request.data.radar_posture": {
                $exists: true
            },
            "timestamp":{
                "$gte": ISODate("2023-02-23T00:00:00.000Z"),
                "$lte": ISODate("2023-02-24T00:00:00.000Z")
            }
        }
    },
    {
        $project: {
            "devTid": 1,
            "ctrlKey": 1,
            "timestamp": 1,
            hour: {
                $hour: {
                    $add: ['$timestamp', 28800000]
                }
            },
            "posture":"$request.data.radar_posture"
        }
    },
    {
        $group: {
            _id: {
                ctrlKey: "$ctrlKey",
                posture: "$posture",
                hour: "$hour"
            },
            count: {
                $sum: 1
            }
        }
    },
    {
        $project: {
            _id: false,
            ctrlKey: "$_id.ctrlKey",
            posture: "$_id.posture",
            hour: "$_id.hour",
            count: "$count"
        }
    },
    { $sort : { hour : 1}}
])