i want to display sql execution time on shell?
who can help me ?
We do not understand what you want. MongoDB is not SQL. What information do you want exactly?
i upload it,please help me,tks
I think the exact output they show is from an old shell. The best way to obtain data about a query is with
If I remember correctly, it is covered in M201.
var b = new Date() #query here print(new Date() - b + " ms")
Or if you only want to compare queries, this is after you read
cursor.explain(): Analyze Query Performance.
In the current MongoDB output, good params are Total docs & keys examined (if remember correctly).
PS: bear in mind that this plugin, as far as I understand, loads itself using the mongorc file, so you have to remove
--norc from the original command for m121.
If it loads, you’ll see:
MongoDB server version: 4.2.11 Mongo-Hacker 0.1.1
And this output:
It also tweaks the prompt (I didn’t like it). You can probably change this in the rc file. Looks like a very nice plugin though.
We have a great community forum where you can have an in-depth conversation about specific use cases and interesting problems that you get to solve using MongoDB. I would highly recommend posting your question there for a more involved discussion.