Skip to content

Instantly share code, notes, and snippets.

@benwbrum
Created May 18, 2013 18:03
Show Gist options
  • Save benwbrum/5605304 to your computer and use it in GitHub Desktop.
Save benwbrum/5605304 to your computer and use it in GitHub Desktop.
Longest queries by millis
{
"ts" : ISODate("2013-05-18T14:24:26.987Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"chapman_code" : "LIN",
"primary_names" : {
"$elemMatch" : {
"first_name" : "snell"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 2781,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(2006100466),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(1081177860),
"w" : NumberLong(7)
}
},
"responseLength" : 48,
"millis" : 1081873,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:39:22.334Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"first_name" : "wm.",
"last_name" : "dawson"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 8050,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(773505779),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(423042226),
"w" : NumberLong(180)
}
},
"responseLength" : 48,
"millis" : 423058,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:16:36.382Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"chapman_code" : "NFK",
"inclusive_names" : {
"$elemMatch" : {
"first_name" : "wm.",
"last_name" : "dawson"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 649,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(586385497),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(309966038),
"w" : NumberLong(5470643)
}
},
"responseLength" : 48,
"millis" : 310334,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:05:04.684Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"chapman_code" : "LIN",
"primary_soundex" : {
"$elemMatch" : {
"first_name" : "J500",
"last_name" : "S540"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 3832,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(421858600),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(211001058),
"w" : NumberLong(132)
}
},
"responseLength" : 48,
"millis" : 211014,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:28:03.936Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"last_name" : "dawson"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 5192,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(341360622),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(170764003),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 170779,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:37:05.004Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"chapman_code" : "NFK",
"primary_names" : {
"$elemMatch" : {
"first_name" : "wm.",
"last_name" : "dawson"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 1433,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(133929945),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(97596478),
"w" : NumberLong(10013781)
}
},
"responseLength" : 48,
"millis" : 97646,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:19:01.671Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"chapman_code" : "SOM",
"inclusive_names" : {
"$elemMatch" : {
"first_name" : "wallington",
"last_name" : "brimble"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 41,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(100305549),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(28557899),
"w" : NumberLong(370913)
}
},
"responseLength" : 48,
"millis" : 76203,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:17:40.116Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"chapman_code" : "LIN",
"primary_names" : {
"$elemMatch" : {
"last_name" : "snell"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 86,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(140588600),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(70640755),
"w" : NumberLong(934800)
}
},
"responseLength" : 48,
"millis" : 71668,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:38:33.649Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"primary_names" : {
"$elemMatch" : {
"last_name" : "kingston"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 462,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(114270114),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(64480173),
"w" : NumberLong(33164951)
}
},
"responseLength" : 48,
"millis" : 65265,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:59:10.968Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "bu",
"chapman_code" : "SOM",
"primary_names" : {
"$elemMatch" : {
"first_name" : "brimble",
"last_name" : "james"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 37,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(80265404),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(39875376),
"w" : NumberLong(3)
}
},
"responseLength" : 48,
"millis" : 40406,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T12:40:51.981Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"chapman_code" : "LIN",
"primary_names" : {
"$elemMatch" : {
"first_name" : "john",
"last_name" : "snell"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 243,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(70045045),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(34701814),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 35358,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:05:47.325Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"chapman_code" : "NFK",
"inclusive_names" : {
"$elemMatch" : {
"first_name" : "wm.",
"last_name" : "dawson"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 140,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(28309050),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(14132540),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 14182,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:39:32.636Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"first_name" : "wm.",
"last_name" : "dawson"
}
}
},
"ntoreturn" : 100,
"ntoskip" : 0,
"nscanned" : 32400,
"keyUpdates" : 0,
"numYield" : 286,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(3945643),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(10119812),
"w" : NumberLong(32801)
}
},
"nreturned" : 35,
"responseLength" : 30771,
"millis" : 10120,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:39:32.275Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "bu",
"chapman_code" : "LIN",
"primary_names" : {
"$elemMatch" : {
"first_name" : "emma",
"last_name" : "snell"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 351,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(17999966),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(9890268),
"w" : NumberLong(46674)
}
},
"responseLength" : 48,
"millis" : 9890,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:59:56.388Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "bu",
"chapman_code" : "SOM",
"primary_names" : {
"$elemMatch" : {
"first_name" : "james",
"last_name" : "brimble"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 7,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(14047762),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(6690008),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 7359,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T15:51:00.221Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"last_name" : "laurie"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 4,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(8797240),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4000235),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 4798,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T11:47:39.993Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"inclusive_names" : {
"$elemMatch" : {
"first_name" : "william",
"last_name" : "towler"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 1,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(3568785),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(261084),
"w" : NumberLong(181932)
}
},
"responseLength" : 48,
"millis" : 3308,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:49:52.716Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("5191cda88ebe61193001f9a5")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(4834),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(10),
"w" : NumberLong(4)
}
},
"responseLength" : 1372,
"millis" : 1490,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:17:06.847Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"last_name" : "cranness"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 1,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(1942831),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(777789),
"w" : NumberLong(5)
}
},
"responseLength" : 48,
"millis" : 1165,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:49:05.849Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"first_name" : "e",
"last_name" : "dawson"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 1,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(2253086),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(1116024),
"w" : NumberLong(5)
}
},
"responseLength" : 48,
"millis" : 1137,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:39:33.504Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"primary_names" : {
"$elemMatch" : {
"last_name" : "kingston"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 7,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(469158),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(942848),
"w" : NumberLong(3)
}
},
"responseLength" : 48,
"millis" : 1087,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:08:53.390Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("519432548ebe611977e52950")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(913730),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4),
"w" : NumberLong(183807)
}
},
"responseLength" : 989,
"millis" : 913,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T15:51:19.075Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_entries",
"query" : {
"$query" : {
"_id" : ObjectId("5194d5eb8ebe61195138e872")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(831381),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(7),
"w" : NumberLong(5)
}
},
"responseLength" : 549,
"millis" : 847,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:11:16.791Z"),
"op" : "query",
"ns" : "mv_20130513.search_queries",
"query" : {
"$query" : {
"_id" : ObjectId("51978aac8ebe615e5b000008")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(702577),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4),
"w" : NumberLong(495305)
}
},
"responseLength" : 146,
"millis" : 702,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:20:02.892Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_entries",
"query" : {
"$query" : {
"_id" : ObjectId("51922a9d8ebe611977286111")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(622482),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(8),
"w" : NumberLong(130025)
}
},
"responseLength" : 824,
"millis" : 638,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T11:55:17.186Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"first_name" : "william",
"last_name" : "brumfield"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 1,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(1197203),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(586625),
"w" : NumberLong(3)
}
},
"responseLength" : 48,
"millis" : 610,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:39:33.221Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_files",
"query" : {
"$query" : {
"_id" : ObjectId("51933d8e8ebe611930888b01")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(545020),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(23338),
"w" : NumberLong(1933)
}
},
"responseLength" : 1060,
"millis" : 582,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:07:44.196Z"),
"op" : "query",
"ns" : "mv_20130513.system.indexes",
"query" : {
"expireAfterSeconds" : {
"$exists" : true
}
},
"ntoreturn" : 0,
"ntoskip" : 0,
"nscanned" : 16,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(569436),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(3),
"w" : NumberLong(136166)
}
},
"nreturned" : 0,
"responseLength" : 20,
"millis" : 569,
"client" : "0.0.0.0",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:41:12.850Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "bu",
"chapman_code" : "LIN",
"inclusive_names" : {
"$elemMatch" : {
"first_name" : "john",
"last_name" : "snell"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(548902),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(3),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 548,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:37:15.955Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"chapman_code" : "NFK",
"primary_names" : {
"$elemMatch" : {
"first_name" : "wm.",
"last_name" : "dawson"
}
}
},
"ntoreturn" : 100,
"ntoskip" : 0,
"nscanned" : 7901,
"keyUpdates" : 0,
"numYield" : 1,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(985627),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(498024),
"w" : NumberLong(10311878)
}
},
"nreturned" : 5,
"responseLength" : 4223,
"millis" : 498,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:33:45.738Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("5191d6fa8ebe61197705d6ec")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(12617),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(9),
"w" : NumberLong(4)
}
},
"responseLength" : 1096,
"millis" : 491,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:41:38.568Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ba",
"chapman_code" : "LIN",
"primary_names" : {
"$elemMatch" : {
"first_name" : "john",
"last_name" : "snell"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 1,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(955353),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(463914),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 491,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:32:50.089Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("5191d7b98ebe611977062947")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(19807),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(11),
"w" : NumberLong(4)
}
},
"responseLength" : 1018,
"millis" : 489,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:44:19.656Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("519291be8ebe6119304dd0a5")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(7892),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(9),
"w" : NumberLong(4)
}
},
"responseLength" : 1473,
"millis" : 486,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:21:37.493Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("51922aae8ebe6119772868f3")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(421343),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(10),
"w" : NumberLong(79438)
}
},
"responseLength" : 1476,
"millis" : 438,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:41:49.739Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"chapman_code" : "LIN",
"primary_names" : {
"$elemMatch" : {
"first_name" : "john",
"last_name" : "snell"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(430720),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(3),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 430,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:39:32.275Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_entries",
"query" : {
"$query" : {
"_id" : ObjectId("51933dac8ebe61193088955d")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(387822),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(6),
"w" : NumberLong(9529977)
}
},
"responseLength" : 538,
"millis" : 410,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:16:13.894Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"create" : "search_queries"
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(408084)
},
"timeAcquiringMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(2923872)
}
},
"responseLength" : 75,
"millis" : 408,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:20:06.180Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"create" : "freereg1_csv_files"
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(356521)
},
"timeAcquiringMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(2926024)
}
},
"responseLength" : 75,
"millis" : 356,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:40:42.909Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"chapman_code" : "NFK",
"primary_names" : {
"$elemMatch" : {
"first_name" : "eliza",
"last_name" : "dawson"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(352239),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(3),
"w" : NumberLong(5)
}
},
"responseLength" : 48,
"millis" : 352,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:19:48.818Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("51922a9d8ebe611977286112")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(345374),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(5098),
"w" : NumberLong(119999)
}
},
"responseLength" : 1468,
"millis" : 345,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:08:54.273Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_entries",
"query" : {
"$query" : {
"_id" : ObjectId("519432548ebe611977e5294f")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(344167),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(5),
"w" : NumberLong(124773)
}
},
"responseLength" : 771,
"millis" : 344,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:56:25.193Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"first_name" : "wm",
"last_name" : "dawson"
}
}
},
"ntoreturn" : 100,
"ntoskip" : 0,
"nscanned" : 32400,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(323300),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4),
"w" : NumberLong(5)
}
},
"nreturned" : 55,
"responseLength" : 68884,
"millis" : 323,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:20:07.065Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_files",
"query" : {
"$query" : {
"_id" : ObjectId("51922a968ebe611977286097")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(295255),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(5),
"w" : NumberLong(529465)
}
},
"responseLength" : 962,
"millis" : 295,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:49:18.583Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"first_name" : "william",
"last_name" : "dawson"
}
}
},
"cursorid" : NumberLong("788753524176901495"),
"ntoreturn" : 100,
"ntoskip" : 0,
"nscanned" : 30106,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(279721),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(3),
"w" : NumberLong(5)
}
},
"nreturned" : 100,
"responseLength" : 99783,
"millis" : 279,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:21:38.447Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_entries",
"query" : {
"$query" : {
"_id" : ObjectId("51922aae8ebe6119772868f2")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(277799),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4),
"w" : NumberLong(605656)
}
},
"responseLength" : 822,
"millis" : 277,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:08:54.857Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_files",
"query" : {
"$query" : {
"_id" : ObjectId("5194324b8ebe611977e52909")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(275769),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4),
"w" : NumberLong(54159)
}
},
"responseLength" : 1014,
"millis" : 275,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:16:14.624Z"),
"op" : "insert",
"ns" : "mv_20130513.search_queries",
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(275341)
},
"timeAcquiringMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(254583)
}
},
"millis" : 275,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T11:55:16.047Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"create" : "search_queries"
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(274510)
},
"timeAcquiringMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(11)
}
},
"responseLength" : 75,
"millis" : 274,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:24:49.208Z"),
"op" : "query",
"ns" : "mv_20130513.search_queries",
"query" : {
},
"ntoreturn" : 0,
"ntoskip" : 0,
"nscanned" : 29,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(224137),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4),
"w" : NumberLong(4)
}
},
"nreturned" : 29,
"responseLength" : 2893,
"millis" : 224,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:02:35.055Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_entries",
"query" : {
"$query" : {
"_id" : ObjectId("519298038ebe6119774f58e4")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(169327),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(8),
"w" : NumberLong(4342333)
}
},
"responseLength" : 756,
"millis" : 204,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:32:18.978Z"),
"op" : "insert",
"ns" : "mv_20130513.search_queries",
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(196506)
},
"timeAcquiringMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(12)
}
},
"millis" : 196,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:00:58.970Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"first_name" : "wm.",
"last_name" : "dawson"
}
}
},
"ntoreturn" : 100,
"ntoskip" : 0,
"nscanned" : 32400,
"keyUpdates" : 0,
"numYield" : 1,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(274199),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(112791),
"w" : NumberLong(70662)
}
},
"nreturned" : 35,
"responseLength" : 30771,
"millis" : 161,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T13:30:57.666Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("5191d1328ebe6119910371de")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(4150),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(12),
"w" : NumberLong(5)
}
},
"responseLength" : 663,
"millis" : 159,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:02:30.505Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("519298038ebe6119774f58e5")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(20877),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(296401),
"w" : NumberLong(5882393)
}
},
"responseLength" : 979,
"millis" : 154,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:05:04.684Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"$query" : {
"_id" : ObjectId("519432548ebe611977e52950")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(16385),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(8),
"w" : NumberLong(13189086)
}
},
"responseLength" : 989,
"millis" : 154,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:40:21.288Z"),
"op" : "query",
"ns" : "mv_20130513.freereg1_csv_entries",
"query" : {
"$query" : {
"_id" : ObjectId("519204e48ebe61193d18e4dc")
},
"$orderby" : {
"_id" : 1
}
},
"ntoreturn" : 1,
"idhack" : true,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(133574),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(7),
"w" : NumberLong(49)
}
},
"responseLength" : 530,
"millis" : 152,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:41:23.988Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"count" : "search_records",
"query" : {
"record_type" : "ma",
"primary_names" : {
"$elemMatch" : {
"last_name" : "kingston"
}
}
},
"fields" : null
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(138402),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(1),
"w" : NumberLong(4)
}
},
"responseLength" : 48,
"millis" : 138,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T15:51:00.361Z"),
"op" : "query",
"ns" : "mv_20130513.search_records",
"query" : {
"primary_names" : {
"$elemMatch" : {
"last_name" : "laurie"
}
}
},
"cursorid" : NumberLong("2785633126042714121"),
"ntoreturn" : 100,
"ntoskip" : 0,
"nscanned" : 101,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(138411),
"w" : NumberLong(0)
},
"timeAcquiringMicros" : {
"r" : NumberLong(4),
"w" : NumberLong(5)
}
},
"nreturned" : 100,
"responseLength" : 103427,
"millis" : 138,
"client" : "127.0.0.1",
"user" : ""
}
{
"ts" : ISODate("2013-05-18T14:20:02.122Z"),
"op" : "command",
"ns" : "mv_20130513.$cmd",
"command" : {
"create" : "freereg1_csv_entries"
},
"ntoreturn" : 1,
"keyUpdates" : 0,
"numYield" : 0,
"lockStats" : {
"timeLockedMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(131848)
},
"timeAcquiringMicros" : {
"r" : NumberLong(0),
"w" : NumberLong(11231528)
}
},
"responseLength" : 75,
"millis" : 131,
"client" : "127.0.0.1",
"user" : ""
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment