Command metrics
7
Database commands
410.851 ms
Command time
Commands
| # | Time | Database | Info |
|---|---|---|---|
| 1 | 18.890 ms | fpcstat | {"aggregate":"nginx-logs","pipeline":[{"$match":{"time":{"$gte":{"$date":{"$numberLong":"1773792000000"}}}}},{"$group":{"_id":"$website","logCount":{"$count":{}}}}],"cursor":{},"$db":"fpcstat","lsid":{"id":{"$binary":{"base64":"ubXkRkoRRV20RmePVnOLWg==","subType":"04"}}}} |
| 2 | 19.228 ms | fpcstat | {"aggregate":"nginx-logs","pipeline":[{"$match":{"time":{"$gte":{"$date":{"$numberLong":"1773792000000"}}}}},{"$group":{"_id":"$website","logCount":{"$count":{}}}}],"cursor":{},"$db":"fpcstat","lsid":{"id":{"$binary":{"base64":"ubXkRkoRRV20RmePVnOLWg==","subType":"04"}}}} |
| 3 | 21.224 ms | fpcstat | {"aggregate":"site-clicks","pipeline":[{"$match":{"domain":"fpcstat","site":"odchody","isoDate":{"$gte":{"$date":{"$numberLong":"1772597683000"}}}}},{"$group":{"_id":{"day":{"$dateToString":{"format":"%Y-%m-%d","date":"$isoDate"}},"domain":"$domain","site":"$site"},"total":{"$sum":"$counter"}}},{"$sort":{"_id":{"$numberInt":"1"}}}],"cursor":{},"$db":"fpcstat","lsid":{"id":{"$binary":{"base64":"ubXkRkoRRV20RmePVnOLWg==","subType":"04"}}}} |
| 4 | 21.589 ms | fpcstat | {"aggregate":"site-clicks","pipeline":[{"$match":{"domain":"pbsj","site":"departures","isoDate":{"$gte":{"$date":{"$numberLong":"1772597683000"}}}}},{"$group":{"_id":{"day":{"$dateToString":{"format":"%Y-%m-%d","date":"$isoDate"}},"domain":"$domain","site":"$site"},"total":{"$sum":"$counter"}}},{"$sort":{"_id":{"$numberInt":"1"}}}],"cursor":{},"$db":"fpcstat","lsid":{"id":{"$binary":{"base64":"xPFypHD8TRGKbk3+fJoWJw==","subType":"04"}}}} |
| 5 | 126.834 ms | fpcstat | {"aggregate":"nginx-logs","pipeline":[{"$match":{"time":{"$gte":{"$date":{"$numberLong":"1772582400000"}},"$lt":{"$date":{"$numberLong":"1773792000000"}}}}},{"$group":{"_id":{"website":"$website","day":{"$dateToString":{"format":"%Y-%m-%d","date":"$time","timezone":"UTC"}}},"avgResponseTime":{"$avg":{"$toDouble":"$values.request_time"}},"totalBytes":{"$sum":{"$toLong":"$values.bytes_sent"}},"recordCount":{"$sum":{"$numberInt":"1"}}}},{"$sort":{"_id.website":{"$numberInt":"1"},"_id.day":{"$numberInt":"1"}}}],"cursor":{},"$db":"fpcstat","lsid":{"id":{"$binary":{"base64":"ubXkRkoRRV20RmePVnOLWg==","subType":"04"}}}} |
| 6 | 101.326 ms | fpcstat | {"aggregate":"nginx-logs","pipeline":[{"$match":{"time":{"$gte":{"$date":{"$numberLong":"1772582400000"}},"$lt":{"$date":{"$numberLong":"1773792000000"}}}}},{"$group":{"_id":{"website":"$website","day":{"$dateToString":{"format":"%Y-%m-%d","date":"$time","timezone":"UTC"}}},"avgResponseTime":{"$avg":{"$toDouble":"$values.request_time"}},"totalBytes":{"$sum":{"$toLong":"$values.bytes_sent"}},"recordCount":{"$sum":{"$numberInt":"1"}}}},{"$sort":{"_id.website":{"$numberInt":"1"},"_id.day":{"$numberInt":"1"}}}],"cursor":{},"$db":"fpcstat","lsid":{"id":{"$binary":{"base64":"ubXkRkoRRV20RmePVnOLWg==","subType":"04"}}}} |
| 7 | 101.760 ms | fpcstat | {"aggregate":"nginx-logs","pipeline":[{"$match":{"time":{"$gte":{"$date":{"$numberLong":"1772582400000"}},"$lt":{"$date":{"$numberLong":"1773792000000"}}}}},{"$group":{"_id":{"website":"$website","day":{"$dateToString":{"format":"%Y-%m-%d","date":"$time","timezone":"UTC"}}},"avgResponseTime":{"$avg":{"$toDouble":"$values.request_time"}},"totalBytes":{"$sum":{"$toLong":"$values.bytes_sent"}},"recordCount":{"$sum":{"$numberInt":"1"}}}},{"$sort":{"_id.website":{"$numberInt":"1"},"_id.day":{"$numberInt":"1"}}}],"cursor":{},"$db":"fpcstat","lsid":{"id":{"$binary":{"base64":"ubXkRkoRRV20RmePVnOLWg==","subType":"04"}}}} |