opsparkwmdb

$./mongo

>use marketdata
>db.system.profile.find({op:"query", ns:"marketdata.minbars"}).sort({ts:-1}).limit(1).pretty()
{ 
    "op" : "query", 
    "ns" : "marketdata.minbars", 
    "query" : {
        "Timestamp" : {
            "$gte" : "2010-07-01", 
            "$lt" : "2010-08-01"
        }
    }, 
	...
            "inputStage" : {
                "stage" : "IXSCAN", 
                "nReturned" : NumberInt(101), 
                "executionTimeMillisEstimate" : NumberInt(0), //rounded to 0 ms...
    			...
                "keyPattern" : {
                    "Timestamp" : NumberInt(1)
                }, 
                "indexName" : "Timestamp_1", 
                "isMultiKey" : false, 
                "direction" : "forward", 
                "indexBounds" : {
                    "Timestamp" : [
                        "[\"2010-07-01\", \"2010-08-01\")"
                    ]
                }, 
                "keysExamined" : NumberInt(101), 
      		…
            }
        }
    }, 
	...
}