Query Targeting: Scanned Objects / Returned has gone above 1000

6,461 views
Skip to first unread message

alain....@adixon.fr

unread,
Nov 20, 2018, 7:11:25 AM11/20/18
to mongodb-user
Hi all,

I keep receiving this message: 
Query Targeting: Scanned Objects / Returned has gone above 1000 

The problem is my Meteor website is not live yet so I don't understand why I receive this alert ?
When I go to the Performance Advisor from Mongo Atlas, The page is empty :(

Any idea?

Alain

Kevin Adistambha

unread,
Nov 26, 2018, 7:56:14 PM11/26/18
to mongodb-user

Hi Alain,

The meaning of the message:

Query Targeting: Scanned Objects / Returned has gone above 1000

is explained in the Query Targeting page. This message means that you are scanning many more documents compared to the number of documents returned by the query, meaning that the query is executed in an inefficient manner. Typically this can be remedied by creating a proper index. See Indexing Strategies for more information on how to create indexes that support your queries.

Note that if you’re an Atlas customer, you can also click on the Support link on the Atlas page to get support specific to your deployment.

Best regards,
Kevin

Alok Patra

unread,
Feb 21, 2019, 4:52:40 PM2/21/19
to mongodb-user
Even I am getting this mail 2-3 times a day. Performance Advisor is empty. I downloaded the logs but cannot find the query which is running inefficiently to trigger the alert. 
When I try to access the support portal, I get an error saying "Your user account has not been enabled for access to the Support site" although am running an M10.
How do I go about resolving it?

Kevin Adistambha

unread,
Feb 22, 2019, 1:41:14 AM2/22/19
to mongodb-user

Hi Alok,

I get an error saying “Your user account has not been enabled for access to the Support site” although am running an M10.

If you’re an Atlas customer, there should be a chat button on the lower right hand corner of your screen. This will connect you to a support person that may be able to resolve this.

Best regards,
Kevin

Reply all
Reply to author
Forward
0 new messages