Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save mattbillenstein/89969980025414e2bca8325cf503342f to your computer and use it in GitHub Desktop.
Save mattbillenstein/89969980025414e2bca8325cf503342f to your computer and use it in GitHub Desktop.
> db.yt_video_ts3.find()
{ "_id" : ObjectId("57682e87ced89007a1aa9f71"), "id" : "---0savA9eY", "ts" : ISODate("2016-06-03T02:35:39.049Z"), "v" : { "viewCount" : 2016, "likeCount" : 1, "commentCount" : 2 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f72"), "id" : "---0savA9eY", "ts" : ISODate("2016-06-05T14:27:29.732Z"), "v" : { "viewCount" : 2017, "likeCount" : 1, "commentCount" : 2 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f73"), "id" : "---8lKLb9gI", "ts" : ISODate("2016-06-08T03:44:39.079Z"), "v" : { "viewCount" : 2 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f74"), "id" : "---9l91bzWg", "ts" : ISODate("2016-06-08T03:51:07.494Z"), "v" : { "viewCount" : 34, "likeCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f75"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-03T02:30:22.917Z"), "v" : { "viewCount" : 764, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f76"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-04T02:27:58.404Z"), "v" : { "viewCount" : 766, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f77"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-04T14:27:00.537Z"), "v" : { "viewCount" : 768, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f78"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-05T14:26:58.196Z"), "v" : { "viewCount" : 765, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f79"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-06T14:27:01.593Z"), "v" : { "viewCount" : 769, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f7a"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-07T02:27:59.723Z"), "v" : { "viewCount" : 768, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f7b"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-09T08:27:33.394Z"), "v" : { "viewCount" : 769, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f7c"), "id" : "---AwsK8TGg", "ts" : ISODate("2016-06-12T15:46:18.931Z"), "v" : { "viewCount" : 771, "likeCount" : 23, "commentCount" : 1 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f7d"), "id" : "---DdXxrtCI", "ts" : ISODate("2016-06-03T02:22:49.427Z"), "v" : { "viewCount" : 39 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f7e"), "id" : "---MFeW4p1E", "ts" : ISODate("2016-06-08T03:50:51.258Z"), "v" : { "viewCount" : 330, "likeCount" : 7 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f7f"), "id" : "---MFeW4p1E", "ts" : ISODate("2016-06-14T15:21:59.590Z"), "v" : { "viewCount" : 331, "likeCount" : 7 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f80"), "id" : "---X12mY14Q", "ts" : ISODate("2016-06-03T02:34:16.585Z"), "v" : { "viewCount" : 961702, "likeCount" : 1705, "dislikeCount" : 45, "commentCount" : 622 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f81"), "id" : "---X12mY14Q", "ts" : ISODate("2016-06-03T21:06:22.799Z"), "v" : { "viewCount" : 961778, "likeCount" : 1705, "dislikeCount" : 45, "commentCount" : 622 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f82"), "id" : "---X12mY14Q", "ts" : ISODate("2016-06-03T21:24:51.053Z"), "v" : { "viewCount" : 961782, "likeCount" : 1705, "dislikeCount" : 45, "commentCount" : 622 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f83"), "id" : "---X12mY14Q", "ts" : ISODate("2016-06-04T02:28:25.652Z"), "v" : { "viewCount" : 961825, "likeCount" : 1705, "dislikeCount" : 45, "commentCount" : 622 } }
{ "_id" : ObjectId("57682e87ced89007a1aa9f84"), "id" : "---X12mY14Q", "ts" : ISODate("2016-06-04T14:27:23.590Z"), "v" : { "viewCount" : 961884, "likeCount" : 1707, "dislikeCount" : 45, "commentCount" : 623 } }
Type "it" for more
> db.yt_video_ts3.aggregate([{$group: { _id: '$id'}}, {$group: {'_id' : 1, count: { $sum: 1}}}])
{ "_id" : 1, "count" : 1817929 }
> db.yt_video_ts3.aggregate([{$group: { _id: '$ts'}}, {$group: {'_id' : 1, count: { $sum: 1}}}])
{ "_id" : 1, "count" : 18522 }
> x=db.yt_video_ts3.stats();x.wiredTiger=1;x
{
"ns" : "t3.yt_video_ts3",
"count" : 34435916,
"size" : 4235618183,
"avgObjSize" : 123,
"storageSize" : 1303429120,
"capped" : false,
"wiredTiger" : 1,
"nindexes" : 3,
"totalIndexSize" : 714502144,
"indexSizes" : {
"_id_" : 312246272,
"ts_1" : 272461824,
"id_1" : 129794048
},
"ok" : 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment