Created
May 29, 2013 21:04
-
-
Save benwbrum/5673825 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| > db.perf2.find({},{query:1, "profile.nscannedObjects": 1, "profile.millis":1, "profile.cursor":1, "profile.n":1}).sort({"profile.nscannedObjects":-1}).pretty() | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac55"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"smith\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 22690, | |
| "nscannedObjects" : 359863, | |
| "millis" : 4580996 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a1f448a5628ef2baccd"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"G650\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 36476, | |
| "nscannedObjects" : 127845, | |
| "millis" : 1115890 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66ae7448a5628ef2bace4"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"STS\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"smith\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 32523, | |
| "nscannedObjects" : 32523, | |
| "millis" : 74746 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b17448a5628ef2bacf7"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"STS\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"smith\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 32523, | |
| "nscannedObjects" : 32523, | |
| "millis" : 1468 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668a6448a5628ef2bac5e"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"wm.\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 35, | |
| "nscannedObjects" : 32400, | |
| "millis" : 79 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac5b"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 32006, | |
| "nscannedObjects" : 32006, | |
| "millis" : 178380 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66895448a5628ef2bac5c"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 32006, | |
| "nscannedObjects" : 32006, | |
| "millis" : 178380 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a1e448a5628ef2bacc9"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"daniel\",\"last_name\":\"robertson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 46, | |
| "nscannedObjects" : 14166, | |
| "millis" : 146244 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a1e448a5628ef2bacca"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"daniel\",\"last_name\":\"robertson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 46, | |
| "nscannedObjects" : 14166, | |
| "millis" : 41 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6690a448a5628ef2bac78"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_inclusive_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 10229, | |
| "millis" : 5490 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668a6448a5628ef2bac5f"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"wm.\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 5, | |
| "nscannedObjects" : 7901, | |
| "millis" : 29 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668bf448a5628ef2bac67"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"k\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 7901, | |
| "millis" : 29 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668bf448a5628ef2bac68"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"edward\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 67, | |
| "nscannedObjects" : 7901, | |
| "millis" : 22 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af3448a5628ef2bacea"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"betty\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 7670, | |
| "nscannedObjects" : 7670, | |
| "millis" : 16230 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b23448a5628ef2bacfd"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"betty\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 7670, | |
| "nscannedObjects" : 7670, | |
| "millis" : 78 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6693d448a5628ef2bac7f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 149, | |
| "nscannedObjects" : 5570, | |
| "millis" : 38 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668f9448a5628ef2bac75"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john titus\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2, | |
| "nscannedObjects" : 5524, | |
| "millis" : 53642 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668f9448a5628ef2bac76"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john titus\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2, | |
| "nscannedObjects" : 5524, | |
| "millis" : 2765 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668f9448a5628ef2bac77"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 5524, | |
| "millis" : 57 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66934448a5628ef2bac7e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john titus\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2, | |
| "nscannedObjects" : 5524, | |
| "millis" : 51 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6697a448a5628ef2bac99"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"K520\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 1474, | |
| "nscannedObjects" : 4950, | |
| "millis" : 5542 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669d7448a5628ef2bacb0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"K520\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 1474, | |
| "nscannedObjects" : 4950, | |
| "millis" : 5542 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac57"), | |
| "query" : "db.search_records.find( {\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"towler\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_inclusive_names.first_name_1", | |
| "n" : 301, | |
| "nscannedObjects" : 4684, | |
| "millis" : 32173 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66971448a5628ef2bac93"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 22, | |
| "nscannedObjects" : 4362, | |
| "millis" : 295260 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66979448a5628ef2bac96"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"emma\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 33, | |
| "nscannedObjects" : 4362, | |
| "millis" : 25011 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66991448a5628ef2bac9c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 22, | |
| "nscannedObjects" : 4362, | |
| "millis" : 123 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ce448a5628ef2bacaa"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 22, | |
| "nscannedObjects" : 4362, | |
| "millis" : 295260 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669cf448a5628ef2bacab"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 22, | |
| "nscannedObjects" : 4362, | |
| "millis" : 295260 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669d7448a5628ef2bacad"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"emma\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 33, | |
| "nscannedObjects" : 4362, | |
| "millis" : 25011 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ee448a5628ef2bacb3"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 22, | |
| "nscannedObjects" : 4362, | |
| "millis" : 123 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668a6448a5628ef2bac60"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"kingston\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1047, | |
| "nscannedObjects" : 3997, | |
| "millis" : 31377 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668e3448a5628ef2bac71"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"smith\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 3560, | |
| "nscannedObjects" : 3560, | |
| "millis" : 8641 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a99448a5628ef2bacdc"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"ann\",\"last_name\":\"parker\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 76, | |
| "nscannedObjects" : 3253, | |
| "millis" : 169009 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a16448a5628ef2bacc3"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"SOM\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"brimble\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 178, | |
| "nscannedObjects" : 3056, | |
| "millis" : 19 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66ad2448a5628ef2bace1"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"moore\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 170, | |
| "nscannedObjects" : 2932, | |
| "millis" : 98260 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b17448a5628ef2bacf4"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"moore\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 170, | |
| "nscannedObjects" : 2932, | |
| "millis" : 7158 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af3448a5628ef2baceb"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 5, | |
| "nscannedObjects" : 2926, | |
| "millis" : 41689 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b24448a5628ef2bacfe"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 5, | |
| "nscannedObjects" : 2926, | |
| "millis" : 33 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66ae7448a5628ef2bace3"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james\",\"last_name\":\"massingham\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 91, | |
| "nscannedObjects" : 2410, | |
| "millis" : 29156 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b17448a5628ef2bacf6"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james\",\"last_name\":\"massingham\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 91, | |
| "nscannedObjects" : 2410, | |
| "millis" : 4897 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a5b448a5628ef2bacd4"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"last_name\":\"unwin\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2058, | |
| "nscannedObjects" : 2058, | |
| "millis" : 14353 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af9448a5628ef2bacec"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 4, | |
| "nscannedObjects" : 1155, | |
| "millis" : 16141 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af9448a5628ef2baced"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 4, | |
| "nscannedObjects" : 1155, | |
| "millis" : 46 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af9448a5628ef2bacee"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1155, | |
| "nscannedObjects" : 1155, | |
| "millis" : 161 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b3e448a5628ef2bacff"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 4, | |
| "nscannedObjects" : 1155, | |
| "millis" : 39 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b3e448a5628ef2bad00"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 4, | |
| "nscannedObjects" : 1155, | |
| "millis" : 34 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b3e448a5628ef2bad01"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1155, | |
| "nscannedObjects" : 1155, | |
| "millis" : 3 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a1e448a5628ef2bacc8"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"G445\",\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 940, | |
| "millis" : 7001 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6694a448a5628ef2bac89"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 84, | |
| "nscannedObjects" : 878, | |
| "millis" : 27 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a16448a5628ef2bacc6"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"W450\",\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 48, | |
| "nscannedObjects" : 866, | |
| "millis" : 30238 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a16448a5628ef2bacc7"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"W450\",\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 48, | |
| "nscannedObjects" : 866, | |
| "millis" : 26 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a1e448a5628ef2baccb"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 866, | |
| "nscannedObjects" : 866, | |
| "millis" : 2 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668f9448a5628ef2bac73"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"abraham\",\"last_name\":\"hemingway\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 24, | |
| "nscannedObjects" : 793, | |
| "millis" : 27385 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668f9448a5628ef2bac74"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"charles\",\"last_name\":\"hemingway\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 6, | |
| "nscannedObjects" : 793, | |
| "millis" : 6439 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ce448a5628ef2baca9"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"greenwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 792, | |
| "nscannedObjects" : 792, | |
| "millis" : 2828 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668bf448a5628ef2bac66"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"last_name\":\"laurie\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 758, | |
| "nscannedObjects" : 758, | |
| "millis" : 4360 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af2448a5628ef2bace6"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"mary\",\"last_name\":\"leeds\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 41, | |
| "nscannedObjects" : 605, | |
| "millis" : 28003 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b23448a5628ef2bacf9"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"mary\",\"last_name\":\"leeds\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 41, | |
| "nscannedObjects" : 605, | |
| "millis" : 125 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668be448a5628ef2bac64"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 28, | |
| "nscannedObjects" : 495, | |
| "millis" : 12047 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668b2448a5628ef2bac62"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"LIN\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names_o_last_name_1_inclusive_names:first_name_1", | |
| "n" : 37, | |
| "nscannedObjects" : 463, | |
| "millis" : 2222 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a16448a5628ef2bacc4"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"brimble\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names_o_last_name_1_inclusive_names:first_name_1", | |
| "n" : 36, | |
| "nscannedObjects" : 461, | |
| "millis" : 76 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668b2448a5628ef2bac61"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"emma\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 4, | |
| "nscannedObjects" : 453, | |
| "millis" : 22910 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668b2448a5628ef2bac63"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 28, | |
| "nscannedObjects" : 453, | |
| "millis" : 566 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a28448a5628ef2bacd1"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"last_name\":\"wadley\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 435, | |
| "nscannedObjects" : 435, | |
| "millis" : 3370 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a8c448a5628ef2bacdb"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"batten\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 425, | |
| "nscannedObjects" : 425, | |
| "millis" : 2373 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a4d448a5628ef2bacd3"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"roynon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 132, | |
| "nscannedObjects" : 424, | |
| "millis" : 2193 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b0a448a5628ef2bacf1"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"day\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 375, | |
| "millis" : 33222 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b0a448a5628ef2bacf2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"martha\",\"last_name\":\"day\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 15, | |
| "nscannedObjects" : 375, | |
| "millis" : 1993 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b3e448a5628ef2bad04"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"day\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 375, | |
| "millis" : 12 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b3f448a5628ef2bad05"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"martha\",\"last_name\":\"day\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 375, | |
| "millis" : 12 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a0d448a5628ef2bacc2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"fisher\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 351, | |
| "nscannedObjects" : 351, | |
| "millis" : 764 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6690a448a5628ef2bac7a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names_o_last_name_1_inclusive_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 332, | |
| "millis" : 325 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66895448a5628ef2bac5d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 330, | |
| "nscannedObjects" : 330, | |
| "millis" : 430 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668bf448a5628ef2bac65"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 24, | |
| "nscannedObjects" : 330, | |
| "millis" : 1141 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66949448a5628ef2bac85"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 24, | |
| "nscannedObjects" : 330, | |
| "millis" : 19 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a28448a5628ef2baccf"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 24, | |
| "nscannedObjects" : 330, | |
| "millis" : 3379 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac51"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james\",\"last_name\":\"brumfield\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 7, | |
| "nscannedObjects" : 308, | |
| "millis" : 5556 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac52"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james\",\"last_name\":\"brumfield\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 7, | |
| "nscannedObjects" : 308, | |
| "millis" : 1 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a66448a5628ef2bacd6"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"batten\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 307, | |
| "nscannedObjects" : 307, | |
| "millis" : 1674 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a0c448a5628ef2bacc1"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"brimble\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names_o_last_name_1_inclusive_names:first_name_1", | |
| "n" : 28, | |
| "nscannedObjects" : 304, | |
| "millis" : 300 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66971448a5628ef2bac94"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 15, | |
| "nscannedObjects" : 300, | |
| "millis" : 13115 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a0c448a5628ef2bacc0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"brimble\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 22, | |
| "nscannedObjects" : 296, | |
| "millis" : 2123 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a16448a5628ef2bacc5"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"harold\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 11, | |
| "nscannedObjects" : 267, | |
| "millis" : 7152 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66aba448a5628ef2bace0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joseph\",\"last_name\":\"sellick\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 262, | |
| "millis" : 12400 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a28448a5628ef2bacce"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"fisher\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 261, | |
| "nscannedObjects" : 261, | |
| "millis" : 1106 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6697a448a5628ef2bac9a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"B260\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 237, | |
| "nscannedObjects" : 237, | |
| "millis" : 867 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669d7448a5628ef2bacb1"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"B260\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 237, | |
| "nscannedObjects" : 237, | |
| "millis" : 867 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6690a448a5628ef2bac79"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names_o_last_name_1_inclusive_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 157, | |
| "millis" : 9 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66979448a5628ef2bac97"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 12, | |
| "nscannedObjects" : 157, | |
| "millis" : 1236 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669d7448a5628ef2bacae"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 12, | |
| "nscannedObjects" : 157, | |
| "millis" : 1236 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6693d448a5628ef2bac81"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 11, | |
| "nscannedObjects" : 154, | |
| "millis" : 235 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66979448a5628ef2bac98"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 8, | |
| "nscannedObjects" : 138, | |
| "millis" : 771 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669d7448a5628ef2bacaf"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 8, | |
| "nscannedObjects" : 138, | |
| "millis" : 771 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d5448a5628ef2bac6f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"D553\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 20, | |
| "nscannedObjects" : 119, | |
| "millis" : 1195 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66949448a5628ef2bac87"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"inclusive_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_names_o_last_name_1_inclusive_names:first_name_1", | |
| "n" : 105, | |
| "nscannedObjects" : 105, | |
| "millis" : 706 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d3448a5628ef2bac6a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"DEV\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 101, | |
| "nscannedObjects" : 101, | |
| "millis" : 214 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66992448a5628ef2bac9e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"johannis\",\"last_name\":\"knowles\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 98, | |
| "millis" : 4694 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ee448a5628ef2bacb5"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"johannis\",\"last_name\":\"knowles\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 98, | |
| "millis" : 4694 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6697a448a5628ef2bac9b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"booker\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 94, | |
| "nscannedObjects" : 94, | |
| "millis" : 1 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669e5448a5628ef2bacb2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"booker\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 94, | |
| "nscannedObjects" : 94, | |
| "millis" : 1 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ce448a5628ef2baca8"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"thomas\",\"last_name\":\"roynon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 4, | |
| "nscannedObjects" : 76, | |
| "millis" : 1829 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a05448a5628ef2bacbf"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"thomas\",\"last_name\":\"roynon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 4, | |
| "nscannedObjects" : 76, | |
| "millis" : 1829 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac59"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"ella\",\"last_name\":\"cranness\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 75, | |
| "millis" : 926 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac5a"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"ella may\",\"last_name\":\"cranness\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 75, | |
| "millis" : 2 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66949448a5628ef2bac88"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 72, | |
| "nscannedObjects" : 72, | |
| "millis" : 481 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a1e448a5628ef2baccc"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"harold\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 70, | |
| "nscannedObjects" : 70, | |
| "millis" : 219 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a5b448a5628ef2bacd5"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"unwin\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 70, | |
| "nscannedObjects" : 70, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d3448a5628ef2bac69"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"DEV\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"fairchild\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 67, | |
| "nscannedObjects" : 67, | |
| "millis" : 432 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a44448a5628ef2bacd2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"george\",\"last_name\":\"phillips\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 60, | |
| "millis" : 4397 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a70448a5628ef2bacd7"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"phillips\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 5, | |
| "nscannedObjects" : 60, | |
| "millis" : 208 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a70448a5628ef2bacd8"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"susanna\",\"last_name\":\"phillips\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 60, | |
| "millis" : 373 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a7c448a5628ef2bacd9"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"susannah\",\"last_name\":\"phillips\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 60, | |
| "millis" : 1062 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66ae8448a5628ef2bace5"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"last_name\":\"caroline\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 51, | |
| "nscannedObjects" : 51, | |
| "millis" : 663 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b23448a5628ef2bacf8"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"last_name\":\"caroline\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 51, | |
| "nscannedObjects" : 51, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac58"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 12, | |
| "nscannedObjects" : 45, | |
| "millis" : 3569 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d4448a5628ef2bac6c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 12, | |
| "nscannedObjects" : 45, | |
| "millis" : 2 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66aa1448a5628ef2bacdd"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"janet\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 45, | |
| "millis" : 1551 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6699c448a5628ef2baca4"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"hammett\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 44, | |
| "millis" : 1787 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669f8448a5628ef2bacbb"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"hammett\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 44, | |
| "millis" : 1787 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6693d448a5628ef2bac80"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 41, | |
| "nscannedObjects" : 41, | |
| "millis" : 362 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a28448a5628ef2bacd0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 41, | |
| "nscannedObjects" : 41, | |
| "millis" : 23 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d7448a5628ef2bac70"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"greenfield\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 36, | |
| "nscannedObjects" : 36, | |
| "millis" : 360 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668e4448a5628ef2bac72"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"alice\",\"last_name\":\"towlson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 29, | |
| "millis" : 1645 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d4448a5628ef2bac6b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DEV\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 26, | |
| "nscannedObjects" : 26, | |
| "millis" : 232 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d4448a5628ef2bac6d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 3, | |
| "nscannedObjects" : 26, | |
| "millis" : 615 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a668d5448a5628ef2bac6e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_inclusive_soundex_o_last_name_1_inclusive_soundex:first_name_1", | |
| "n" : 3, | |
| "nscannedObjects" : 26, | |
| "millis" : 615 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af2448a5628ef2bace8"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"elsie may\",\"last_name\":\"peters\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 25, | |
| "millis" : 2067 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b23448a5628ef2bacfb"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"elsie may\",\"last_name\":\"peters\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 25, | |
| "millis" : 2 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66958448a5628ef2bac8a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DOR\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 21, | |
| "nscannedObjects" : 21, | |
| "millis" : 233 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66ab1448a5628ef2bacdf"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"henry\",\"last_name\":\"whitwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 21, | |
| "millis" : 1135 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66949448a5628ef2bac84"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 18, | |
| "millis" : 454 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66afa448a5628ef2bacf0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"A165\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 3, | |
| "nscannedObjects" : 12, | |
| "millis" : 516 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b3e448a5628ef2bad03"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"A165\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 3, | |
| "nscannedObjects" : 12, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac54"), | |
| "query" : "db.search_records.find( {\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"maxee\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_inclusive_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 11, | |
| "millis" : 192 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6699d448a5628ef2baca6"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"robert\",\"last_name\":\"wallbutton\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 11, | |
| "millis" : 533 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ce448a5628ef2baca7"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"robert\",\"last_name\":\"wallbutton\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 11, | |
| "millis" : 1 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a04448a5628ef2bacbd"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"robert\",\"last_name\":\"wallbutton\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 11, | |
| "millis" : 533 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a04448a5628ef2bacbe"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"robert\",\"last_name\":\"wallbutton\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 11, | |
| "millis" : 1 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66ae7448a5628ef2bace2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"charity\",\"last_name\":\"gillott\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 10, | |
| "millis" : 683 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b17448a5628ef2bacf5"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"charity\",\"last_name\":\"gillott\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 10, | |
| "millis" : 74 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66afa448a5628ef2bacef"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"A165\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 8, | |
| "nscannedObjects" : 8, | |
| "millis" : 69 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b3e448a5628ef2bad02"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"A165\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_soundex_o_last_name_1_primary_soundex:first_name_1", | |
| "n" : 8, | |
| "nscannedObjects" : 8, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6693d448a5628ef2bac82"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"CAM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 7, | |
| "millis" : 193 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6693e448a5628ef2bac83"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"CAM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 7, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66959448a5628ef2bac8b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john *\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 4, | |
| "millis" : 35 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66959448a5628ef2bac8c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john ?\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 4, | |
| "millis" : 55 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b17448a5628ef2bacf3"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"h*\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 3, | |
| "millis" : 239 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b46448a5628ef2bad06"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"h*\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 3, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66959448a5628ef2bac8d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john t\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 2, | |
| "millis" : 14 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6699c448a5628ef2baca5"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"henry wilcox\",\"last_name\":\"down\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 2, | |
| "millis" : 544 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669f9448a5628ef2bacbc"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"henry wilcox\",\"last_name\":\"down\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 2, | |
| "millis" : 544 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66965448a5628ef2bac90"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LEI\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 20 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66972448a5628ef2bac95"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan emma\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66991448a5628ef2bac9d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"adeline doris\",\"last_name\":\"satchell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 185 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66992448a5628ef2bac9f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"norman douglas\",\"last_name\":\"walker\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 201 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6699c448a5628ef2baca2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"nora matilda\",\"last_name\":\"hale\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 411 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6699c448a5628ef2baca3"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"anne\",\"last_name\":\"narde\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 21 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669d7448a5628ef2bacac"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan emma\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ee448a5628ef2bacb4"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"adeline doris\",\"last_name\":\"satchell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 185 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ee448a5628ef2bacb6"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"norman douglas\",\"last_name\":\"walker\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 201 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669f8448a5628ef2bacb9"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"nora matilda\",\"last_name\":\"hale\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 411 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669f8448a5628ef2bacba"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"anne\",\"last_name\":\"narde\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 21 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66a85448a5628ef2bacda"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"overthrow\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 10 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66aaa448a5628ef2bacde"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"janet parker\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af2448a5628ef2bace7"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james woolmer massingham\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66af2448a5628ef2bace9"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"*ner\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 12 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b23448a5628ef2bacfa"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james woolmer massingham\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66b23448a5628ef2bacfc"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"*ner\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac53"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"BDF\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"carlstead\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66894448a5628ef2bac56"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"BDF\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"carlstead\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a6690a448a5628ef2bac7b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66934448a5628ef2bac7c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john titus \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66934448a5628ef2bac7d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john titus \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66949448a5628ef2bac86"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashword\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66965448a5628ef2bac8e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NTH\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66965448a5628ef2bac8f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"OXF\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66966448a5628ef2bac91"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SAL\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66971448a5628ef2bac92"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"BDF\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor chapman_code_1_record_type_1_primary_names_o_last_name_1_primary_names:first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66992448a5628ef2baca0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"hale\",\"last_name\":\"nora matilda\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 83 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a66993448a5628ef2baca1"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"hale\",\"last_name\":\"nora matilda\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669ef448a5628ef2bacb7"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"hale\",\"last_name\":\"nora matilda\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 83 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a669f8448a5628ef2bacb8"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"hale\",\"last_name\":\"nora matilda\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment