Skip to content

Instantly share code, notes, and snippets.

@dchaplinsky
Created November 11, 2014 22:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dchaplinsky/b7c5043eda04847029b5 to your computer and use it in GitHub Desktop.
Save dchaplinsky/b7c5043eda04847029b5 to your computer and use it in GitHub Desktop.
Some interesting stats that we've obtained during beta test on GTD dataset.
>> db.tagging_speed.aggregate(
{
$match:
{
msec: {$gte: 2 * 1000, $lte: 180 * 1000}
}
},
{
$group:
{
_id: "$tags_count",
total: {$sum: 1},
avg_time: {
$avg: {
$divide: ["$msec", 1000]
}
}
}
}
)
{ "_id" : 15, "total" : 3, "avg_time" : 82.532563 }
{ "_id" : 12, "total" : 167, "avg_time" : 86.65440970658689 }
{ "_id" : 14, "total" : 18, "avg_time" : 87.3624625 }
{ "_id" : 13, "total" : 41, "avg_time" : 90.78206668292682 }
{ "_id" : 11, "total" : 447, "avg_time" : 70.23177686129753 }
{ "_id" : 9, "total" : 1869, "avg_time" : 60.34623951952919 }
{ "_id" : 8, "total" : 2371, "avg_time" : 57.52929692408271 }
{ "_id" : 10, "total" : 1047, "avg_time" : 65.42275484049665 }
{ "_id" : 1, "total" : 1363, "avg_time" : 17.082908478356547 }
{ "_id" : 6, "total" : 2282, "avg_time" : 49.853545867221705 }
{ "_id" : 7, "total" : 2482, "avg_time" : 51.45544055479442 }
{ "_id" : 4, "total" : 2429, "avg_time" : 36.59268128530253 }
{ "_id" : 5, "total" : 2205, "avg_time" : 44.762464244898034 }
{ "_id" : 2, "total" : 2825, "avg_time" : 20.16925394725661 }
{ "_id" : 3, "total" : 2809, "avg_time" : 29.778883827696642 }
>> db.shreds.aggregate(
{
$group:
{
_id: "Oh",
total: {$sum: 1},
users_p: {$sum: "$usersCount"}
}
}
)
{ "_id" : "Oh", "total" : 2825, "users_p" : 24216 }
>> db.shreds.aggregate(
{
$group:
{
_id: "$usersCount",
total: {$sum: 1},
}
},
{
$sort:
{
_id: -1
}
}
)
{ "_id" : 55, "total" : 1 }
{ "_id" : 50, "total" : 1 }
{ "_id" : 43, "total" : 1 }
{ "_id" : 41, "total" : 1 }
{ "_id" : 37, "total" : 1 }
{ "_id" : 36, "total" : 4 }
{ "_id" : 34, "total" : 4 }
{ "_id" : 33, "total" : 2 }
{ "_id" : 32, "total" : 6 }
{ "_id" : 31, "total" : 5 }
{ "_id" : 30, "total" : 5 }
{ "_id" : 29, "total" : 1 }
{ "_id" : 28, "total" : 4 }
{ "_id" : 27, "total" : 8 }
{ "_id" : 26, "total" : 8 }
{ "_id" : 25, "total" : 12 }
{ "_id" : 24, "total" : 14 }
{ "_id" : 23, "total" : 12 }
{ "_id" : 22, "total" : 15 }
{ "_id" : 21, "total" : 17 }
{ "_id" : 20, "total" : 17 }
{ "_id" : 19, "total" : 26 }
{ "_id" : 18, "total" : 28 }
{ "_id" : 17, "total" : 52 }
{ "_id" : 16, "total" : 45 }
{ "_id" : 15, "total" : 59 }
{ "_id" : 14, "total" : 50 }
{ "_id" : 13, "total" : 94 }
{ "_id" : 12, "total" : 98 }
{ "_id" : 11, "total" : 145 }
{ "_id" : 10, "total" : 163 }
{ "_id" : 9, "total" : 188 }
{ "_id" : 8, "total" : 231 }
{ "_id" : 7, "total" : 257 }
{ "_id" : 6, "total" : 270 }
{ "_id" : 5, "total" : 298 }
{ "_id" : 4, "total" : 338 }
{ "_id" : 3, "total" : 344 }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment