"winningPlan" : { "stage" : "EOF"

What does
“winningPlan” : {
“stage” : “EOF”

means ? id did expect colscan order idxscan


Hi @Kiron_Ip_Yarda,

EOF (end-of-file) means no more data can be read. If this is indicated as the winning plan, I expect you haven’t queried the intended namespace (perhaps didn’t use the intended database?) or the target collection has not been created yet. I would confirm the queryPlanner.namespace value in your explain plan is as expected.

If collection data exists, an explain with executionStats will include an isEOF indication in executionStages when a stage indicates there are no further results to return.