Created
May 28, 2013 18:55
-
-
Save benwbrum/5665171 to your computer and use it in GitHub Desktop.
Queries and their performance fromtest pass 1
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.perf.find({},{query:1, "profile.nscannedObjects": 1, "profile.millis":1, "profile.cursor":1, "profile.n":1}).sort({"profile.nscannedObjects":-1}).pretty() | |
| { | |
| "_id" : ObjectId("51a4dd31f53d9190e72a683b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 0, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 1022028 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd31f53d9190e72a683c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 0, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 891418 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68aa"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james woolmer massingham\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 1, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 1024407 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68ad"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"betty\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 7670, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 793599 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcb5f53d9190e72a6826"), | |
| "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" : 3655855 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a6890"), | |
| "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" : 1197103 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a6880"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"B260\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 237, | |
| "nscannedObjects" : 88215, | |
| "millis" : 773922 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68a7"), | |
| "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" : 97925 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd0ff53d9190e72a6832"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"e\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 32400, | |
| "millis" : 1709 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd0ff53d9190e72a6833"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 1921, | |
| "nscannedObjects" : 32400, | |
| "millis" : 76 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd0ff53d9190e72a6834"), | |
| "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" : 55, | |
| "nscannedObjects" : 32400, | |
| "millis" : 153 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a6837"), | |
| "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" : 24632 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd4bf53d9190e72a683f"), | |
| "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" : 537776 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcedf53d9190e72a682f"), | |
| "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" : 206204 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a6838"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"S540\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 84, | |
| "nscannedObjects" : 24205, | |
| "millis" : 331302 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a686f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"S540\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 84, | |
| "nscannedObjects" : 24205, | |
| "millis" : 217342 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a6870"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DOR\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 84, | |
| "nscannedObjects" : 24205, | |
| "millis" : 217342 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a687f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"K520\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 1474, | |
| "nscannedObjects" : 19295, | |
| "millis" : 16916 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a683a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"wm.\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 15795, | |
| "millis" : 15416 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de32f53d9190e72a688c"), | |
| "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" : 175290 | |
| } | |
| } | |
| Type "it" for more | |
| > | |
| > | |
| > | |
| > db.perf.find({},{query:1, "profile.nscannedObjects": 1, "profile.millis":1, "profile.cursor":1, "profile.n":1}).sort({"profile.nscannedObjects":-1}).pretty() | |
| { | |
| "_id" : ObjectId("51a4dd31f53d9190e72a683b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 0, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 1022028 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd31f53d9190e72a683c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 0, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 891418 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68aa"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james woolmer massingham\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 1, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 1024407 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68ad"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"betty\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BasicCursor", | |
| "n" : 7670, | |
| "nscannedObjects" : 24020988, | |
| "millis" : 793599 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcb5f53d9190e72a6826"), | |
| "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" : 3655855 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a6890"), | |
| "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" : 1197103 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a6880"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"B260\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 237, | |
| "nscannedObjects" : 88215, | |
| "millis" : 773922 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68a7"), | |
| "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" : 97925 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd0ff53d9190e72a6832"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"e\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 32400, | |
| "millis" : 1709 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd0ff53d9190e72a6833"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 1921, | |
| "nscannedObjects" : 32400, | |
| "millis" : 76 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd0ff53d9190e72a6834"), | |
| "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" : 55, | |
| "nscannedObjects" : 32400, | |
| "millis" : 153 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a6837"), | |
| "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" : 24632 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd4bf53d9190e72a683f"), | |
| "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" : 537776 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcedf53d9190e72a682f"), | |
| "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" : 206204 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a6838"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"S540\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 84, | |
| "nscannedObjects" : 24205, | |
| "millis" : 331302 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a686f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"S540\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 84, | |
| "nscannedObjects" : 24205, | |
| "millis" : 217342 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a6870"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DOR\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 84, | |
| "nscannedObjects" : 24205, | |
| "millis" : 217342 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a687f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"K520\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 1474, | |
| "nscannedObjects" : 19295, | |
| "millis" : 16916 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a683a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"wm.\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 15795, | |
| "millis" : 15416 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de32f53d9190e72a688c"), | |
| "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" : 175290 | |
| } | |
| } | |
| Type "it" for more | |
| > it | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a688d"), | |
| "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" : 40 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddcaf53d9190e72a685e"), | |
| "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" : 4301 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddfdf53d9190e72a6879"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 22, | |
| "nscannedObjects" : 9472, | |
| "millis" : 266224 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ef53d9190e72a687b"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 9472, | |
| "millis" : 721 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ef53d9190e72a687c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"emma\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 33, | |
| "nscannedObjects" : 9472, | |
| "millis" : 166 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a68a0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"janet\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 9472, | |
| "millis" : 298881 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a68a1"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 9472, | |
| "millis" : 419 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a6835"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"brimble\",\"last_name\":\"james\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 9467, | |
| "millis" : 283299 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68b2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"A165\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 8, | |
| "nscannedObjects" : 8009, | |
| "millis" : 114292 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68b3"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"A165\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 3, | |
| "nscannedObjects" : 8009, | |
| "millis" : 558 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de66f53d9190e72a68b4"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"day\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 3, | |
| "nscannedObjects" : 8009, | |
| "millis" : 558 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd0ff53d9190e72a6831"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"eliza\",\"last_name\":\"dawson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 36, | |
| "nscannedObjects" : 7901, | |
| "millis" : 334 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd4bf53d9190e72a6840"), | |
| "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" : 785 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd7af53d9190e72a6849"), | |
| "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" : 31645 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd7af53d9190e72a684a"), | |
| "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" : 317 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dceef53d9190e72a6830"), | |
| "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" : 7861, | |
| "nscannedObjects" : 7861, | |
| "millis" : 107 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a6839"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"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", | |
| "n" : 2, | |
| "nscannedObjects" : 7861, | |
| "millis" : 1972 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddb3f53d9190e72a6854"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"smith\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 3560, | |
| "nscannedObjects" : 7699, | |
| "millis" : 58418 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a689f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"ann\",\"last_name\":\"parker\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 76, | |
| "nscannedObjects" : 7233, | |
| "millis" : 260074 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a68a4"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"moore\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 170, | |
| "nscannedObjects" : 6786, | |
| "millis" : 188926 | |
| } | |
| } | |
| Type "it" for more | |
| > it | |
| { | |
| "_id" : ObjectId("51a4dd8bf53d9190e72a684c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"DEV\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 101, | |
| "nscannedObjects" : 5997, | |
| "millis" : 142123 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd92f53d9190e72a684d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DEV\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 26, | |
| "nscannedObjects" : 5997, | |
| "millis" : 648 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dddff53d9190e72a6865"), | |
| "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" : 135 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddc9f53d9190e72a6858"), | |
| "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" : 32470 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddc9f53d9190e72a6859"), | |
| "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" : 2476 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddc9f53d9190e72a685a"), | |
| "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" : 55 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddc9f53d9190e72a685b"), | |
| "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" : 110 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddc9f53d9190e72a685c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"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" : 82 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddcaf53d9190e72a685d"), | |
| "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" : 55 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dddff53d9190e72a6864"), | |
| "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" : 190 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddabf53d9190e72a6851"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DEV\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"D553\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 19, | |
| "nscannedObjects" : 4725, | |
| "millis" : 52959 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcb5f53d9190e72a6828"), | |
| "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" : 25818 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de31f53d9190e72a6889"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"W450\",\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 48, | |
| "nscannedObjects" : 4164, | |
| "millis" : 56482 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de31f53d9190e72a688a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_soundex\":{\"$elemMatch\":{\"first_name\":\"W450\",\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 48, | |
| "nscannedObjects" : 4164, | |
| "millis" : 133 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a688e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_soundex\":{\"$elemMatch\":{\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_soundex_o_last_name_1_primary_soundex.first_name_1", | |
| "n" : 866, | |
| "nscannedObjects" : 4164, | |
| "millis" : 30 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd57f53d9190e72a6841"), | |
| "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" : 42637 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de87f53d9190e72a68b8"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"henry\",\"last_name\":\"nobbs\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 17, | |
| "nscannedObjects" : 3634, | |
| "millis" : 47453 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de31f53d9190e72a688b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"G445\",\"last_name\":\"H643\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 2, | |
| "nscannedObjects" : 3491, | |
| "millis" : 3418 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd31f53d9190e72a683d"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"SOM\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"wallington\",\"last_name\":\"brimble\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 3056, | |
| "millis" : 37823 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de28f53d9190e72a6886"), | |
| "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" : 1935 | |
| } | |
| } | |
| Type "it" for more | |
| > it | |
| { | |
| "_id" : ObjectId("51a4de31f53d9190e72a6887"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"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" : 36, | |
| "nscannedObjects" : 3056, | |
| "millis" : 24 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68ae"), | |
| "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" : 66823 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd6ef53d9190e72a6843"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"LIN\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 37, | |
| "nscannedObjects" : 2393, | |
| "millis" : 20462 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddd1f53d9190e72a6860"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 2393, | |
| "millis" : 36 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68b1"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 1155, | |
| "nscannedObjects" : 2202, | |
| "millis" : 179 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68af"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 4, | |
| "nscannedObjects" : 2187, | |
| "millis" : 128 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68b0"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"frederick\",\"last_name\":\"hendry\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 4, | |
| "nscannedObjects" : 2187, | |
| "millis" : 152 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de46f53d9190e72a6897"), | |
| "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" : 24243 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd16f53d9190e72a6836"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"james\",\"last_name\":\"brimble\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 25, | |
| "nscannedObjects" : 1523, | |
| "millis" : 8222 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddabf53d9190e72a6852"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"D553\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 20, | |
| "nscannedObjects" : 1490, | |
| "millis" : 495 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddb9f53d9190e72a6856"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"abraham\",\"last_name\":\"hemingway\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 24, | |
| "nscannedObjects" : 1443, | |
| "millis" : 14503 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddc9f53d9190e72a6857"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"charles\",\"last_name\":\"hemingway\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 6, | |
| "nscannedObjects" : 1443, | |
| "millis" : 53 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddd1f53d9190e72a685f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"inclusive_names\":{\"$elemMatch\":{\"first_name\":\"john \",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 0, | |
| "nscannedObjects" : 1401, | |
| "millis" : 72 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68a9"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"mary\",\"last_name\":\"leeds\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 41, | |
| "nscannedObjects" : 1317, | |
| "millis" : 41109 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dccef53d9190e72a682a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 24, | |
| "nscannedObjects" : 1278, | |
| "millis" : 36306 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dccef53d9190e72a682b"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2, | |
| "nscannedObjects" : 1278, | |
| "millis" : 332 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd31f53d9190e72a683e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 330, | |
| "nscannedObjects" : 1278, | |
| "millis" : 59889 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd6ef53d9190e72a6842"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"emma\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 4, | |
| "nscannedObjects" : 1278, | |
| "millis" : 24938 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd6ef53d9190e72a6844"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 28, | |
| "nscannedObjects" : 1278, | |
| "millis" : 119 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd6ef53d9190e72a6845"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 28, | |
| "nscannedObjects" : 1278, | |
| "millis" : 1457 | |
| } | |
| } | |
| Type "it" for more | |
| > it | |
| { | |
| "_id" : ObjectId("51a4dd6ef53d9190e72a6846"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 24, | |
| "nscannedObjects" : 1278, | |
| "millis" : 418 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddd1f53d9190e72a6861"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"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" : 1278, | |
| "millis" : 12 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddd1f53d9190e72a6862"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 1278, | |
| "millis" : 15 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dddff53d9190e72a6863"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 1278, | |
| "millis" : 17 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a686b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 24, | |
| "nscannedObjects" : 1278, | |
| "millis" : 21 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a6871"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"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" : 1278, | |
| "millis" : 64 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddf0f53d9190e72a6872"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"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" : 1278, | |
| "millis" : 12 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddfdf53d9190e72a6873"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 1278, | |
| "millis" : 12 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de87f53d9190e72a68b7"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 28, | |
| "nscannedObjects" : 1278, | |
| "millis" : 32319 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de28f53d9190e72a6885"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"fisher\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 351, | |
| "nscannedObjects" : 1148, | |
| "millis" : 10702 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a6891"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"fisher\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 261, | |
| "nscannedObjects" : 1148, | |
| "millis" : 2309 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a6892"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LIN\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 261, | |
| "nscannedObjects" : 1148, | |
| "millis" : 2309 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a68a3"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joseph\",\"last_name\":\"sellick\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2, | |
| "nscannedObjects" : 1080, | |
| "millis" : 16567 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de46f53d9190e72a6899"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"batten\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 307, | |
| "nscannedObjects" : 998, | |
| "millis" : 30057 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a689e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"batten\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1_primary_names.first_name_1", | |
| "n" : 425, | |
| "nscannedObjects" : 998, | |
| "millis" : 445 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68ab"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 846, | |
| "millis" : 52400 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd6ef53d9190e72a6847"), | |
| "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" : 9305 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd79f53d9190e72a6848"), | |
| "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" : 4 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dddff53d9190e72a6867"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 11, | |
| "nscannedObjects" : 687, | |
| "millis" : 118 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ef53d9190e72a687a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 15, | |
| "nscannedObjects" : 595, | |
| "millis" : 8543 | |
| } | |
| } | |
| Type "it" for more | |
| > it | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a687d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 12, | |
| "nscannedObjects" : 595, | |
| "millis" : 235 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a687e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"claxon\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 8, | |
| "nscannedObjects" : 595, | |
| "millis" : 345 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3df53d9190e72a6895"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"george\",\"last_name\":\"phillips\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2, | |
| "nscannedObjects" : 560, | |
| "millis" : 36553 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de46f53d9190e72a689a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"phillips\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 5, | |
| "nscannedObjects" : 560, | |
| "millis" : 11 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de46f53d9190e72a689b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"susanna\",\"last_name\":\"phillips\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 560, | |
| "millis" : 11 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de46f53d9190e72a689c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_n\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 560, | |
| "millis" : 11 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de31f53d9190e72a6888"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"harold\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 11, | |
| "nscannedObjects" : 461, | |
| "millis" : 13119 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a688f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NFK\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"harold\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 70, | |
| "nscannedObjects" : 461, | |
| "millis" : 75 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a6894"), | |
| "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" : 3104 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de46f53d9190e72a6896"), | |
| "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" : 1029 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a686d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"inclusive_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_names_o_last_name_1_chapman_code_1_inclusive_names.first_name_1", | |
| "n" : 105, | |
| "nscannedObjects" : 383, | |
| "millis" : 755 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dc98f53d9190e72a6822"), | |
| "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" : 8329 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dca5f53d9190e72a6823"), | |
| "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" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcb5f53d9190e72a6829"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"first_name\":\"william\",\"last_name\":\"brumfield\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_primary_names.first_name_1", | |
| "n" : 16, | |
| "nscannedObjects" : 308, | |
| "millis" : 3999 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd99f53d9190e72a684e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 12, | |
| "nscannedObjects" : 301, | |
| "millis" : 387 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dda1f53d9190e72a684f"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 3, | |
| "nscannedObjects" : 301, | |
| "millis" : 5 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dda1f53d9190e72a6850"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"J500\",\"last_name\":\"F624\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 48, | |
| "nscannedObjects" : 301, | |
| "millis" : 4 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a6883"), | |
| "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 primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 297, | |
| "millis" : 6366 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de28f53d9190e72a6884"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"johannis\",\"last_name\":\"knowles\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 297, | |
| "millis" : 6366 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dddff53d9190e72a6866"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 41, | |
| "nscannedObjects" : 218, | |
| "millis" : 4442 | |
| } | |
| } | |
| Type "it" for more | |
| > it | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a686e"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 72, | |
| "nscannedObjects" : 218, | |
| "millis" : 39 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de3cf53d9190e72a6893"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 41, | |
| "nscannedObjects" : 218, | |
| "millis" : 1240 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a6881"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"booker\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 94, | |
| "nscannedObjects" : 158, | |
| "millis" : 207 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de0ff53d9190e72a6882"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"joan\",\"last_name\":\"king\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 94, | |
| "nscannedObjects" : 158, | |
| "millis" : 207 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dd82f53d9190e72a684b"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"DEV\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"fairchild\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 67, | |
| "nscannedObjects" : 121, | |
| "millis" : 7460 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddabf53d9190e72a6853"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"greenfield\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 36, | |
| "nscannedObjects" : 88, | |
| "millis" : 2897 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a68a2"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"henry\",\"last_name\":\"whitwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 81, | |
| "millis" : 2815 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcd6f53d9190e72a682c"), | |
| "query" : "db.search_records.find( {\"primary_names\":{\"$elemMatch\":{\"last_name\":\"cranness\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 75, | |
| "nscannedObjects" : 75, | |
| "millis" : 1211 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcedf53d9190e72a682d"), | |
| "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" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dcedf53d9190e72a682e"), | |
| "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" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de46f53d9190e72a6898"), | |
| "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("51a4ddb3f53d9190e72a6855"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"alice\",\"last_name\":\"towlson\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 2, | |
| "nscannedObjects" : 59, | |
| "millis" : 1606 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68a8"), | |
| "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" : 1052 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a686a"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SFK\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 38, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dddff53d9190e72a6868"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"CAM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 30, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dde1f53d9190e72a6869"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"CAM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"john\",\"last_name\":\"snell\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 30, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de7df53d9190e72a68b5"), | |
| "query" : "db.search_records.find( {\"chapman_code\":\"DEV\",\"inclusive_soundex\":{\"$elemMatch\":{\"first_name\":\"R163\",\"last_name\":\"S143\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor inclusive_soundex_o_last_name_1_chapman_code_1_inclusive_soundex.first_name_1", | |
| "n" : 1, | |
| "nscannedObjects" : 20, | |
| "millis" : 181 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a689d"), | |
| "query" : "db.search_records.find( {\"record_type\":\"bu\",\"chapman_code\":\"GLS\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"overthrow\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 15, | |
| "millis" : 270 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a68a5"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"charity\",\"last_name\":\"gillott\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 14, | |
| "millis" : 502 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de50f53d9190e72a68a6"), | |
| "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", | |
| "n" : 1, | |
| "nscannedObjects" : 14, | |
| "millis" : 502 | |
| } | |
| } | |
| Type "it" for more | |
| > it | |
| { | |
| "_id" : ObjectId("51a4dca5f53d9190e72a6825"), | |
| "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" : 214 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de5ef53d9190e72a68ac"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"*ner\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 4, | |
| "millis" : 298 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4de87f53d9190e72a68b6"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"WRY\",\"primary_names\":{\"$elemMatch\":{\"first_name\":\"samuel\",\"last_name\":\"h*\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 4, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddeff53d9190e72a686c"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ba\",\"chapman_code\":\"SOM\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashword\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 1, | |
| "millis" : 11 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddfdf53d9190e72a6874"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"NTH\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 1, | |
| "millis" : 178 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddfdf53d9190e72a6876"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"LEI\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 1, | |
| "nscannedObjects" : 1, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4dca5f53d9190e72a6824"), | |
| "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("51a4dcb5f53d9190e72a6827"), | |
| "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("51a4ddfdf53d9190e72a6875"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"OXF\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddfdf53d9190e72a6877"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"SAL\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).explain()", | |
| "profile" : { | |
| "cursor" : "BtreeCursor primary_names_o_last_name_1_chapman_code_1", | |
| "n" : 0, | |
| "nscannedObjects" : 0, | |
| "millis" : 0 | |
| } | |
| } | |
| { | |
| "_id" : ObjectId("51a4ddfdf53d9190e72a6878"), | |
| "query" : "db.search_records.find( {\"record_type\":\"ma\",\"chapman_code\":\"BDF\",\"primary_names\":{\"$elemMatch\":{\"last_name\":\"dashwood\"}}} ).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