Reading an explain plan - inside out?

So just confirm, an winning plan is read from the inside out, so the execution plan will execute the IXSCAN, the SHARDING_FILTER is next, finally followed by the FETCH?

To be honest I have always found reading the explain documents a challenge.

“winningPlan” : {
“stage” : “FETCH”,
“inputStage” : {
“stage” : “SHARDING_FILTER”,
“inputStage” : {
“stage” : “IXSCAN”,
“keyPattern” : {
“sku” : 1
},

1 Like

@NMullins IMO I believe so, but I had to of deduce it by the the wording in some online documentation concerning “parent node”, etc… I think going by the order in the plan it seems counterintuitive.

  • Mike