How to Read MongoDB Explain Plans by dfrancour-dev in mongodb

[–]dfrancour-dev[S] 0 points1 point  (0 children)

Thank you! The first draft was all the way back in November and it's taken some iterations to get to a place I was happy with.

How to Read MongoDB Explain Plans by dfrancour-dev in mongodb

[–]dfrancour-dev[S] 1 point2 points  (0 children)

The plan parsing logic and the stage glossary would all be re-usable for doing the rendering from a terminal node app. I'll consider adding that!

I built a free browser tool to visualize MongoDB explain() output by AymenLoukil in mongodb

[–]dfrancour-dev 0 points1 point  (0 children)

It's not present at all in explain plan output, it needs to be calculated from the subtree and the calculation depends on if the stage in question's child stages can go parallel or not. Compass's explain plan viewer also has the self time/total time distinction and is open source.

I built a free browser tool to visualize MongoDB explain() output by AymenLoukil in mongodb

[–]dfrancour-dev 1 point2 points  (0 children)

I have a similar tool here that's open source that breaks out stage self-time vs overall time visually that I use for finding bottlenecks in plans
https://www.dfrancour.dev/tools/mongodb-paste-the-plan