1,798
社区成员




db.getCollection('Statistics').aggregate([
{
"$match": {
"dateline": {
"$gte": 1443628800,
"$lte": 1445270400
},
"tid": {
"$gt": 0
}
}
},
{
"$group": {
"_id": "$tid",
"event1": {
"$sum": 1
}
}
},
{
"$sort": {
"tid": -1
}
},
{
"$skip": 0
},
{
"$limit": 10
}
])
> db.Statistics.getIndexes()
[
{
"v" : 1,
"key" : {
"_id" : 1
},
"name" : "_id_",
"ns" : "dbname.Statistics"
},
{
"v" : 1,
"key" : {
"dateline" : 1
},
"name" : "dateline_1",
"ns" : "dbname.Statistics"
},
{
"v" : 1,
"key" : {
"tid" : 1
},
"name" : "tid_1",
"ns" : "dbname.Statistics"
},
{
"v" : 1,
"key" : {
"tid" : 1,
"dateline" : 1
},
"name" : "tid_1_dateline_1",
"ns" : "dbname.Statistics"
}
]