使用示例文档

{ "_id": {
    "$oid": "527339384bb8d32905f000853"
}, "format": "flat1", "aggregation": "raw", "vm_id": "10101010", "hostname": "foo.example.com", "fooid": "100822", "ts": {
    "$date": "2013-11-01T05:00:23.000Z"
}, "cpu_nanoseconds": 1410576880000000, "disk_usage": 20069460, "interface_public_rx_packets": 35771474, "interface_public_rx_bytes": 6023191691, "interface_public_rx_errors": 0, "interface_public_rx_drop": 0, "interface_public_tx_packets": 26004483, "interface_public_tx_bytes": 37293536055, "interface_public_tx_errors": 0, "interface_public_tx_drop": 0, "interface_private_rx_packets": 846833, "interface_private_rx_bytes": 63898435, "interface_private_rx_errors": 0, "interface_private_rx_drop": 0, "interface_private_tx_packets": 39, "interface_private_tx_bytes": 1638, "interface_private_tx_errors": 0, "interface_private_tx_drop": 0, "disk_primary_read_requests": 3280869, "disk_primary_read_bytes": 39818978304, "disk_primary_write_requests": 40331710, "disk_primary_write_bytes": 685420728320, "disk_swap_read_requests": 32, "disk_swap_read_bytes": 823808, "disk_swap_write_requests": 16, "disk_swap_write_bytes": 253952, "vcpu_nanoseconds_0": 470437920000000, "vcpu_nanoseconds_1": 344849460000000, "vcpu_nanoseconds_2": 342793890000000, "max_vcpus": 3}

我有以下按天对信息进行分组的查询:

[ { "$match" : { "vm_id" : "1111223"}},
  { "$group" : {
                 "_id" : { "$dayOfMonth" : "$ts"},
                 "month" : { "$first" : { "$month" : "$ts"}},
                 "year" : { "$first" : { "$year" : "$ts"}},
                 "vm_id" : { "$first" : "$vm_id"},
                 "max_public_tx" : { "$max" : "$interface_public_tx_bytes"},
                 "public_tx_total" : { "$sum" : "$interface_public_tx_bytes"},
                 "public_rx_total" : { "$sum" : "$interface_public_rx_bytes"},
                 "private_tx_total" : { "$sum" : "$interface_private_tx_bytes"},
                 "private_rx_total" : { "$sum" : "$interface_private_rx_bytes"},
                 "count" : { "$sum" : 1}}
               },
  { "$sort" : { "_id" : 1}}
]

所以现在我想将它减少到特定一天的小时数。 我认为我所需要的只是更改 _id 并向 $match 添加另一个项目，例如 {{"$dayOfMonth": "$ts"} :1} 作为一个月的第一天，但​​ MongoDb 讨厌它挂了我的东西集成开发环境。 什么是正确的 $match 查询？

我目前正在处理的查询:

[ { "$match" : { "vm_id" : "1111223",{ "$dayOfMonth" : "$ts"}: 1 }},
  { "$group" : {
                 "_id" : { "$hour" : "$ts"},
                 "day" : {"$first" : {"$dayOfMonth" : "$ts"}},
                 "month" : { "$first" : { "$month" : "$ts"}},
                 "year" : { "$first" : { "$year" : "$ts"}},
                 "vm_id" : { "$first" : "$vm_id"},
                 "max_public_tx" : { "$max" : "$interface_public_tx_bytes"},
                 "public_tx_total" : { "$sum" : "$interface_public_tx_bytes"},
                 "public_rx_total" : { "$sum" : "$interface_public_rx_bytes"},
                 "private_tx_total" : { "$sum" : "$interface_private_tx_bytes"},
                 "private_rx_total" : { "$sum" : "$interface_private_rx_bytes"},
                 "count" : { "$sum" : 1}}
               },
  { "$sort" : { "_id" : 1}}
]

最佳答案

在您的匹配管道中使用 $gte 和 $lt 运算符，它将使用您的索引(如果 ts 在索引中)，因此您的匹配管道将是:

{ "$match" : { "vm_id" : "1111223","ts" : {$gte:ISODate('2013-11-01T00:00:00.000Z'), $lt:ISODate('2013-11-02T00:00:00.000Z') }}},

完成查询:

[{ "$match" : { "vm_id" : "1111223","ts" : {$gte:ISODate('2013-11-01T00:00:00.000Z'), $lt:ISODate('2013-11-02T00:00:00.000Z') }}},  
{ "$group" : {
             "_id" : { "$hour" : "$ts"},
             "day" : {"$first" : {"$dayOfMonth" : "$ts"}},
             "month" : { "$first" : { "$month" : "$ts"}},
             "year" : { "$first" : { "$year" : "$ts"}},
             "vm_id" : { "$first" : "$vm_id"},
             "max_public_tx" : { "$max" : "$interface_public_tx_bytes"},
             "public_tx_total" : { "$sum" : "$interface_public_tx_bytes"},
             "public_rx_total" : { "$sum" : "$interface_public_rx_bytes"},
             "private_tx_total" : { "$sum" : "$interface_private_tx_bytes"},
             "private_rx_total" : { "$sum" : "$interface_private_rx_bytes"},
             "count" : { "$sum" : 1}}
           },
{ "$sort" : { "_id" : 1}}
]

关于mongodb - 需要在 MongoDB 中使用时间戳匹配某一天，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/20430690/