profiling - How to search MongoDB-Documents on different nesting levels? -

-

i'm analyzing system.profile-collection of mongodb-database. i'd find queries have stage collscan oder ixscan. problem is, field stage can occur on several levels (...: shortened json):

{     "op" : "query",     "ns" : "spt.coll",     "query" : {         "user" : "userc"     },     "ntoreturn" : 1,     ...     "millis" : 0,     "execstats" : {         "stage" : "projection",         "nreturned" : 1,         ...         "transformby" : {             "settings.arr" : 1         },         "inputstage" : {             "stage" : "fetch",             "nreturned" : 1,             ...             "alreadyhasobj" : 0,             "inputstage" : {                 "stage" : "ixscan",                 "nreturned" : 1,                 ...                 "matchtested" : 0             }         }     },     "ts" : isodate("2015-07-30t09:16:22.551z"),     "client" : "127.0.0.1",     "allusers" : [ ],     "user" : "" }

in above example stage occurs on 3 levels:

  1. "execstats.stage"
  2. "execstats.inputstage.stage"
  3. "execstats.inputstage.inputstage.stage"

there might deeper nested stages. is there way return documents, have stage: "ixscan" oder stage: "collscan" on of nesting levels? or have run query each nesting level?

i tried use following function referring how find mongodb field name @ arbitrary depth , unfortunately gives error:

db.system.profile.find(   function () {     var findkey = "stage",         findval = "collscan";      function inspectobj(doc) {       return object.keys(doc).some(function(key) {         if ( typeof(doc[key]) == "object" ) {           return inspectobj(doc[key]);         } else {           return ( key == findkey && doc[key] == findval );         }       });     }     return inspectobj(this);   } )

error-message:

error: error: {     "$err" : "typeerror: object.keys called on non-object\n    @ function.keys (native)\n    @ inspectobj (_funcs1:6:25)\n    @ _funcs1:8:22\n    @ array.some (native)\n    @ inspectobj (_funcs1:6:35)\n    @ _funcs1:8:22\n    @ array.some (native)\n    @ inspectobj (_funcs1:6:35)\n    @ _funcs1 (_funcs1:14:16) near 'rn object.keys(doc).some(function(key) '  (line 6)",     "code" : 16722 }

to reproduce above json, use following code:

use spt  db.coll.drop()  db.coll.insert([   {settings: {arr: ["a", "b"]}, user: "usera"},   {settings: {arr: ["c", "d"]}, user: "userb"},   {settings: {arr: ["e", "f"]}, user: "userc"},   {settings: {arr: ["g", "g"]}, user: "userd"}, ])  db.coll.ensureindex({user: 1})  db.setprofilinglevel(0) db.system.profile.drop() db.setprofilinglevel(2)   db.coll.find({user: "userc"}, {"settings.arr": 1}).limit(1).pretty() db.system.profile.find().pretty()

the error mention thrown object.keys when object not enumerable. easy way catch , ignore error:

db.system.profile.find(   // returns documents, function returns true.   function () {     var findkey = "stage",         findval = "collscan";      function inspectobj(doc) {       // object.keys(doc) works enumerables (arrays , documents)       // https://developer.mozilla.org/en-us/docs/web/javascript/reference/global_objects/object/keys       // incoming object might e.g. `isodate("2015-07-29t08:20:42.768z")`       // need catch (and ignore) typeerrors thrown object.keys()       var contains = false;       try {             contains = object.keys(doc).some(function(key) {               cval = doc[key];               if ( typeof(cval) == "object" ) {                 // recursive call if value object.                 return inspectobj(doc[key]);               } else {                 return ( key == findkey && doc[key] == findval );               }             });       } catch(typeerror) {         // ignore typeerror       }       return contains;     }      return inspectobj(this);   }, {op: 1, ns:1, query: 1} )

Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more