Skip to content

Instantly share code, notes, and snippets.

@benwbrum

benwbrum/test1_query_explain_plan_results.js

Last active December 17, 2015 18:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save benwbrum/5656877 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save benwbrum/5656877 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test1_query_explain_plan_results.js
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"james","last_name":"brumfield"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 7,
"nscannedObjects" : 308,
"nscanned" : 308,
"nscannedObjectsAllPlans" : 308,
"nscannedAllPlans" : 308,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 8,
"nChunkSkips" : 0,
"millis" : 8329,
"indexBounds" : {
"primary_names.last_name" : [
[
"brumfield",
"brumfield"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"james","last_name":"brumfield"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 7,
"nscannedObjects" : 308,
"nscanned" : 308,
"nscannedObjectsAllPlans" : 308,
"nscannedAllPlans" : 308,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"brumfield",
"brumfield"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"chapman_code":"BDF","primary_names":{"$elemMatch":{"last_name":"carlstead"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 0,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"carlstead",
"carlstead"
]
],
"chapman_code" : [
[
"BDF",
"BDF"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"inclusive_names":{"$elemMatch":{"first_name":"william","last_name":"maxee"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 11,
"nscanned" : 11,
"nscannedObjectsAllPlans" : 11,
"nscannedAllPlans" : 11,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 214,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"maxee",
"maxee"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"william","last_name":"smith"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 22690,
"nscannedObjects" : 359863,
"nscanned" : 359863,
"nscannedObjectsAllPlans" : 359863,
"nscannedAllPlans" : 359863,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 27601,
"nChunkSkips" : 0,
"millis" : 3655855,
"indexBounds" : {
"primary_names.last_name" : [
[
"smith",
"smith"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"BDF","primary_names":{"$elemMatch":{"last_name":"carlstead"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 0,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"carlstead",
"carlstead"
]
],
"chapman_code" : [
[
"BDF",
"BDF"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"inclusive_names":{"$elemMatch":{"first_name":"william","last_name":"towler"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 301,
"nscannedObjects" : 4684,
"nscanned" : 4684,
"nscannedObjectsAllPlans" : 4684,
"nscannedAllPlans" : 4684,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 24,
"nChunkSkips" : 0,
"millis" : 25818,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"towler",
"towler"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"william","last_name":"brumfield"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 16,
"nscannedObjects" : 308,
"nscanned" : 308,
"nscannedObjectsAllPlans" : 308,
"nscannedAllPlans" : 308,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 3999,
"indexBounds" : {
"primary_names.last_name" : [
[
"brumfield",
"brumfield"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 312,
"nChunkSkips" : 0,
"millis" : 36306,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john titus","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 332,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"last_name":"cranness"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 75,
"nscannedObjects" : 75,
"nscanned" : 75,
"nscannedObjectsAllPlans" : 75,
"nscannedAllPlans" : 75,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1211,
"indexBounds" : {
"primary_names.last_name" : [
[
"cranness",
"cranness"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
>
>
>
>
>
>
>
>
>
> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"ella","last_name":"cranness"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 75,
"nscanned" : 75,
"nscannedObjectsAllPlans" : 75,
"nscannedAllPlans" : 75,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"cranness",
"cranness"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"ella may","last_name":"cranness"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 75,
"nscanned" : 75,
"nscannedObjectsAllPlans" : 75,
"nscannedAllPlans" : 75,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"cranness",
"cranness"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 32006,
"nscannedObjects" : 32006,
"nscanned" : 32006,
"nscannedObjectsAllPlans" : 32006,
"nscannedAllPlans" : 32006,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1847,
"nChunkSkips" : 0,
"millis" : 206204,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"NFK","primary_names":{"$elemMatch":{"last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 7861,
"nscannedObjects" : 7861,
"nscanned" : 7861,
"nscannedObjectsAllPlans" : 7861,
"nscannedAllPlans" : 7861,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 107,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"eliza","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 36,
"nscannedObjects" : 7901,
"nscanned" : 7901,
"nscannedObjectsAllPlans" : 7901,
"nscannedAllPlans" : 7901,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 334,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"e","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 32400,
"nscanned" : 32400,
"nscannedObjectsAllPlans" : 32400,
"nscannedAllPlans" : 32400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 1709,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"william","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1921,
"nscannedObjects" : 32400,
"nscanned" : 32400,
"nscannedObjectsAllPlans" : 32400,
"nscannedAllPlans" : 32400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 76,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"wm","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 55,
"nscannedObjects" : 32400,
"nscanned" : 32400,
"nscannedObjectsAllPlans" : 32400,
"nscannedAllPlans" : 32400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 153,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"bu","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"brimble","last_name":"james"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 9467,
"nscanned" : 9467,
"nscannedObjectsAllPlans" : 37868,
"nscannedAllPlans" : 37868,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2173,
"nChunkSkips" : 0,
"millis" : 283299,
"indexBounds" : {
"primary_names.last_name" : [
[
"james",
"james"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"bu","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"james","last_name":"brimble"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 25,
"nscannedObjects" : 1523,
"nscanned" : 1523,
"nscannedObjectsAllPlans" : 6092,
"nscannedAllPlans" : 6092,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 7,
"nChunkSkips" : 0,
"millis" : 8222,
"indexBounds" : {
"primary_names.last_name" : [
[
"brimble",
"brimble"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"wm.","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 35,
"nscannedObjects" : 32400,
"nscanned" : 32400,
"nscannedObjectsAllPlans" : 32400,
"nscannedAllPlans" : 32400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 24,
"nChunkSkips" : 0,
"millis" : 24632,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_soundex":{"$elemMatch":{"first_name":"J500","last_name":"S540"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 84,
"nscannedObjects" : 24205,
"nscanned" : 24205,
"nscannedObjectsAllPlans" : 48410,
"nscannedAllPlans" : 48410,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 361,
"nChunkSkips" : 0,
"millis" : 331302,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"S540",
"S540"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"wm.","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 7861,
"nscanned" : 7861,
"nscannedObjectsAllPlans" : 31444,
"nscannedAllPlans" : 31444,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1972,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"NFK","inclusive_names":{"$elemMatch":{"first_name":"wm.","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 15795,
"nscanned" : 15795,
"nscannedObjectsAllPlans" : 47386,
"nscannedAllPlans" : 47386,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 22,
"nChunkSkips" : 0,
"millis" : 15416,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"snell"}}} ).explain();
{
"cursor" : "BasicCursor",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 24020988,
"nscanned" : 24020988,
"nscannedObjectsAllPlans" : 24020988,
"nscannedAllPlans" : 24020988,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 3409,
"nChunkSkips" : 0,
"millis" : 1022028,
"indexBounds" : {
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"snell"}}} ).explain();
{
"cursor" : "BasicCursor",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 24020988,
"nscanned" : 24020988,
"nscannedObjectsAllPlans" : 24020988,
"nscannedAllPlans" : 24020988,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 3059,
"nChunkSkips" : 0,
"millis" : 891418,
"indexBounds" : {
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"chapman_code":"SOM","inclusive_names":{"$elemMatch":{"first_name":"wallington","last_name":"brimble"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 3056,
"nscanned" : 3056,
"nscannedObjectsAllPlans" : 3056,
"nscannedAllPlans" : 3056,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 671,
"nChunkSkips" : 0,
"millis" : 37823,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"brimble",
"brimble"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 330,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 2637,
"nscannedAllPlans" : 2637,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 51,
"nChunkSkips" : 0,
"millis" : 59889,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"wm.","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 35,
"nscannedObjects" : 32400,
"nscanned" : 32400,
"nscannedObjectsAllPlans" : 32400,
"nscannedAllPlans" : 32400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 3750,
"nChunkSkips" : 0,
"millis" : 537776,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"wm.","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 5,
"nscannedObjects" : 7901,
"nscanned" : 7901,
"nscannedObjectsAllPlans" : 7901,
"nscannedAllPlans" : 7901,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 785,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","primary_names":{"$elemMatch":{"last_name":"kingston"}}} ).explain();
r
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1047,
"nscannedObjects" : 3997,
"nscanned" : 3997,
"nscannedObjectsAllPlans" : 4978,
"nscannedAllPlans" : 4978,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 359,
"nChunkSkips" : 0,
"millis" : 42637,
"indexBounds" : {
"primary_names.last_name" : [
[
"kingston",
"kingston"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"bu","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"emma","last_name":"snell"}}} ).explain();
n
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 22,
"nChunkSkips" : 0,
"millis" : 24938,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"bu","chapman_code":"LIN","inclusive_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 37,
"nscannedObjects" : 2393,
"nscanned" : 2393,
"nscannedObjectsAllPlans" : 7180,
"nscannedAllPlans" : 7180,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 58,
"nChunkSkips" : 0,
"millis" : 20462,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"bu","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 28,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 119,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 28,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1457,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 418,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"last_name":"laurie"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 758,
"nscannedObjects" : 758,
"nscanned" : 758,
"nscannedObjectsAllPlans" : 758,
"nscannedAllPlans" : 758,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 8,
"nChunkSkips" : 0,
"millis" : 9305,
"indexBounds" : {
"primary_names.last_name" : [
[
"laurie",
"laurie"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"primary_names":{"$elemMatch":{"last_name":"laurie"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 758,
"nscannedObjects" : 758,
"nscanned" : 758,
"nscannedObjectsAllPlans" : 758,
"nscannedAllPlans" : 758,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 4,
"indexBounds" : {
"primary_names.last_name" : [
[
"laurie",
"laurie"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"k","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 7901,
"nscanned" : 7901,
"nscannedObjectsAllPlans" : 7901,
"nscannedAllPlans" : 7901,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 51,
"nChunkSkips" : 0,
"millis" : 31645,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"edward","last_name":"dawson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 67,
"nscannedObjects" : 7901,
"nscanned" : 7901,
"nscannedObjectsAllPlans" : 7901,
"nscannedAllPlans" : 7901,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 317,
"indexBounds" : {
"primary_names.last_name" : [
[
"dawson",
"dawson"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"DEV","primary_names":{"$elemMatch":{"last_name":"fairchild"}}} ).explain();
"
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 67,
"nscannedObjects" : 121,
"nscanned" : 121,
"nscannedObjectsAllPlans" : 484,
"nscannedAllPlans" : 484,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 6,
"nChunkSkips" : 0,
"millis" : 7460,
"indexBounds" : {
"primary_names.last_name" : [
[
"fairchild",
"fairchild"
]
],
"chapman_code" : [
[
"DEV",
"DEV"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"DEV","primary_soundex":{"$elemMatch":{"last_name":"F624"}}} ).explain();
e
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 101,
"nscannedObjects" : 5997,
"nscanned" : 5997,
"nscannedObjectsAllPlans" : 11886,
"nscannedAllPlans" : 11886,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2011,
"nChunkSkips" : 0,
"millis" : 142123,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"F624",
"F624"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"DEV","primary_soundex":{"$elemMatch":{"last_name":"F624"}}} ).explain();
(
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 26,
"nscannedObjects" : 5997,
"nscanned" : 5997,
"nscannedObjectsAllPlans" : 11994,
"nscannedAllPlans" : 11994,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 648,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"F624",
"F624"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"bu","chapman_code":"DEV","inclusive_soundex":{"$elemMatch":{"first_name":"J500","last_name":"F624"}}} ).explain();
s
{
"cursor" : "BtreeCursor inclusive_soundex.last_name_1_chapman_code_1_inclusive_soundex.first_name_1",
"isMultiKey" : true,
"n" : 12,
"nscannedObjects" : 301,
"nscanned" : 301,
"nscannedObjectsAllPlans" : 904,
"nscannedAllPlans" : 904,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 387,
"indexBounds" : {
"inclusive_soundex.last_name" : [
[
"F624",
"F624"
]
],
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"inclusive_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"DEV","inclusive_soundex":{"$elemMatch":{"first_name":"J500","last_name":"F624"}}} ).explain();
d
{
"cursor" : "BtreeCursor inclusive_soundex.last_name_1_chapman_code_1_inclusive_soundex.first_name_1",
"isMultiKey" : true,
"n" : 3,
"nscannedObjects" : 301,
"nscanned" : 301,
"nscannedObjectsAllPlans" : 904,
"nscannedAllPlans" : 904,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 5,
"indexBounds" : {
"inclusive_soundex.last_name" : [
[
"F624",
"F624"
]
],
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"inclusive_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"DEV","inclusive_soundex":{"$elemMatch":{"first_name":"J500","last_name":"F624"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_soundex.last_name_1_chapman_code_1_inclusive_soundex.first_name_1",
"isMultiKey" : true,
"n" : 48,
"nscannedObjects" : 301,
"nscanned" : 301,
"nscannedObjectsAllPlans" : 904,
"nscannedAllPlans" : 904,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 4,
"indexBounds" : {
"inclusive_soundex.last_name" : [
[
"F624",
"F624"
]
],
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"inclusive_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"DEV","primary_soundex":{"$elemMatch":{"first_name":"J500","last_name":"D553"}}} ).explain();
;
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 19,
"nscannedObjects" : 4725,
"nscanned" : 4725,
"nscannedObjectsAllPlans" : 9450,
"nscannedAllPlans" : 9450,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 47,
"nChunkSkips" : 0,
"millis" : 52959,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"D553",
"D553"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","chapman_code":"DEV","inclusive_soundex":{"$elemMatch":{"first_name":"J500","last_name":"D553"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_soundex.last_name_1_chapman_code_1_inclusive_soundex.first_name_1",
"isMultiKey" : true,
"n" : 20,
"nscannedObjects" : 1490,
"nscanned" : 1490,
"nscannedObjectsAllPlans" : 4471,
"nscannedAllPlans" : 4471,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 495,
"indexBounds" : {
"inclusive_soundex.last_name" : [
[
"D553",
"D553"
]
],
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"inclusive_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"greenfield"}}} ).explain();
b
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 36,
"nscannedObjects" : 88,
"nscanned" : 88,
"nscannedObjectsAllPlans" : 352,
"nscannedAllPlans" : 352,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2897,
"indexBounds" : {
"primary_names.last_name" : [
[
"greenfield",
"greenfield"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"smith"}}} ).explain();
n
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 3560,
"nscannedObjects" : 7699,
"nscanned" : 7699,
"nscannedObjectsAllPlans" : 8460,
"nscannedAllPlans" : 8460,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 944,
"nChunkSkips" : 0,
"millis" : 58418,
"indexBounds" : {
"primary_names.last_name" : [
[
"smith",
"smith"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"alice","last_name":"towlson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 59,
"nscanned" : 59,
"nscannedObjectsAllPlans" : 236,
"nscannedAllPlans" : 236,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1606,
"indexBounds" : {
"primary_names.last_name" : [
[
"towlson",
"towlson"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"abraham","last_name":"hemingway"}}} ).explain();
r
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 1443,
"nscanned" : 1443,
"nscannedObjectsAllPlans" : 5772,
"nscannedAllPlans" : 5772,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 14503,
"indexBounds" : {
"primary_names.last_name" : [
[
"hemingway",
"hemingway"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"charles","last_name":"hemingway"}}} ).explain();
b
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 6,
"nscannedObjects" : 1443,
"nscanned" : 1443,
"nscannedObjectsAllPlans" : 5772,
"nscannedAllPlans" : 5772,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 53,
"indexBounds" : {
"primary_names.last_name" : [
[
"hemingway",
"hemingway"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","primary_names":{"$elemMatch":{"first_name":"john titus","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 5524,
"nscanned" : 5524,
"nscannedObjectsAllPlans" : 22096,
"nscannedAllPlans" : 22096,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 457,
"nChunkSkips" : 0,
"millis" : 32470,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","primary_names":{"$elemMatch":{"first_name":"john titus","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 5524,
"nscanned" : 5524,
"nscannedObjectsAllPlans" : 22096,
"nscannedAllPlans" : 22096,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2476,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","primary_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 5524,
"nscanned" : 5524,
"nscannedObjectsAllPlans" : 22096,
"nscannedAllPlans" : 22096,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 55,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","primary_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 5524,
"nscanned" : 5524,
"nscannedObjectsAllPlans" : 22096,
"nscannedAllPlans" : 22096,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 110,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ba","primary_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 5524,
"nscanned" : 5524,
"nscannedObjectsAllPlans" : 22096,
"nscannedAllPlans" : 22096,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 82,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","primary_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 5524,
"nscanned" : 5524,
"nscannedObjectsAllPlans" : 22096,
"nscannedAllPlans" : 22096,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 55,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
//> db.search_records.find( {"record_type":"ma","inclusive_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 10229,
"nscanned" : 10229,
"nscannedObjectsAllPlans" : 30687,
"nscannedAllPlans" : 30687,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 4301,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"snell",
"snell"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"NFK","inclusive_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
r
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1401,
"nscanned" : 1401,
"nscannedObjectsAllPlans" : 4204,
"nscannedAllPlans" : 4204,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 72,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","inclusive_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 2393,
"nscanned" : 2393,
"nscannedObjectsAllPlans" : 7180,
"nscannedAllPlans" : 7180,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 36,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 12,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john titus ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 15,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john titus ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 17,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","primary_names":{"$elemMatch":{"first_name":"john titus","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 5524,
"nscanned" : 5524,
"nscannedObjectsAllPlans" : 22096,
"nscannedAllPlans" : 22096,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 190,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 149,
"nscannedObjects" : 5570,
"nscanned" : 5570,
"nscannedObjectsAllPlans" : 13953,
"nscannedAllPlans" : 13953,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 135,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 41,
"nscannedObjects" : 218,
"nscanned" : 218,
"nscannedObjectsAllPlans" : 872,
"nscannedAllPlans" : 872,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 4442,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 11,
"nscannedObjects" : 687,
"nscanned" : 687,
"nscannedObjectsAllPlans" : 2748,
"nscannedAllPlans" : 2748,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 118,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"CAM","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 30,
"nscanned" : 30,
"nscannedObjectsAllPlans" : 120,
"nscannedAllPlans" : 120,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"CAM",
"CAM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"CAM","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 30,
"nscanned" : 30,
"nscannedObjectsAllPlans" : 120,
"nscannedAllPlans" : 120,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"CAM",
"CAM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SFK","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 38,
"nscanned" : 38,
"nscannedObjectsAllPlans" : 152,
"nscannedAllPlans" : 152,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"SFK",
"SFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 21,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"dashword"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 4,
"nscannedAllPlans" : 4,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 11,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashword",
"dashword"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","inclusive_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 105,
"nscannedObjects" : 383,
"nscanned" : 383,
"nscannedObjectsAllPlans" : 1012,
"nscannedAllPlans" : 1012,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 755,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 72,
"nscannedObjects" : 218,
"nscanned" : 218,
"nscannedObjectsAllPlans" : 872,
"nscannedAllPlans" : 872,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 39,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_soundex":{"$elemMatch":{"first_name":"J500","last_name":"S540"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 84,
"nscannedObjects" : 24205,
"nscanned" : 24205,
"nscannedObjectsAllPlans" : 48410,
"nscannedAllPlans" : 48410,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1737,
"nChunkSkips" : 0,
"millis" : 217342,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"S540",
"S540"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"DOR","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 21,
"nscannedObjects" : 62,
"nscanned" : 62,
"nscannedObjectsAllPlans" : 248,
"nscannedAllPlans" : 248,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 358,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"DOR",
"DOR"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john *","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 64,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john ?","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 12,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john t","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 12,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"NTH","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 4,
"nscannedAllPlans" : 4,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 178,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"NTH",
"NTH"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"OXF","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 2,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"OXF",
"OXF"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LEI","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 4,
"nscannedAllPlans" : 4,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"LEI",
"LEI"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SAL","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 2,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"SAL",
"SAL"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"BDF","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 2,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"BDF",
"BDF"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"joan","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 9472,
"nscanned" : 9472,
"nscannedObjectsAllPlans" : 37888,
"nscannedAllPlans" : 37888,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1612,
"nChunkSkips" : 0,
"millis" : 266224,
"indexBounds" : {
"primary_names.last_name" : [
[
"king",
"king"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"william","last_name":"claxon"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 15,
"nscannedObjects" : 595,
"nscanned" : 595,
"nscannedObjectsAllPlans" : 2380,
"nscannedAllPlans" : 2380,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 8543,
"indexBounds" : {
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"joan emma","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 9472,
"nscanned" : 9472,
"nscannedObjectsAllPlans" : 37888,
"nscannedAllPlans" : 37888,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 721,
"indexBounds" : {
"primary_names.last_name" : [
[
"king",
"king"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"emma","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 33,
"nscannedObjects" : 9472,
"nscanned" : 9472,
"nscannedObjectsAllPlans" : 37888,
"nscannedAllPlans" : 37888,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 166,
"indexBounds" : {
"primary_names.last_name" : [
[
"king",
"king"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"william","last_name":"claxon"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 12,
"nscannedObjects" : 595,
"nscanned" : 595,
"nscannedObjectsAllPlans" : 2380,
"nscannedAllPlans" : 2380,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 235,
"indexBounds" : {
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"william","last_name":"claxon"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 8,
"nscannedObjects" : 595,
"nscanned" : 595,
"nscannedObjectsAllPlans" : 2380,
"nscannedAllPlans" : 2380,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 345,
"indexBounds" : {
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","inclusive_soundex":{"$elemMatch":{"first_name":"J500","last_name":"K520"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_soundex.last_name_1_chapman_code_1_inclusive_soundex.first_name_1",
"isMultiKey" : true,
"n" : 1474,
"nscannedObjects" : 19295,
"nscanned" : 19295,
"nscannedObjectsAllPlans" : 20822,
"nscannedAllPlans" : 20822,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 53,
"nChunkSkips" : 0,
"millis" : 16916,
"indexBounds" : {
"inclusive_soundex.last_name" : [
[
"K520",
"K520"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"inclusive_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_soundex":{"$elemMatch":{"last_name":"B260"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 237,
"nscannedObjects" : 88215,
"nscanned" : 88215,
"nscannedObjectsAllPlans" : 124703,
"nscannedAllPlans" : 124703,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 5018,
"nChunkSkips" : 0,
"millis" : 773922,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"B260",
"B260"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"booker"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 94,
"nscannedObjects" : 158,
"nscanned" : 158,
"nscannedObjectsAllPlans" : 632,
"nscannedAllPlans" : 632,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 207,
"indexBounds" : {
"primary_names.last_name" : [
[
"booker",
"booker"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"joan","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 9472,
"nscanned" : 9472,
"nscannedObjectsAllPlans" : 37888,
"nscannedAllPlans" : 37888,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 3436,
"indexBounds" : {
"primary_names.last_name" : [
[
"king",
"king"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"adeline doris","last_name":"satchell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 297,
"nscanned" : 297,
"nscannedObjectsAllPlans" : 1188,
"nscannedAllPlans" : 1188,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 6,
"nChunkSkips" : 0,
"millis" : 6366,
"indexBounds" : {
"primary_names.last_name" : [
[
"satchell",
"satchell"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"johannis","last_name":"knowles"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 646,
"nscanned" : 646,
"nscannedObjectsAllPlans" : 2584,
"nscannedAllPlans" : 2584,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 17,
"nChunkSkips" : 0,
"millis" : 18284,
"indexBounds" : {
"primary_names.last_name" : [
[
"knowles",
"knowles"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"norman douglas","last_name":"walker"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 2511,
"nscanned" : 2511,
"nscannedObjectsAllPlans" : 10044,
"nscannedAllPlans" : 10044,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 495,
"nChunkSkips" : 0,
"millis" : 70513,
"indexBounds" : {
"primary_names.last_name" : [
[
"walker",
"walker"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"hale","last_name":"nora matilda"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 16,
"indexBounds" : {
"primary_names.last_name" : [
[
"nora matilda",
"nora matilda"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"hale","last_name":"nora matilda"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"nora matilda",
"nora matilda"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"nora matilda","last_name":"hale"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1512,
"nscanned" : 1512,
"nscannedObjectsAllPlans" : 6048,
"nscannedAllPlans" : 6048,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 408,
"nChunkSkips" : 0,
"millis" : 39018,
"indexBounds" : {
"primary_names.last_name" : [
[
"hale",
"hale"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"anne","last_name":"narde"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 4,
"nscannedAllPlans" : 4,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 18,
"indexBounds" : {
"primary_names.last_name" : [
[
"narde",
"narde"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"samuel","last_name":"hammett"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 104,
"nscanned" : 104,
"nscannedObjectsAllPlans" : 416,
"nscannedAllPlans" : 416,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2399,
"indexBounds" : {
"primary_names.last_name" : [
[
"hammett",
"hammett"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"henry wilcox","last_name":"down"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 1229,
"nscanned" : 1229,
"nscannedObjectsAllPlans" : 4916,
"nscannedAllPlans" : 4916,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 25,
"nChunkSkips" : 0,
"millis" : 26309,
"indexBounds" : {
"primary_names.last_name" : [
[
"down",
"down"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"robert","last_name":"wallbutton"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 37,
"nscanned" : 37,
"nscannedObjectsAllPlans" : 148,
"nscannedAllPlans" : 148,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 448,
"indexBounds" : {
"primary_names.last_name" : [
[
"wallbutton",
"wallbutton"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"robert","last_name":"wallbutton"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 37,
"nscanned" : 37,
"nscannedObjectsAllPlans" : 148,
"nscannedAllPlans" : 148,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"wallbutton",
"wallbutton"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"thomas","last_name":"roynon"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 406,
"nscanned" : 406,
"nscannedObjectsAllPlans" : 1624,
"nscannedAllPlans" : 1624,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 3,
"nChunkSkips" : 0,
"millis" : 3190,
"indexBounds" : {
"primary_names.last_name" : [
[
"roynon",
"roynon"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"greenwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 792,
"nscannedObjects" : 1614,
"nscanned" : 1614,
"nscannedObjectsAllPlans" : 2282,
"nscannedAllPlans" : 2282,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 19,
"nChunkSkips" : 0,
"millis" : 22811,
"indexBounds" : {
"primary_names.last_name" : [
[
"greenwood",
"greenwood"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"john","last_name":"brimble"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 1523,
"nscanned" : 1523,
"nscannedObjectsAllPlans" : 6092,
"nscannedAllPlans" : 6092,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 125,
"nChunkSkips" : 0,
"millis" : 14221,
"indexBounds" : {
"primary_names.last_name" : [
[
"brimble",
"brimble"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","inclusive_names":{"$elemMatch":{"first_name":"john","last_name":"brimble"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 28,
"nscannedObjects" : 3056,
"nscanned" : 3056,
"nscannedObjectsAllPlans" : 9169,
"nscannedAllPlans" : 9169,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 899,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"brimble",
"brimble"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"fisher"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 351,
"nscannedObjects" : 1148,
"nscanned" : 1148,
"nscannedObjectsAllPlans" : 2048,
"nscannedAllPlans" : 2048,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 10,
"nChunkSkips" : 0,
"millis" : 10702,
"indexBounds" : {
"primary_names.last_name" : [
[
"fisher",
"fisher"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"SOM","inclusive_names":{"$elemMatch":{"first_name":"john","last_name":"brimble"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 178,
"nscannedObjects" : 3056,
"nscanned" : 3056,
"nscannedObjectsAllPlans" : 3056,
"nscannedAllPlans" : 3056,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 1935,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"brimble",
"brimble"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"SOM","inclusive_names":{"$elemMatch":{"first_name":"john","last_name":"brimble"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 36,
"nscannedObjects" : 3056,
"nscanned" : 3056,
"nscannedObjectsAllPlans" : 9169,
"nscannedAllPlans" : 9169,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 24,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"brimble",
"brimble"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"william","last_name":"harold"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 11,
"nscannedObjects" : 461,
"nscanned" : 461,
"nscannedObjectsAllPlans" : 1844,
"nscannedAllPlans" : 1844,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 11,
"nChunkSkips" : 0,
"millis" : 13119,
"indexBounds" : {
"primary_names.last_name" : [
[
"harold",
"harold"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_soundex":{"$elemMatch":{"first_name":"W450","last_name":"H643"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 48,
"nscannedObjects" : 4164,
"nscanned" : 4164,
"nscannedObjectsAllPlans" : 8328,
"nscannedAllPlans" : 8328,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 58,
"nChunkSkips" : 0,
"millis" : 56482,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"H643",
"H643"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_soundex":{"$elemMatch":{"first_name":"W450","last_name":"H643"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 48,
"nscannedObjects" : 4164,
"nscanned" : 4164,
"nscannedObjectsAllPlans" : 8328,
"nscannedAllPlans" : 8328,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 133,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"H643",
"H643"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","inclusive_soundex":{"$elemMatch":{"first_name":"G445","last_name":"H643"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_soundex.last_name_1_chapman_code_1_inclusive_soundex.first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 3491,
"nscanned" : 3491,
"nscannedObjectsAllPlans" : 10474,
"nscannedAllPlans" : 10474,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 42,
"nChunkSkips" : 0,
"millis" : 3418,
"indexBounds" : {
"inclusive_soundex.last_name" : [
[
"H643",
"H643"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"inclusive_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"daniel","last_name":"robertson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 46,
"nscannedObjects" : 14166,
"nscanned" : 14166,
"nscannedObjectsAllPlans" : 14166,
"nscannedAllPlans" : 14166,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 266,
"nChunkSkips" : 0,
"millis" : 175290,
"indexBounds" : {
"primary_names.last_name" : [
[
"robertson",
"robertson"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"first_name":"daniel","last_name":"robertson"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 46,
"nscannedObjects" : 14166,
"nscanned" : 14166,
"nscannedObjectsAllPlans" : 14166,
"nscannedAllPlans" : 14166,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 40,
"indexBounds" : {
"primary_names.last_name" : [
[
"robertson",
"robertson"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_soundex":{"$elemMatch":{"last_name":"H643"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 866,
"nscannedObjects" : 4164,
"nscanned" : 4164,
"nscannedObjectsAllPlans" : 4530,
"nscannedAllPlans" : 4530,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 30,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"H643",
"H643"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"NFK","primary_names":{"$elemMatch":{"last_name":"harold"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 70,
"nscannedObjects" : 461,
"nscanned" : 461,
"nscannedObjectsAllPlans" : 1844,
"nscannedAllPlans" : 1844,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 75,
"indexBounds" : {
"primary_names.last_name" : [
[
"harold",
"harold"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","primary_soundex":{"$elemMatch":{"last_name":"G650"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 36476,
"nscannedObjects" : 127845,
"nscanned" : 127845,
"nscannedObjectsAllPlans" : 128231,
"nscannedAllPlans" : 128231,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 5409,
"nChunkSkips" : 0,
"millis" : 1197103,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"G650",
"G650"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"fisher"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 261,
"nscannedObjects" : 1148,
"nscanned" : 1148,
"nscannedObjectsAllPlans" : 2153,
"nscannedAllPlans" : 2153,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 2309,
"indexBounds" : {
"primary_names.last_name" : [
[
"fisher",
"fisher"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 51,
"nChunkSkips" : 0,
"millis" : 20784,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 41,
"nscannedObjects" : 218,
"nscanned" : 218,
"nscannedObjectsAllPlans" : 872,
"nscannedAllPlans" : 872,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1240,
"indexBounds" : {
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"last_name":"wadley"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 435,
"nscannedObjects" : 435,
"nscanned" : 435,
"nscannedObjectsAllPlans" : 435,
"nscannedAllPlans" : 435,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 3,
"nChunkSkips" : 0,
"millis" : 3104,
"indexBounds" : {
"primary_names.last_name" : [
[
"wadley",
"wadley"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"GLS","primary_names":{"$elemMatch":{"first_name":"george","last_name":"phillips"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 560,
"nscanned" : 560,
"nscannedObjectsAllPlans" : 2240,
"nscannedAllPlans" : 2240,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 36553,
"indexBounds" : {
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"chapman_code" : [
[
"GLS",
"GLS"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","primary_names":{"$elemMatch":{"last_name":"roynon"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 132,
"nscannedObjects" : 424,
"nscanned" : 424,
"nscannedObjectsAllPlans" : 1400,
"nscannedAllPlans" : 1400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 1029,
"indexBounds" : {
"primary_names.last_name" : [
[
"roynon",
"roynon"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"last_name":"unwin"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2058,
"nscannedObjects" : 2058,
"nscanned" : 2058,
"nscannedObjectsAllPlans" : 2058,
"nscannedAllPlans" : 2058,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 24,
"nChunkSkips" : 0,
"millis" : 24243,
"indexBounds" : {
"primary_names.last_name" : [
[
"unwin",
"unwin"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"unwin"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 70,
"nscannedObjects" : 70,
"nscanned" : 70,
"nscannedObjectsAllPlans" : 70,
"nscannedAllPlans" : 70,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"unwin",
"unwin"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"batten"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 307,
"nscannedObjects" : 998,
"nscanned" : 998,
"nscannedObjectsAllPlans" : 1993,
"nscannedAllPlans" : 1993,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 17,
"nChunkSkips" : 0,
"millis" : 30057,
"indexBounds" : {
"primary_names.last_name" : [
[
"batten",
"batten"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"GLS","primary_names":{"$elemMatch":{"first_name":"john","last_name":"phillips"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 5,
"nscannedObjects" : 560,
"nscanned" : 560,
"nscannedObjectsAllPlans" : 2240,
"nscannedAllPlans" : 2240,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 11,
"indexBounds" : {
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"chapman_code" : [
[
"GLS",
"GLS"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"GLS","primary_names":{"$elemMatch":{"first_name":"susanna","last_name":"phillips"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 560,
"nscanned" : 560,
"nscannedObjectsAllPlans" : 2240,
"nscannedAllPlans" : 2240,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 11,
"indexBounds" : {
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"chapman_code" : [
[
"GLS",
"GLS"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"GLS","primary_names":{"$elemMatch":{"first_name":"susannah","last_name":"phillips"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 560,
"nscanned" : 560,
"nscannedObjectsAllPlans" : 2240,
"nscannedAllPlans" : 2240,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 11,
"indexBounds" : {
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"chapman_code" : [
[
"GLS",
"GLS"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"GLS","primary_names":{"$elemMatch":{"last_name":"overthrow"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 15,
"nscanned" : 15,
"nscannedObjectsAllPlans" : 60,
"nscannedAllPlans" : 60,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 270,
"indexBounds" : {
"primary_names.last_name" : [
[
"overthrow",
"overthrow"
]
],
"chapman_code" : [
[
"GLS",
"GLS"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"batten"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 425,
"nscannedObjects" : 998,
"nscanned" : 998,
"nscannedObjectsAllPlans" : 1696,
"nscannedAllPlans" : 1696,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 445,
"indexBounds" : {
"primary_names.last_name" : [
[
"batten",
"batten"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"ann","last_name":"parker"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 76,
"nscannedObjects" : 7233,
"nscanned" : 7233,
"nscannedObjectsAllPlans" : 28932,
"nscannedAllPlans" : 28932,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 595,
"nChunkSkips" : 0,
"millis" : 260074,
"indexBounds" : {
"primary_names.last_name" : [
[
"parker",
"parker"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"janet","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 9472,
"nscanned" : 9472,
"nscannedObjectsAllPlans" : 37888,
"nscannedAllPlans" : 37888,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 377,
"nChunkSkips" : 0,
"millis" : 298881,
"indexBounds" : {
"primary_names.last_name" : [
[
"king",
"king"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"janet parker","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 9472,
"nscanned" : 9472,
"nscannedObjectsAllPlans" : 37888,
"nscannedAllPlans" : 37888,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 419,
"indexBounds" : {
"primary_names.last_name" : [
[
"king",
"king"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"henry","last_name":"whitwood"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 81,
"nscanned" : 81,
"nscannedObjectsAllPlans" : 324,
"nscannedAllPlans" : 324,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2815,
"indexBounds" : {
"primary_names.last_name" : [
[
"whitwood",
"whitwood"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"joseph","last_name":"sellick"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 1080,
"nscanned" : 1080,
"nscannedObjectsAllPlans" : 4320,
"nscannedAllPlans" : 4320,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 15,
"nChunkSkips" : 0,
"millis" : 16567,
"indexBounds" : {
"primary_names.last_name" : [
[
"sellick",
"sellick"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"william","last_name":"moore"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 170,
"nscannedObjects" : 6786,
"nscanned" : 6786,
"nscannedObjectsAllPlans" : 18663,
"nscannedAllPlans" : 18663,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 581,
"nChunkSkips" : 0,
"millis" : 188926,
"indexBounds" : {
"primary_names.last_name" : [
[
"moore",
"moore"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"charity","last_name":"gillott"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 14,
"nscanned" : 14,
"nscannedObjectsAllPlans" : 56,
"nscannedAllPlans" : 56,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 502,
"indexBounds" : {
"primary_names.last_name" : [
[
"gillott",
"gillott"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"james","last_name":"massingham"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 91,
"nscannedObjects" : 2410,
"nscanned" : 2410,
"nscannedObjectsAllPlans" : 2410,
"nscannedAllPlans" : 2410,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 23,
"nChunkSkips" : 0,
"millis" : 24601,
"indexBounds" : {
"primary_names.last_name" : [
[
"massingham",
"massingham"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"STS","primary_names":{"$elemMatch":{"last_name":"smith"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 32523,
"nscannedObjects" : 32523,
"nscanned" : 32523,
"nscannedObjectsAllPlans" : 32523,
"nscannedAllPlans" : 32523,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 213,
"nChunkSkips" : 0,
"millis" : 97925,
"indexBounds" : {
"primary_names.last_name" : [
[
"smith",
"smith"
]
],
"chapman_code" : [
[
"STS",
"STS"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"primary_names":{"$elemMatch":{"last_name":"caroline"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 51,
"nscannedObjects" : 51,
"nscanned" : 51,
"nscannedObjectsAllPlans" : 51,
"nscannedAllPlans" : 51,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1052,
"indexBounds" : {
"primary_names.last_name" : [
[
"caroline",
"caroline"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"mary","last_name":"leeds"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 41,
"nscannedObjects" : 1317,
"nscanned" : 1317,
"nscannedObjectsAllPlans" : 5268,
"nscannedAllPlans" : 5268,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 30,
"nChunkSkips" : 0,
"millis" : 41109,
"indexBounds" : {
"primary_names.last_name" : [
[
"leeds",
"leeds"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"james woolmer massingham"}}} ).explain();
{
"cursor" : "BasicCursor",
"isMultiKey" : false,
"n" : 1,
"nscannedObjects" : 24020988,
"nscanned" : 24020988,
"nscannedObjectsAllPlans" : 24020988,
"nscannedAllPlans" : 24020988,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1996,
"nChunkSkips" : 0,
"millis" : 1024407,
"indexBounds" : {
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"elsie may","last_name":"peters"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 846,
"nscanned" : 846,
"nscannedObjectsAllPlans" : 3384,
"nscannedAllPlans" : 3384,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 428,
"nChunkSkips" : 0,
"millis" : 52400,
"indexBounds" : {
"primary_names.last_name" : [
[
"peters",
"peters"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"*ner"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 4,
"nscanned" : 4,
"nscannedObjectsAllPlans" : 16,
"nscannedAllPlans" : 16,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 298,
"indexBounds" : {
"primary_names.last_name" : [
[
"*ner",
"*ner"
]
],
"chapman_code" : [
[
"SOM",
"SOM"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"betty"}}} ).explain();
{
"cursor" : "BasicCursor",
"isMultiKey" : false,
"n" : 7670,
"nscannedObjects" : 24020988,
"nscanned" : 24020988,
"nscannedObjectsAllPlans" : 24020988,
"nscannedAllPlans" : 24020988,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2600,
"nChunkSkips" : 0,
"millis" : 793599,
"indexBounds" : {
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","primary_names":{"$elemMatch":{"first_name":"frederick","last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 5,
"nscannedObjects" : 2926,
"nscanned" : 2926,
"nscannedObjectsAllPlans" : 11704,
"nscannedAllPlans" : 11704,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 299,
"nChunkSkips" : 0,
"millis" : 66823,
"indexBounds" : {
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"chapman_code" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"frederick","last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 2187,
"nscanned" : 2187,
"nscannedObjectsAllPlans" : 8748,
"nscannedAllPlans" : 8748,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 128,
"indexBounds" : {
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"frederick","last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 2187,
"nscanned" : 2187,
"nscannedObjectsAllPlans" : 8748,
"nscannedAllPlans" : 8748,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 152,
"indexBounds" : {
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1155,
"nscannedObjects" : 2202,
"nscanned" : 2202,
"nscannedObjectsAllPlans" : 2804,
"nscannedAllPlans" : 2804,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 179,
"indexBounds" : {
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"primary_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"WRY","primary_soundex":{"$elemMatch":{"last_name":"A165"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 8,
"nscannedObjects" : 8009,
"nscanned" : 8009,
"nscannedObjectsAllPlans" : 16018,
"nscannedAllPlans" : 16018,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 233,
"nChunkSkips" : 0,
"millis" : 114292,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"A165",
"A165"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_soundex":{"$elemMatch":{"first_name":"J500","last_name":"A165"}}} ).explain();
{
"cursor" : "BtreeCursor primary_soundex.last_name_1_primary_soundex.first_name_1",
"isMultiKey" : true,
"n" : 3,
"nscannedObjects" : 8009,
"nscanned" : 8009,
"nscannedObjectsAllPlans" : 16018,
"nscannedAllPlans" : 16018,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 6,
"nChunkSkips" : 0,
"millis" : 558,
"indexBounds" : {
"primary_soundex.last_name" : [
[
"A165",
"A165"
]
],
"primary_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"samuel","last_name":"day"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 767,
"nscanned" : 767,
"nscannedObjectsAllPlans" : 3068,
"nscannedAllPlans" : 3068,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 20,
"nChunkSkips" : 0,
"millis" : 21467,
"indexBounds" : {
"primary_names.last_name" : [
[
"day",
"day"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"martha","last_name":"day"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 15,
"nscannedObjects" : 767,
"nscanned" : 767,
"nscannedObjectsAllPlans" : 3068,
"nscannedAllPlans" : 3068,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 160,
"indexBounds" : {
"primary_names.last_name" : [
[
"day",
"day"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"samuel","last_name":"h*"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 4,
"nscanned" : 4,
"nscannedObjectsAllPlans" : 16,
"nscannedAllPlans" : 16,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 263,
"indexBounds" : {
"primary_names.last_name" : [
[
"h*",
"h*"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"DEV","inclusive_names":{"$elemMatch":{"first_name":"robert","last_name":"saffold"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_names.last_name_1_chapman_code_1_inclusive_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 0,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"inclusive_names.last_name" : [
[
"saffold",
"saffold"
]
],
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"inclusive_names.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"chapman_code":"DEV","inclusive_soundex":{"$elemMatch":{"first_name":"R163","last_name":"S143"}}} ).explain();
{
"cursor" : "BtreeCursor inclusive_soundex.last_name_1_chapman_code_1_inclusive_soundex.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 20,
"nscanned" : 20,
"nscannedObjectsAllPlans" : 20,
"nscannedAllPlans" : 20,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 181,
"indexBounds" : {
"inclusive_soundex.last_name" : [
[
"S143",
"S143"
]
],
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"inclusive_soundex.first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"first_name":"samuel","last_name":"h*"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 4,
"nscanned" : 4,
"nscannedObjectsAllPlans" : 16,
"nscannedAllPlans" : 16,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"primary_names.last_name" : [
[
"h*",
"h*"
]
],
"chapman_code" : [
[
"WRY",
"WRY"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 28,
"nscannedObjects" : 1278,
"nscanned" : 1278,
"nscannedObjectsAllPlans" : 5112,
"nscannedAllPlans" : 5112,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 29,
"nChunkSkips" : 0,
"millis" : 32319,
"indexBounds" : {
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"chapman_code" : [
[
"LIN",
"LIN"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"first_name":"henry","last_name":"nobbs"}}} ).explain();
{
"cursor" : "BtreeCursor primary_names.last_name_1_chapman_code_1",
"isMultiKey" : true,
"n" : 17,
"nscannedObjects" : 3634,
"nscanned" : 3634,
"nscannedObjectsAllPlans" : 14536,
"nscannedAllPlans" : 14536,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 743,
"nChunkSkips" : 0,
"millis" : 47453,
"indexBounds" : {
"primary_names.last_name" : [
[
"nobbs",
"nobbs"
]
],
"chapman_code" : [
[
"NFK",
"NFK"
]
]
},
"server" : "anitaborg:27017"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment