Skip to content

Instantly share code, notes, and snippets.

@wiliame
Created March 11, 2014 09:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wiliame/391289227b62871ab0e4 to your computer and use it in GitHub Desktop.
Save wiliame/391289227b62871ab0e4 to your computer and use it in GitHub Desktop.
{
"cursor": "BtreeCursor _id_ reverse",
"isMultiKey": false,
"n": NumberInt(1),
"nscannedObjects": NumberInt(2414690),
"nscanned": NumberInt(2414690),
"nscannedObjectsAllPlans": NumberInt(2415221),
"nscannedAllPlans": NumberInt(2415290),
"scanAndOrder": false,
"indexOnly": false,
"nYields": NumberInt(19527),
"nChunkSkips": NumberInt(0),
"millis": NumberInt(22461),
"indexBounds": {
"_id": [
[
{
"$maxElement": NumberInt(1)
},
{
"$minElement": NumberInt(1)
}
]
]
},
"allPlans": [
{
"cursor": "BtreeCursor _id_ reverse",
"isMultiKey": false,
"n": NumberInt(1),
"nscannedObjects": NumberInt(2414690),
"nscanned": NumberInt(2414690),
"scanAndOrder": false,
"indexOnly": false,
"nChunkSkips": NumberInt(0),
"indexBounds": {
"_id": [
[
{
"$maxElement": NumberInt(1)
},
{
"$minElement": NumberInt(1)
}
]
]
}
},
{
"cursor": "BtreeCursor namespace_1_eloc_1",
"isMultiKey": false,
"n": NumberInt(0),
"nscannedObjects": NumberInt(99),
"nscanned": NumberInt(100),
"scanAndOrder": true,
"indexOnly": false,
"nChunkSkips": NumberInt(0),
"indexBounds": {
"namespace": [
[
"rsvcom",
"rsvcom"
]
],
"eloc": [
[
{
"$minElement": NumberInt(1)
},
{
"$maxElement": NumberInt(1)
}
]
]
}
},
{
"cursor": "BtreeCursor namespace_1_active_1_searchable_1_type_1_keywords_names_1",
"isMultiKey": true,
"n": NumberInt(0),
"nscannedObjects": NumberInt(95),
"nscanned": NumberInt(100),
"scanAndOrder": true,
"indexOnly": false,
"nChunkSkips": NumberInt(0),
"indexBounds": {
"namespace": [
[
"rsvcom",
"rsvcom"
]
],
"active": [
[
true,
true
]
],
"searchable": [
[
true,
true
]
],
"type": [
[
"EA",
"EA"
]
],
"keywords.names": [
[
{
"$minElement": NumberInt(1)
},
{
"$maxElement": NumberInt(1)
}
]
]
}
},
{
"cursor": "BtreeCursor namespace_1_active_1_searchable_1_type_1_keywords_soundex_1",
"isMultiKey": true,
"n": NumberInt(0),
"nscannedObjects": NumberInt(99),
"nscanned": NumberInt(100),
"scanAndOrder": true,
"indexOnly": false,
"nChunkSkips": NumberInt(0),
"indexBounds": {
"namespace": [
[
"rsvcom",
"rsvcom"
]
],
"active": [
[
true,
true
]
],
"searchable": [
[
true,
true
]
],
"type": [
[
"EA",
"EA"
]
],
"keywords.soundex": [
[
{
"$minElement": NumberInt(1)
},
{
"$maxElement": NumberInt(1)
}
]
]
}
},
{
"cursor": "BtreeCursor namespace_1_active_1_searchable_1_type_1_keywords_reverse_soundex_1",
"isMultiKey": true,
"n": NumberInt(0),
"nscannedObjects": NumberInt(99),
"nscanned": NumberInt(100),
"scanAndOrder": true,
"indexOnly": false,
"nChunkSkips": NumberInt(0),
"indexBounds": {
"namespace": [
[
"rsvcom",
"rsvcom"
]
],
"active": [
[
true,
true
]
],
"searchable": [
[
true,
true
]
],
"type": [
[
"EA",
"EA"
]
],
"keywords.reverse_soundex": [
[
{
"$minElement": NumberInt(1)
},
{
"$maxElement": NumberInt(1)
}
]
]
}
},
{
"cursor": "BtreeCursor namespace_1_active_1_searchable_1_type_1_keywords_plain_1",
"isMultiKey": true,
"n": NumberInt(0),
"nscannedObjects": NumberInt(76),
"nscanned": NumberInt(100),
"scanAndOrder": true,
"indexOnly": false,
"nChunkSkips": NumberInt(0),
"indexBounds": {
"namespace": [
[
"rsvcom",
"rsvcom"
]
],
"active": [
[
true,
true
]
],
"searchable": [
[
true,
true
]
],
"type": [
[
"EA",
"EA"
]
],
"keywords.plain": [
[
{
"$minElement": NumberInt(1)
},
{
"$maxElement": NumberInt(1)
}
]
]
}
},
{
"cursor": "BtreeCursor namespace_1_active_1_searchable_1_type_1_keywords_extended_1",
"isMultiKey": true,
"n": NumberInt(0),
"nscannedObjects": NumberInt(63),
"nscanned": NumberInt(100),
"scanAndOrder": true,
"indexOnly": false,
"nChunkSkips": NumberInt(0),
"indexBounds": {
"namespace": [
[
"rsvcom",
"rsvcom"
]
],
"active": [
[
true,
true
]
],
"searchable": [
[
true,
true
]
],
"type": [
[
"EA",
"EA"
]
],
"keywords.extended": [
[
{
"$minElement": NumberInt(1)
},
{
"$maxElement": NumberInt(1)
}
]
]
}
}
],
"server": "WiliamPC:27017",
"filterSet": false,
"stats": {
"type": "FETCH",
"works": NumberInt(2415441),
"yields": NumberInt(19527),
"unyields": NumberInt(19527),
"invalidates": NumberInt(0),
"advanced": NumberInt(1),
"needTime": NumberInt(2414689),
"needFetch": NumberInt(750),
"isEOF": NumberInt(1),
"alreadyHasObj": NumberInt(0),
"forcedFetches": NumberInt(0),
"matchTested": NumberInt(1),
"children": [
{
"type": "IXSCAN",
"works": NumberInt(2414690),
"yields": NumberInt(19527),
"unyields": NumberInt(19527),
"invalidates": NumberInt(0),
"advanced": NumberInt(2414690),
"needTime": NumberInt(0),
"needFetch": NumberInt(0),
"isEOF": NumberInt(1),
"keyPattern": "{ _id: 1 }",
"boundsVerbose": "field #0['_id']: [MaxKey, MinKey]",
"isMultiKey": NumberInt(0),
"yieldMovedCursor": NumberInt(0),
"dupsTested": NumberInt(0),
"dupsDropped": NumberInt(0),
"seenInvalidated": NumberInt(0),
"matchTested": NumberInt(0),
"keysExamined": NumberInt(2414690),
"children": [
]
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment