Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
database.tablebusiness query: { LongitudeLatitude: { $nearSphere: [ 106.772835, -6.186753 ], $maxDistance: 0.04498373205078301 }, Prominent: { $gte: 15 }, indexContents: { $all: [ /^aru/, /^op/ ] } } ntoreturn:20 ntoskip:80 nscanned:100 nreturned:20 reslen:1147 1927ms

it seems that ntoreturn means number to return. ntoskip is numbers to skip. nscanned seem to be the sum of the 2.

What is reslen?

I search google with no answer. What site explain what reslen is?

share|improve this question… – dezso Sep 5 '12 at 8:03
Who downvotes and why? You think it's that obvious what the profiling tool is and how it has anything to do with log? Can you get that through google easily? – Jim Thio Sep 5 '12 at 8:57
The latter. I fed google with "mongodb reslen", and in the very first hit I searched for reslen. All this in 30 seconds. Without knowing a bit about MongoDB. – dezso Sep 5 '12 at 8:59
I saw many documents containing both mongodb and reslen, most simply come from someone copying and pasting it's log. Somehow the first result is what works for you. I forget query I searched but that result is not in first 10. Also how do users, searching for mongodb reslen knows that that the site will explain about reslen? Most other results don't. – Jim Thio Sep 5 '12 at 9:12
without checking those search results you'll never know... I've just checked the first one. – dezso Sep 5 '12 at 9:16
up vote 5 down vote accepted

reslen is the query result length in bytes. From the profiler docs here:

share|improve this answer
Thanks a lot. Now I see. Can't find it anywhere. – Jim Thio Sep 5 '12 at 8:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.