Log file Viewer

[00:05:07] <Jonno_FTW> anyone familiar with robo3T? I can't see the other databases on a server even though I have permissions on them. I authenticate against a db taht is not the admin db, and I have these permissions on admin: clusterMonitor, readWriteAnyDatabase dbAdmin userAdminAnyDatabase

[04:41:58] <Doginal> hey with pymongo (3.3.0) what would cause a serverSelectiontimeout? I am using both connect=false and serverSelectionTimeoutMS but it seems to continue to happen.

[09:03:43] <synthmeat> compass really made a lot of progress. it's actually useful now.

[11:48:49] <Robin___> hello. how can I use find to find some that is NOT (!=) something. For example this var stores an array of all cars of brand "bmw". How to store all cars EXCEPT bmw cars?

[11:48:49] <Robin___> var cars = db.cars.find({"brand": "bmw"}); thx

[12:05:20] <Robin___> oh $ne :)

[15:30:47] <swordbeta> I'm facing some performance issues aggregating on a "large" collection, could someone here perhaps take a quick look? https://stackoverflow.com/q/49409559/4193448

[17:54:42] <Derick> swordbeta: do you have an index on { 'dimensions.date' : 1, 'dimensions.account_id' : 1 } ?

[17:54:53] <Derick> and you should collapse the first two $match statements into one

[17:56:33] <Derick> hmm, looks OK now I see the pastebin

[17:57:25] <Derick> I'd play with a few options to see where data is found/used

[17:57:37] <Derick> I don't have the time to look up that option to $eplxain though

[17:57:39] <Derick> (got to run)

[19:08:29] <swordbeta> Derick: Thanks for taking a look. That's indeed the index and the two $match statements are optimized by mongodb indeed. I added "allPlansExecution" to explain

[19:09:55] <swordbeta> Output can be found here: https://pastebin.com/raw/WA7BNpgA

[19:10:36] <swordbeta> Think those milliseconds are estimates? Since mongod.log says it took 19763ms