Understanding Query Targeting

[Ikar_Pohorsky]

What is the difference between:

• Query Targeting: Scanned Objects / Returned
• Query Targeting: Scanned / Returned

I’d understand one of them means:

mongo had to load & scan X documents in order to return Y documents

…so the targeting is X/Y

But what I don’t understand is the difference between the two. They usually raise together but sometimes only one of them goes up

Any clearance would be appreciated.

[MaBeuLux88 (Maxime Beugnet)]

Hi @Ikar_Pohorsky and welcome in the MongoDB Community !

I think what you are looking for is in this doc: https://docs.atlas.mongodb.com/review-available-metrics/

Cheers,
Maxime.

[Ikar_Pohorsky]

Thanks @MaBeuLux88 for the clarification! Here’s a follow-up question:
https://www.mongodb.com/community/forums/t/how-to-find-queries-with-high-query-targeting/127779