Skip to content

Instantly share code, notes, and snippets.

@benwbrum

benwbrum/test1_query_explain_plan_results_new_indexes.js

Last active December 17, 2015 21:09
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save benwbrum/5672697 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test1_query_explain_plan_results_new_indexes.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" : 5,
"nChunkSkips" : 0,
"millis" : 5556,
"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" : 1,
"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" : 0,
"nChunkSkips" : 0,
"millis" : 192,
"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" : 10734,
"nChunkSkips" : 0,
"millis" : 4580996,
"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" : 34,
"nChunkSkips" : 0,
"millis" : 32173,
"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" : 4576,
"indexBounds" : {
"primary_names.last_name" : [
[
"brumfield",
"brumfield"
]
],
"primary_names.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();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 12,
"nscannedObjects" : 45,
"nscanned" : 45,
"nscannedObjectsAllPlans" : 365,
"nscannedAllPlans" : 365,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 8,
"nChunkSkips" : 0,
"millis" : 3569,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"inclusive_soundex.last_name" : [
[
"F624",
"F624"
]
],
"inclusive_soundex:first_name" : [
[
{
"$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" : 1,
"nChunkSkips" : 0,
"millis" : 926,
"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" : 2,
"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" : 600,
"nChunkSkips" : 0,
"millis" : 178380,
"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" : 27,
"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" : 312,
"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" : 1,
"nChunkSkips" : 0,
"millis" : 1004,
"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" : 78,
"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" : 79,
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 8,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 244,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.first_name" : [
[
"brimble",
"brimble"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 25,
"nscannedObjects" : 461,
"nscanned" : 461,
"nscannedObjectsAllPlans" : 4153,
"nscannedAllPlans" : 4153,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 43,
"nChunkSkips" : 0,
"millis" : 20195,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"brimble",
"brimble"
]
],
"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" : 35,
"nscannedObjects" : 32400,
"nscanned" : 32400,
"nscannedObjectsAllPlans" : 32400,
"nscannedAllPlans" : 32400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 75,
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 84,
"nscannedObjects" : 878,
"nscanned" : 878,
"nscannedObjectsAllPlans" : 6149,
"nscannedAllPlans" : 6149,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 38,
"nChunkSkips" : 0,
"millis" : 42033,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 423,
"nscanned" : 423,
"nscannedObjectsAllPlans" : 3810,
"nscannedAllPlans" : 3810,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 55,
"nChunkSkips" : 0,
"millis" : 9146,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"wm.",
"wm."
]
]
},
"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 chapman_code_1_record_type_1_inclusive_names.last_name_1_inclusive_names:first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 1690,
"nscanned" : 1690,
"nscannedObjectsAllPlans" : 13526,
"nscannedAllPlans" : 13526,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 27,
"nChunkSkips" : 0,
"millis" : 32703,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"inclusive_names.last_name" : [
[
"dawson",
"dawson"
]
],
"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" : "BtreeCursor chapman_code_1_record_type_1_primary_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" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"snell",
"snell"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LIN","primary_names":{"$elemMatch":{"first_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_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" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"snell",
"snell"
]
]
},
"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" : 7,
"nChunkSkips" : 0,
"millis" : 7138,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 330,
"nscannedObjects" : 330,
"nscanned" : 330,
"nscannedObjectsAllPlans" : 330,
"nscannedAllPlans" : 330,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 430,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"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" : 35,
"nscannedObjects" : 32400,
"nscanned" : 32400,
"nscannedObjectsAllPlans" : 32400,
"nscannedAllPlans" : 32400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 79,
"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" : 29,
"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();
{
"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" : 112,
"nChunkSkips" : 0,
"millis" : 31377,
"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();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 453,
"nscanned" : 453,
"nscannedObjectsAllPlans" : 4081,
"nscannedAllPlans" : 4081,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 22,
"nChunkSkips" : 0,
"millis" : 22910,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_inclusive_names.last_name_1_inclusive_names:first_name_1",
"isMultiKey" : true,
"n" : 37,
"nscannedObjects" : 463,
"nscanned" : 463,
"nscannedObjectsAllPlans" : 3710,
"nscannedAllPlans" : 3710,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2222,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"inclusive_names.last_name" : [
[
"snell",
"snell"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 28,
"nscannedObjects" : 453,
"nscanned" : 453,
"nscannedObjectsAllPlans" : 4081,
"nscannedAllPlans" : 4081,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 566,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 28,
"nscannedObjects" : 495,
"nscanned" : 495,
"nscannedObjectsAllPlans" : 4459,
"nscannedAllPlans" : 4459,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 12047,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 330,
"nscanned" : 330,
"nscannedObjectsAllPlans" : 2974,
"nscannedAllPlans" : 2974,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1141,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"primary_names:first_name" : [
[
{
"$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" : 4,
"nChunkSkips" : 0,
"millis" : 4360,
"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" : 0,
"nChunkSkips" : 0,
"millis" : 29,
"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" : 22,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 67,
"nscannedObjects" : 67,
"nscanned" : 67,
"nscannedObjectsAllPlans" : 67,
"nscannedAllPlans" : 67,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 432,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"fairchild",
"fairchild"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"DEV","primary_soundex":{"$elemMatch":{"last_name":"F624"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 101,
"nscannedObjects" : 101,
"nscanned" : 101,
"nscannedObjectsAllPlans" : 101,
"nscannedAllPlans" : 101,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 214,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 26,
"nscannedObjects" : 26,
"nscanned" : 26,
"nscannedObjectsAllPlans" : 26,
"nscannedAllPlans" : 26,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 232,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 12,
"nscannedObjects" : 45,
"nscanned" : 45,
"nscannedObjectsAllPlans" : 365,
"nscannedAllPlans" : 365,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 2,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"inclusive_soundex.last_name" : [
[
"F624",
"F624"
]
],
"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();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 3,
"nscannedObjects" : 26,
"nscanned" : 26,
"nscannedObjectsAllPlans" : 213,
"nscannedAllPlans" : 213,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 615,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"inclusive_soundex.last_name" : [
[
"F624",
"F624"
]
],
"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 chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 48,
"nscannedObjects" : 101,
"nscanned" : 101,
"nscannedObjectsAllPlans" : 813,
"nscannedAllPlans" : 813,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2871,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"inclusive_soundex.last_name" : [
[
"F624",
"F624"
]
],
"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();
db.search_records.find( {"record_type":"ba","primary_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 19,
"nscannedObjects" : 119,
"nscanned" : 119,
"nscannedObjectsAllPlans" : 836,
"nscannedAllPlans" : 836,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 6,
"nChunkSkips" : 0,
"millis" : 9068,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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 chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 20,
"nscannedObjects" : 119,
"nscanned" : 119,
"nscannedObjectsAllPlans" : 957,
"nscannedAllPlans" : 957,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1195,
"indexBounds" : {
"chapman_code" : [
[
"DEV",
"DEV"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"inclusive_soundex.last_name" : [
[
"D553",
"D553"
]
],
"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();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 36,
"nscannedObjects" : 36,
"nscanned" : 36,
"nscannedObjectsAllPlans" : 36,
"nscannedAllPlans" : 36,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 360,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"greenfield",
"greenfield"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"smith"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 3560,
"nscannedObjects" : 3560,
"nscanned" : 3560,
"nscannedObjectsAllPlans" : 3560,
"nscannedAllPlans" : 3560,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 8,
"nChunkSkips" : 0,
"millis" : 8641,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"smith",
"smith"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 29,
"nscanned" : 29,
"nscannedObjectsAllPlans" : 265,
"nscannedAllPlans" : 265,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 1645,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"towlson",
"towlson"
]
],
"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":"abraham","last_name":"hemingway"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 793,
"nscanned" : 793,
"nscannedObjectsAllPlans" : 7141,
"nscannedAllPlans" : 7141,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 34,
"nChunkSkips" : 0,
"millis" : 27385,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hemingway",
"hemingway"
]
],
"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":"charles","last_name":"hemingway"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 6,
"nscannedObjects" : 793,
"nscanned" : 793,
"nscannedObjectsAllPlans" : 7141,
"nscannedAllPlans" : 7141,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 6439,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hemingway",
"hemingway"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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" : 100,
"nChunkSkips" : 0,
"millis" : 53642,
"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" : 2765,
"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" : 57,
"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" : 48,
"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" : 5,
"nChunkSkips" : 0,
"millis" : 5490,
"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();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names.last_name_1_inclusive_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 157,
"nscanned" : 157,
"nscannedObjectsAllPlans" : 1262,
"nscannedAllPlans" : 1262,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 9,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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":"LIN","inclusive_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names.last_name_1_inclusive_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 332,
"nscanned" : 332,
"nscannedObjectsAllPlans" : 2662,
"nscannedAllPlans" : 2662,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 325,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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":"LIN","primary_names":{"$elemMatch":{"first_name":"john ","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 8,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"john ",
"john "
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 8,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"john titus ",
"john titus "
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 8,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"john titus ",
"john titus "
]
]
},
"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" : 51,
"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" : 38,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 41,
"nscannedObjects" : 41,
"nscanned" : 41,
"nscannedObjectsAllPlans" : 41,
"nscannedAllPlans" : 41,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 362,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 11,
"nscannedObjects" : 154,
"nscanned" : 154,
"nscannedObjectsAllPlans" : 1390,
"nscannedAllPlans" : 1390,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 235,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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":"CAM","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 7,
"nscanned" : 7,
"nscannedObjectsAllPlans" : 67,
"nscannedAllPlans" : 67,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 193,
"indexBounds" : {
"chapman_code" : [
[
"CAM",
"CAM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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":"CAM","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 7,
"nscanned" : 7,
"nscannedObjectsAllPlans" : 67,
"nscannedAllPlans" : 67,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"CAM",
"CAM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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":"SFK","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 18,
"nscanned" : 18,
"nscannedObjectsAllPlans" : 166,
"nscannedAllPlans" : 166,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 454,
"indexBounds" : {
"chapman_code" : [
[
"SFK",
"SFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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":"LIN","primary_names":{"$elemMatch":{"first_name":"john","last_name":"snell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 330,
"nscanned" : 330,
"nscannedObjectsAllPlans" : 2974,
"nscannedAllPlans" : 2974,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 19,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"snell",
"snell"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"dashword"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_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" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"dashword",
"dashword"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","inclusive_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names.last_name_1_inclusive_names:first_name_1",
"isMultiKey" : true,
"n" : 105,
"nscannedObjects" : 105,
"nscanned" : 105,
"nscannedObjectsAllPlans" : 105,
"nscannedAllPlans" : 105,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 706,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"inclusive_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 72,
"nscannedObjects" : 72,
"nscanned" : 72,
"nscannedObjectsAllPlans" : 72,
"nscannedAllPlans" : 72,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 481,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 84,
"nscannedObjects" : 878,
"nscanned" : 878,
"nscannedObjectsAllPlans" : 6149,
"nscannedAllPlans" : 6149,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 27,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 21,
"nscannedObjects" : 21,
"nscanned" : 21,
"nscannedObjectsAllPlans" : 21,
"nscannedAllPlans" : 21,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 233,
"indexBounds" : {
"chapman_code" : [
[
"DOR",
"DOR"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 4,
"nscanned" : 4,
"nscannedObjectsAllPlans" : 39,
"nscannedAllPlans" : 39,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 35,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"john *",
"john *"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 4,
"nscanned" : 4,
"nscannedObjectsAllPlans" : 39,
"nscannedAllPlans" : 39,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 55,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"john ?",
"john ?"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 2,
"nscanned" : 2,
"nscannedObjectsAllPlans" : 21,
"nscannedAllPlans" : 21,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 14,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"john t",
"john t"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"NTH","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_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" : {
"chapman_code" : [
[
"NTH",
"NTH"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"OXF","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_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" : {
"chapman_code" : [
[
"OXF",
"OXF"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"LEI","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 1,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 20,
"indexBounds" : {
"chapman_code" : [
[
"LEI",
"LEI"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SAL","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_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" : {
"chapman_code" : [
[
"SAL",
"SAL"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"BDF","primary_names":{"$elemMatch":{"last_name":"dashwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_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" : {
"chapman_code" : [
[
"BDF",
"BDF"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"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":"joan","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 4362,
"nscanned" : 4362,
"nscannedObjectsAllPlans" : 39262,
"nscannedAllPlans" : 39262,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 943,
"nChunkSkips" : 0,
"millis" : 295260,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"king",
"king"
]
],
"primary_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":"claxon"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 15,
"nscannedObjects" : 300,
"nscanned" : 300,
"nscannedObjectsAllPlans" : 2704,
"nscannedAllPlans" : 2704,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 13,
"nChunkSkips" : 0,
"millis" : 13115,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"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":"joan emma","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"joan emma",
"joan emma"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 33,
"nscannedObjects" : 4362,
"nscanned" : 4362,
"nscannedObjectsAllPlans" : 39262,
"nscannedAllPlans" : 39262,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 72,
"nChunkSkips" : 0,
"millis" : 25011,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"king",
"king"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 12,
"nscannedObjects" : 157,
"nscanned" : 157,
"nscannedObjectsAllPlans" : 1417,
"nscannedAllPlans" : 1417,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1236,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 8,
"nscannedObjects" : 138,
"nscanned" : 138,
"nscannedObjectsAllPlans" : 1246,
"nscannedAllPlans" : 1246,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 771,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 1474,
"nscannedObjects" : 4950,
"nscanned" : 4950,
"nscannedObjectsAllPlans" : 7622,
"nscannedAllPlans" : 7622,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 5,
"nChunkSkips" : 0,
"millis" : 5542,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"inclusive_soundex.last_name" : [
[
"K520",
"K520"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 237,
"nscannedObjects" : 237,
"nscanned" : 237,
"nscannedObjectsAllPlans" : 237,
"nscannedAllPlans" : 237,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 867,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 94,
"nscannedObjects" : 94,
"nscanned" : 94,
"nscannedObjectsAllPlans" : 94,
"nscannedAllPlans" : 94,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 1,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"booker",
"booker"
]
],
"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":"joan","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 4362,
"nscanned" : 4362,
"nscannedObjectsAllPlans" : 39262,
"nscannedAllPlans" : 39262,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 123,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"king",
"king"
]
],
"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":"adeline doris","last_name":"satchell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 185,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"adeline doris",
"adeline doris"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 98,
"nscanned" : 98,
"nscannedObjectsAllPlans" : 885,
"nscannedAllPlans" : 885,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 4694,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"johannis",
"johannis"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 201,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"norman douglas",
"norman douglas"
]
]
},
"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" : 4,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 83,
"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" : 4,
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 411,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"nora matilda",
"nora matilda"
]
]
},
"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" : 9,
"nscannedAllPlans" : 9,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 21,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 44,
"nscanned" : 44,
"nscannedObjectsAllPlans" : 400,
"nscannedAllPlans" : 400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1787,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hammett",
"hammett"
]
],
"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":"henry wilcox","last_name":"down"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 2,
"nscanned" : 2,
"nscannedObjectsAllPlans" : 21,
"nscannedAllPlans" : 21,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 544,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"henry wilcox",
"henry wilcox"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 11,
"nscanned" : 11,
"nscannedObjectsAllPlans" : 103,
"nscannedAllPlans" : 103,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 533,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"wallbutton",
"wallbutton"
]
],
"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":"robert","last_name":"wallbutton"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 11,
"nscanned" : 11,
"nscannedObjectsAllPlans" : 103,
"nscannedAllPlans" : 103,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 1,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"wallbutton",
"wallbutton"
]
],
"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":"thomas","last_name":"roynon"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 76,
"nscanned" : 76,
"nscannedObjectsAllPlans" : 688,
"nscannedAllPlans" : 688,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 1829,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"roynon",
"roynon"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"greenwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 792,
"nscannedObjects" : 792,
"nscanned" : 792,
"nscannedObjectsAllPlans" : 792,
"nscannedAllPlans" : 792,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2828,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"greenwood",
"greenwood"
]
],
"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":"joan","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 4362,
"nscanned" : 4362,
"nscannedObjectsAllPlans" : 39262,
"nscannedAllPlans" : 39262,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 943,
"nChunkSkips" : 0,
"millis" : 295260,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"king",
"king"
]
],
"primary_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":"claxon"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 15,
"nscannedObjects" : 300,
"nscanned" : 300,
"nscannedObjectsAllPlans" : 2704,
"nscannedAllPlans" : 2704,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 13,
"nChunkSkips" : 0,
"millis" : 13115,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"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":"joan emma","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"joan emma",
"joan emma"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 33,
"nscannedObjects" : 4362,
"nscanned" : 4362,
"nscannedObjectsAllPlans" : 39262,
"nscannedAllPlans" : 39262,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 72,
"nChunkSkips" : 0,
"millis" : 25011,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"king",
"king"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 12,
"nscannedObjects" : 157,
"nscanned" : 157,
"nscannedObjectsAllPlans" : 1417,
"nscannedAllPlans" : 1417,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1236,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 8,
"nscannedObjects" : 138,
"nscanned" : 138,
"nscannedObjectsAllPlans" : 1246,
"nscannedAllPlans" : 1246,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 771,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"claxon",
"claxon"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 1474,
"nscannedObjects" : 4950,
"nscanned" : 4950,
"nscannedObjectsAllPlans" : 7622,
"nscannedAllPlans" : 7622,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 5,
"nChunkSkips" : 0,
"millis" : 5542,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"inclusive_soundex.last_name" : [
[
"K520",
"K520"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 237,
"nscannedObjects" : 237,
"nscanned" : 237,
"nscannedObjectsAllPlans" : 237,
"nscannedAllPlans" : 237,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 867,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 94,
"nscannedObjects" : 94,
"nscanned" : 94,
"nscannedObjectsAllPlans" : 94,
"nscannedAllPlans" : 94,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 1,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"booker",
"booker"
]
],
"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":"joan","last_name":"king"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 4362,
"nscanned" : 4362,
"nscannedObjectsAllPlans" : 39262,
"nscannedAllPlans" : 39262,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 123,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"king",
"king"
]
],
"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":"adeline doris","last_name":"satchell"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 185,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"adeline doris",
"adeline doris"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 98,
"nscanned" : 98,
"nscannedObjectsAllPlans" : 885,
"nscannedAllPlans" : 885,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 4694,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"johannis",
"johannis"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 201,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"norman douglas",
"norman douglas"
]
]
},
"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" : 4,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 83,
"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" : 4,
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 411,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"nora matilda",
"nora matilda"
]
]
},
"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" : 9,
"nscannedAllPlans" : 9,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 21,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 44,
"nscanned" : 44,
"nscannedObjectsAllPlans" : 400,
"nscannedAllPlans" : 400,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1787,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hammett",
"hammett"
]
],
"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":"henry wilcox","last_name":"down"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 2,
"nscanned" : 2,
"nscannedObjectsAllPlans" : 21,
"nscannedAllPlans" : 21,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 544,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"henry wilcox",
"henry wilcox"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 11,
"nscanned" : 11,
"nscannedObjectsAllPlans" : 103,
"nscannedAllPlans" : 103,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 533,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"wallbutton",
"wallbutton"
]
],
"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":"robert","last_name":"wallbutton"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 11,
"nscanned" : 11,
"nscannedObjectsAllPlans" : 103,
"nscannedAllPlans" : 103,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 1,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"wallbutton",
"wallbutton"
]
],
"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":"thomas","last_name":"roynon"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 76,
"nscanned" : 76,
"nscannedObjectsAllPlans" : 688,
"nscannedAllPlans" : 688,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 1829,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"roynon",
"roynon"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"WRY","primary_names":{"$elemMatch":{"last_name":"greenwood"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 792,
"nscannedObjects" : 792,
"nscanned" : 792,
"nscannedObjectsAllPlans" : 792,
"nscannedAllPlans" : 792,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2828,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"greenwood",
"greenwood"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 22,
"nscannedObjects" : 296,
"nscanned" : 296,
"nscannedObjectsAllPlans" : 2668,
"nscannedAllPlans" : 2668,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2123,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"brimble",
"brimble"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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 chapman_code_1_record_type_1_inclusive_names.last_name_1_inclusive_names:first_name_1",
"isMultiKey" : true,
"n" : 28,
"nscannedObjects" : 304,
"nscanned" : 304,
"nscannedObjectsAllPlans" : 2438,
"nscannedAllPlans" : 2438,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 300,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"inclusive_names.last_name" : [
[
"brimble",
"brimble"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 351,
"nscannedObjects" : 351,
"nscanned" : 351,
"nscannedObjectsAllPlans" : 351,
"nscannedAllPlans" : 351,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 764,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"fisher",
"fisher"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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" : 0,
"nChunkSkips" : 0,
"millis" : 19,
"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 chapman_code_1_record_type_1_inclusive_names.last_name_1_inclusive_names:first_name_1",
"isMultiKey" : true,
"n" : 36,
"nscannedObjects" : 461,
"nscanned" : 461,
"nscannedObjectsAllPlans" : 3694,
"nscannedAllPlans" : 3694,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 76,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"inclusive_names.last_name" : [
[
"brimble",
"brimble"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 11,
"nscannedObjects" : 267,
"nscanned" : 267,
"nscannedObjectsAllPlans" : 2407,
"nscannedAllPlans" : 2407,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 6,
"nChunkSkips" : 0,
"millis" : 7152,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"harold",
"harold"
]
],
"primary_names: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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 48,
"nscannedObjects" : 866,
"nscanned" : 866,
"nscannedObjectsAllPlans" : 6065,
"nscannedAllPlans" : 6065,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 30,
"nChunkSkips" : 0,
"millis" : 30238,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 48,
"nscannedObjects" : 866,
"nscanned" : 866,
"nscannedObjectsAllPlans" : 6065,
"nscannedAllPlans" : 6065,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 26,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_inclusive_soundex.last_name_1_inclusive_soundex:first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 940,
"nscanned" : 940,
"nscannedObjectsAllPlans" : 7525,
"nscannedAllPlans" : 7525,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 5,
"nChunkSkips" : 0,
"millis" : 7001,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"inclusive_soundex.last_name" : [
[
"H643",
"H643"
]
],
"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" : 134,
"nChunkSkips" : 0,
"millis" : 146244,
"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" : 70,
"nChunkSkips" : 0,
"millis" : 41,
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 866,
"nscannedObjects" : 866,
"nscanned" : 866,
"nscannedObjectsAllPlans" : 866,
"nscannedAllPlans" : 866,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 2,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 70,
"nscannedObjects" : 70,
"nscanned" : 70,
"nscannedObjectsAllPlans" : 70,
"nscannedAllPlans" : 70,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 219,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"harold",
"harold"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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" : 4214,
"nChunkSkips" : 0,
"millis" : 1115890,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 261,
"nscannedObjects" : 261,
"nscanned" : 261,
"nscannedObjectsAllPlans" : 261,
"nscannedAllPlans" : 261,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1106,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"fisher",
"fisher"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 24,
"nscannedObjects" : 330,
"nscanned" : 330,
"nscannedObjectsAllPlans" : 2974,
"nscannedAllPlans" : 2974,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 3,
"nChunkSkips" : 0,
"millis" : 3379,
"indexBounds" : {
"chapman_code" : [
[
"LIN",
"LIN"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 41,
"nscannedObjects" : 41,
"nscanned" : 41,
"nscannedObjectsAllPlans" : 41,
"nscannedAllPlans" : 41,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 23,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"dashwood",
"dashwood"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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" : 3370,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 60,
"nscanned" : 60,
"nscannedObjectsAllPlans" : 544,
"nscannedAllPlans" : 544,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 4397,
"indexBounds" : {
"chapman_code" : [
[
"GLS",
"GLS"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","primary_names":{"$elemMatch":{"last_name":"roynon"}}} ).explain();
s
{
"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" : 2,
"nChunkSkips" : 0,
"millis" : 2193,
"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();
t
{
"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" : 13,
"nChunkSkips" : 0,
"millis" : 14353,
"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();
n
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 307,
"nscannedObjects" : 307,
"nscanned" : 307,
"nscannedObjectsAllPlans" : 307,
"nscannedAllPlans" : 307,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 1674,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"batten",
"batten"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 5,
"nscannedObjects" : 60,
"nscanned" : 60,
"nscannedObjectsAllPlans" : 544,
"nscannedAllPlans" : 544,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 208,
"indexBounds" : {
"chapman_code" : [
[
"GLS",
"GLS"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"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":"susanna","last_name":"phillips"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 60,
"nscanned" : 60,
"nscannedObjectsAllPlans" : 544,
"nscannedAllPlans" : 544,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 373,
"indexBounds" : {
"chapman_code" : [
[
"GLS",
"GLS"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"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":"susannah","last_name":"phillips"}}} ).explain();
i
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 60,
"nscanned" : 60,
"nscannedObjectsAllPlans" : 544,
"nscannedAllPlans" : 544,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1062,
"indexBounds" : {
"chapman_code" : [
[
"GLS",
"GLS"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"phillips",
"phillips"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"bu","chapman_code":"GLS","primary_names":{"$elemMatch":{"last_name":"overthrow"}}} ).explain();
"
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 1,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 10,
"indexBounds" : {
"chapman_code" : [
[
"GLS",
"GLS"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.last_name" : [
[
"overthrow",
"overthrow"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"batten"}}} ).explain();
h
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 425,
"nscannedObjects" : 425,
"nscanned" : 425,
"nscannedObjectsAllPlans" : 425,
"nscannedAllPlans" : 425,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 2373,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"batten",
"batten"
]
],
"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();
l
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 76,
"nscannedObjects" : 3253,
"nscanned" : 3253,
"nscannedObjectsAllPlans" : 29281,
"nscannedAllPlans" : 29281,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 447,
"nChunkSkips" : 0,
"millis" : 169009,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"parker",
"parker"
]
],
"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":"janet","last_name":"king"}}} ).explain();
i
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 45,
"nscanned" : 45,
"nscannedObjectsAllPlans" : 408,
"nscannedAllPlans" : 408,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 2,
"nChunkSkips" : 0,
"millis" : 1551,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"janet",
"janet"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"janet parker","last_name":"king"}}} ).explain();
n
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 12,
"nscannedAllPlans" : 12,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"janet parker",
"janet parker"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 21,
"nscanned" : 21,
"nscannedObjectsAllPlans" : 193,
"nscannedAllPlans" : 193,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1135,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"whitwood",
"whitwood"
]
],
"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":"joseph","last_name":"sellick"}}} ).explain();
d
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 2,
"nscannedObjects" : 262,
"nscanned" : 262,
"nscannedObjectsAllPlans" : 2362,
"nscannedAllPlans" : 2362,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 11,
"nChunkSkips" : 0,
"millis" : 12400,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"sellick",
"sellick"
]
],
"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":"william","last_name":"moore"}}} ).explain();
d
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 170,
"nscannedObjects" : 2932,
"nscanned" : 2932,
"nscannedObjectsAllPlans" : 17008,
"nscannedAllPlans" : 17008,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 84,
"nChunkSkips" : 0,
"millis" : 98260,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"moore",
"moore"
]
],
"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":"charity","last_name":"gillott"}}} ).explain();
s{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 10,
"nscanned" : 10,
"nscannedObjectsAllPlans" : 94,
"nscannedAllPlans" : 94,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 683,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"gillott",
"gillott"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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" : 18,
"nChunkSkips" : 0,
"millis" : 29156,
"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" : 578,
"nChunkSkips" : 0,
"millis" : 74746,
"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" : 0,
"nChunkSkips" : 0,
"millis" : 663,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 41,
"nscannedObjects" : 605,
"nscanned" : 605,
"nscannedObjectsAllPlans" : 5449,
"nscannedAllPlans" : 5449,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 34,
"nChunkSkips" : 0,
"millis" : 28003,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"leeds",
"leeds"
]
],
"primary_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":"james woolmer massingham"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 1,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"james woolmer massingham",
"james woolmer massingham"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 25,
"nscanned" : 25,
"nscannedObjectsAllPlans" : 228,
"nscannedAllPlans" : 228,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 2067,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.first_name" : [
[
"elsie may",
"elsie may"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"*ner"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 1,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 12,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"*ner",
"*ner"
]
],
"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":"betty"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 7670,
"nscannedObjects" : 7670,
"nscanned" : 7670,
"nscannedObjectsAllPlans" : 7670,
"nscannedAllPlans" : 7670,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 15,
"nChunkSkips" : 0,
"millis" : 16230,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"betty",
"betty"
]
]
},
"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" : 310,
"nChunkSkips" : 0,
"millis" : 41689,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 1155,
"nscanned" : 1155,
"nscannedObjectsAllPlans" : 10399,
"nscannedAllPlans" : 10399,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 13,
"nChunkSkips" : 0,
"millis" : 16141,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"primary_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":"frederick","last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 1155,
"nscanned" : 1155,
"nscannedObjectsAllPlans" : 10399,
"nscannedAllPlans" : 10399,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 46,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1155,
"nscannedObjects" : 1155,
"nscanned" : 1155,
"nscannedObjectsAllPlans" : 1155,
"nscannedAllPlans" : 1155,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 161,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 8,
"nscannedObjects" : 8,
"nscanned" : 8,
"nscannedObjectsAllPlans" : 8,
"nscannedAllPlans" : 8,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 69,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 3,
"nscannedObjects" : 12,
"nscanned" : 12,
"nscannedObjectsAllPlans" : 87,
"nscannedAllPlans" : 87,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 516,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 375,
"nscanned" : 375,
"nscannedObjectsAllPlans" : 3379,
"nscannedAllPlans" : 3379,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 37,
"nChunkSkips" : 0,
"millis" : 33222,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"day",
"day"
]
],
"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":"martha","last_name":"day"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 15,
"nscannedObjects" : 375,
"nscanned" : 375,
"nscannedObjectsAllPlans" : 3379,
"nscannedAllPlans" : 3379,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 1993,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"day",
"day"
]
],
"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":"samuel","last_name":"h*"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 3,
"nscanned" : 3,
"nscannedObjectsAllPlans" : 31,
"nscannedAllPlans" : 31,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 239,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"h*",
"h*"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> d_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"joseph","last_name":"sellick"}}} ).explain();
Wed May 29 14:54:19 SyntaxError: missing ; before statement (shell):1
> db.search_records.find( {"record_type":"ba","chapman_code":"SOM","primary_names":{"$elemMatch":{"first_name":"william","last_name":"moore"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 170,
"nscannedObjects" : 2932,
"nscanned" : 2932,
"nscannedObjectsAllPlans" : 17008,
"nscannedAllPlans" : 17008,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 4,
"nChunkSkips" : 0,
"millis" : 7158,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"moore",
"moore"
]
],
"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":"charity","last_name":"gillott"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 10,
"nscanned" : 10,
"nscannedObjectsAllPlans" : 94,
"nscannedAllPlans" : 94,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 74,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"gillott",
"gillott"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"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" : 0,
"nChunkSkips" : 0,
"millis" : 4897,
"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" : 1,
"nChunkSkips" : 0,
"millis" : 1468,
"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" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 41,
"nscannedObjects" : 605,
"nscanned" : 605,
"nscannedObjectsAllPlans" : 5449,
"nscannedAllPlans" : 5449,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 125,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"leeds",
"leeds"
]
],
"primary_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":"james woolmer massingham"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 1,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.first_name" : [
[
"james woolmer massingham",
"james woolmer massingham"
]
]
},
"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 chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 25,
"nscanned" : 25,
"nscannedObjectsAllPlans" : 228,
"nscannedAllPlans" : 228,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 2,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"primary_names.first_name" : [
[
"elsie may",
"elsie may"
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ma","chapman_code":"SOM","primary_names":{"$elemMatch":{"last_name":"*ner"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 1,
"nscanned" : 1,
"nscannedObjectsAllPlans" : 1,
"nscannedAllPlans" : 1,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.last_name" : [
[
"*ner",
"*ner"
]
],
"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":"betty"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.first_name_1",
"isMultiKey" : true,
"n" : 7670,
"nscannedObjects" : 7670,
"nscanned" : 7670,
"nscannedObjectsAllPlans" : 7670,
"nscannedAllPlans" : 7670,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 78,
"indexBounds" : {
"chapman_code" : [
[
"SOM",
"SOM"
]
],
"record_type" : [
[
"ma",
"ma"
]
],
"primary_names.first_name" : [
[
"betty",
"betty"
]
]
},
"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" : 0,
"nChunkSkips" : 0,
"millis" : 33,
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 1155,
"nscanned" : 1155,
"nscannedObjectsAllPlans" : 10399,
"nscannedAllPlans" : 10399,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 39,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"primary_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":"frederick","last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 4,
"nscannedObjects" : 1155,
"nscanned" : 1155,
"nscannedObjectsAllPlans" : 10399,
"nscannedAllPlans" : 10399,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 34,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
> db.search_records.find( {"record_type":"ba","chapman_code":"NFK","primary_names":{"$elemMatch":{"last_name":"hendry"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1155,
"nscannedObjects" : 1155,
"nscanned" : 1155,
"nscannedObjectsAllPlans" : 1155,
"nscannedAllPlans" : 1155,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 3,
"indexBounds" : {
"chapman_code" : [
[
"NFK",
"NFK"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"hendry",
"hendry"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 8,
"nscannedObjects" : 8,
"nscanned" : 8,
"nscannedObjectsAllPlans" : 8,
"nscannedAllPlans" : 8,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"bu",
"bu"
]
],
"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 chapman_code_1_record_type_1_primary_soundex.last_name_1_primary_soundex:first_name_1",
"isMultiKey" : true,
"n" : 3,
"nscannedObjects" : 12,
"nscanned" : 12,
"nscannedObjectsAllPlans" : 87,
"nscannedAllPlans" : 87,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"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 chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 375,
"nscanned" : 375,
"nscannedObjectsAllPlans" : 3379,
"nscannedAllPlans" : 3379,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 12,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"day",
"day"
]
],
"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":"martha","last_name":"day"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 15,
"nscannedObjects" : 375,
"nscanned" : 375,
"nscannedObjectsAllPlans" : 3379,
"nscannedAllPlans" : 3379,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 14,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"day",
"day"
]
],
"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":"samuel","last_name":"h*"}}} ).explain();
{
"cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names.last_name_1_primary_names:first_name_1",
"isMultiKey" : true,
"n" : 1,
"nscannedObjects" : 3,
"nscanned" : 3,
"nscannedObjectsAllPlans" : 31,
"nscannedAllPlans" : 31,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"chapman_code" : [
[
"WRY",
"WRY"
]
],
"record_type" : [
[
"ba",
"ba"
]
],
"primary_names.last_name" : [
[
"h*",
"h*"
]
],
"primary_names:first_name" : [
[
{
"$minElement" : 1
},
{
"$maxElement" : 1
}
]
]
},
"server" : "anitaborg:27017"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment