Wednesday, June 10 • 12:35pm - 1:20pm
Tips and Tricks for Query Performance: Let Us .explain() Them

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Explain plans are the basis for both understanding and tuning query performance in MongoDB. They contain all of the information one could ever need when performing that task such as the enumerated plans, execution metrics, index bounds, and much (much) more. But translating that data into optimized query performance can feel like a daunting task that is reserved for experts.

This intermediate-level talk, based on my years of experience tuning MongoDB queries as a member of the global support organization, will demonstrate to you that anybody can read and interpret an explain plan.

During the talk we will discuss some fundamental concepts powering the optimizer, we will discover the hidden gems that are buried as key metrics in explain plans, and I will share with you the secret navigation tricks that we use to read explain plan treasure maps. Together, we will find where X marks the spot to reveal a bounty of performant queries … Arr, Matey!

avatar for Chris Harris

Chris Harris

Senior Technical Services Engineer, MongoDB
Chris joined MongoDB at the beginning of 2016 and has enjoyed helping customer succeed ever since. He particularly enjoys learning about and assisting with any question related to queries and indexing. In his free time Chris enjoys crashing his drone, learning random new skills, and... Read More →

Wednesday June 10, 2020 12:35pm - 1:20pm EDT
Breakout Theater 5