Log file Viewer

[09:31:33] <asdfgh> hello

[09:31:46] <asdfgh> how can i see the speed of a query?

[09:32:09] <Kim^J> Run it and measuyre.

[09:33:56] <asdfgh> Kim^J, eheh yes

[09:34:00] <asdfgh> how cna i "measure" ?

[09:34:08] <asdfgh> i only need the ms as result

[09:34:52] <Kim^J> Depends on your environment, which programming language are you accessing it via?

[09:35:39] <asdfgh> Kim^J, pymongo

[09:35:55] <asdfgh> using on linux

[09:36:08] <Kim^J> https://pythonhow.com/measure-execution-time-python-code/

[09:36:49] <asdfgh> Kim^J, i am using it on shell

[09:37:06] <Kim^J> time python ...

[09:37:31] <asdfgh> Kim^J, i would ONLY get the time of the query without python startup etc...

[09:37:48] <Kim^J> So use the code from the link...

[09:37:57] <asdfgh> sounds strange that mongodb does not have a builtin method to get the performance / details of a query

[09:38:56] <Kim^J> https://docs.mongodb.com/manual/tutorial/analyze-query-plan/

[09:49:16] <asdfgh> "stage" : "FETCH",

[09:49:16] <asdfgh> "nReturned" : 1692274,

[09:49:16] <asdfgh> "executionTimeMillisEstimate" : 271,

[09:49:26] <asdfgh> ok so 0.271 seconds

[09:50:49] <asdfgh> Kim^J, https://nopaste.xyz/?0b6168385df14890#OlY0Xq0/gwHfhsKTrMEqvFau3rQkUyurEurP5PxaTGk=

[09:50:53] <asdfgh> ONE DOUBT....

[09:51:16] <asdfgh> "executionTimeMillis" : 3665, <------ this

[09:51:25] <asdfgh> or this "executionTimeMillisEstimate" : 271,

[09:51:26] <asdfgh> ??

[09:51:55] <asdfgh> i think the first is the time of "explaining" that query and the second the real ms of the query...but idk

[09:51:59] <asdfgh> what value should i see

[09:53:22] <asdfgh> Kim^J, it is a stupid test basically i have inserted 20M documents with a single field named.... "field" with random number....and comparing the speed between mongodb and mariadb....i know...it is a stupid test, like a joke...i have just started with mongo

[09:56:18] <asdfgh> https://docs.mongodb.com/manual/reference/explain-results/#explain.executionStats.executionTimeMillis seems like i said

[09:59:02] <asdfgh> Kim^J, still there?

[10:01:22] <Kim^J> So you're basically comparing index lookup speeds? Heh.

[10:08:59] <asdfgh> Kim^J, yes

[10:09:03] <asdfgh> but there is some strange info

[10:09:13] <asdfgh> i mean if i look at the first it is 3 seconds but it is not true

[10:09:30] <asdfgh> i mean if i run the query without the explain it does not take 3 seconds to run

[10:11:01] <asdfgh> what is the real value i should see?

[12:43:36] <abhijith_balan> hello

[12:44:23] <abhijith_balan> anyone setup mongodb using docker?

[15:45:15] <guardian> hello what's the approach to compute the 99% percentile using mongodb? E.g. I have a collection that represents files and for each file I have its size