Deciphering Explain Output

June 23, 2017

Speaker: Charlie Swanson, Software Engineer, MongoDB 
Level: 200 (Intermediate)
Track: How We Build MongoDB

Learn how MongoDB answers your queries from a query system engineer. If you've ever had a performance problem with a query but didn't know how to find the cause, or if you've ever needed to confirm that your shiny new index is being put to work, the explain command is an excellent place to start. MongoDB's explain system is a powerful tool for solving this type of problem, but can be intimidating and unwieldy to use. In this talk, we will discuss how the explain command works and break down its output into digestible pieces.

What You Will Learn:

Exactly how indexes are used during your queries and aggregations

How to diagnose your poorly performing operations

How to tune your most important operations to ensure that they scale seamlessly

Previous Presentation
Sizing MongoDB Clusters
Sizing MongoDB Clusters

Speaker: Jay Runkel, Principal Solution Architect, MongoDB Session Type: 40 minute main track session Trac...

Next Presentation
Making Your MongoDB Community Edition Installation More Secure
Making Your MongoDB Community Edition Installation More Secure

Speaker: Tom Spitzer, Vice President, Engineering, EC Wise, Inc. Session Type: 40 minute main track sessio...