|
Hi Thomas !
Sure,
For the whole aggregation pipeline it is :
{
|
"waitedMS" : NumberLong(0),
|
"stages" : [
|
{
|
"$cursor" : {
|
"query" : {
|
"Counters.Name" : "ClusterManager.Retrieve",
|
"StartTime" : {
|
"$gte" : ISODate("2016-05-03T00:00:00.000+0000"),
|
"$lte" : ISODate("2016-05-10T23:59:59.000+0000")
|
}
|
},
|
"queryPlanner" : {
|
"plannerVersion" : NumberInt(1),
|
"namespace" : "telemetry.sessions",
|
"indexFilterSet" : false,
|
"parsedQuery" : {
|
"$and" : [
|
{
|
"Counters.Name" : {
|
"$eq" : "ClusterManager.Retrieve"
|
}
|
},
|
{
|
"StartTime" : {
|
"$lte" : ISODate("2016-05-10T23:59:59.000+0000")
|
}
|
},
|
{
|
"StartTime" : {
|
"$gte" : ISODate("2016-05-03T00:00:00.000+0000")
|
}
|
}
|
]
|
},
|
"winningPlan" : {
|
"stage" : "CACHED_PLAN",
|
"inputStage" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"Counters.Name" : {
|
"$eq" : "ClusterManager.Retrieve"
|
}
|
},
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"StartTime" : 1.0
|
},
|
"indexName" : "StartTime_1",
|
"isMultiKey" : false,
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : NumberInt(1),
|
"direction" : "forward",
|
"indexBounds" : {
|
"StartTime" : [
|
"[new Date(1462233600000), new Date(1462924799000)]"
|
]
|
}
|
}
|
}
|
},
|
"rejectedPlans" : [
|
|
]
|
}
|
}
|
},
|
{
|
"$unwind" : {
|
"path" : "$Counters"
|
}
|
},
|
{
|
"$match" : {
|
"Counters.Name" : "ClusterManager.Retrieve",
|
"Counters.Size" : {
|
"$gt" : NumberInt(524288000)
|
},
|
"Counters.Time" : {
|
"$gt" : NumberInt(0)
|
}
|
}
|
},
|
{
|
"$project" : {
|
"Username" : true,
|
"Computer" : true,
|
"speed" : {
|
"$divide" : [
|
"$Counters.Size",
|
"$Counters.Time"
|
]
|
}
|
}
|
},
|
{
|
"$group" : {
|
"_id" : {
|
"Username" : "$Username",
|
"Computer" : "$Computer"
|
},
|
"max_speed" : {
|
"$max" : "$speed"
|
}
|
}
|
},
|
{
|
"$match" : {
|
"max_speed" : {
|
"$gt" : NumberInt(11),
|
"$lt" : NumberInt(12)
|
}
|
}
|
}
|
],
|
"ok" : 1.0
|
}
|
For the find command :
{
|
"queryPlanner" : {
|
"plannerVersion" : NumberInt(1),
|
"namespace" : "telemetry.sessions",
|
"indexFilterSet" : false,
|
"parsedQuery" : {
|
"$and" : [
|
{
|
"Counters.Name" : {
|
"$eq" : "ClusterManager.Retrieve"
|
}
|
},
|
{
|
"StartTime" : {
|
"$lte" : ISODate("2016-05-10T23:59:59.000+0000")
|
}
|
},
|
{
|
"StartTime" : {
|
"$gte" : ISODate("2016-05-03T00:00:00.000+0000")
|
}
|
}
|
]
|
},
|
"winningPlan" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"Counters.Name" : {
|
"$eq" : "ClusterManager.Retrieve"
|
}
|
},
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"StartTime" : NumberInt(1)
|
},
|
"indexName" : "StartTime_1",
|
"isMultiKey" : false,
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : NumberInt(1),
|
"direction" : "forward",
|
"indexBounds" : {
|
"StartTime" : [
|
"[new Date(1462233600000), new Date(1462924799000)]"
|
]
|
}
|
}
|
},
|
"rejectedPlans" : [
|
{
|
"stage" : "FETCH",
|
"filter" : {
|
"StartTime" : {
|
"$gte" : ISODate("2016-05-03T00:00:00.000+0000")
|
}
|
},
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"Counters.Name" : NumberInt(1),
|
"StartTime" : NumberInt(1)
|
},
|
"indexName" : "Counters.Name_1_StartTime_1",
|
"isMultiKey" : true,
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : NumberInt(1),
|
"direction" : "forward",
|
"indexBounds" : {
|
"Counters.Name" : [
|
"[\"ClusterManager.Retrieve\", \"ClusterManager.Retrieve\"]"
|
],
|
"StartTime" : [
|
"(true, new Date(1462924799000)]"
|
]
|
}
|
}
|
}
|
]
|
},
|
"executionStats" : {
|
"executionSuccess" : true,
|
"nReturned" : NumberInt(43683),
|
"executionTimeMillis" : NumberInt(7107),
|
"totalKeysExamined" : NumberInt(308232),
|
"totalDocsExamined" : NumberInt(308232),
|
"executionStages" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"Counters.Name" : {
|
"$eq" : "ClusterManager.Retrieve"
|
}
|
},
|
"nReturned" : NumberInt(43683),
|
"executionTimeMillisEstimate" : NumberInt(6660),
|
"works" : NumberInt(308233),
|
"advanced" : NumberInt(43683),
|
"needTime" : NumberInt(264549),
|
"needYield" : NumberInt(0),
|
"saveState" : NumberInt(2413),
|
"restoreState" : NumberInt(2413),
|
"isEOF" : NumberInt(1),
|
"invalidates" : NumberInt(0),
|
"docsExamined" : NumberInt(308232),
|
"alreadyHasObj" : NumberInt(0),
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : NumberInt(308232),
|
"executionTimeMillisEstimate" : NumberInt(170),
|
"works" : NumberInt(308233),
|
"advanced" : NumberInt(308232),
|
"needTime" : NumberInt(0),
|
"needYield" : NumberInt(0),
|
"saveState" : NumberInt(2413),
|
"restoreState" : NumberInt(2413),
|
"isEOF" : NumberInt(1),
|
"invalidates" : NumberInt(0),
|
"keyPattern" : {
|
"StartTime" : NumberInt(1)
|
},
|
"indexName" : "StartTime_1",
|
"isMultiKey" : false,
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : NumberInt(1),
|
"direction" : "forward",
|
"indexBounds" : {
|
"StartTime" : [
|
"[new Date(1462233600000), new Date(1462924799000)]"
|
]
|
},
|
"keysExamined" : NumberInt(308232),
|
"dupsTested" : NumberInt(0),
|
"dupsDropped" : NumberInt(0),
|
"seenInvalidated" : NumberInt(0)
|
}
|
},
|
"allPlansExecution" : [
|
{
|
"nReturned" : NumberInt(0),
|
"executionTimeMillisEstimate" : NumberInt(20),
|
"totalKeysExamined" : NumberInt(578),
|
"totalDocsExamined" : NumberInt(578),
|
"executionStages" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"StartTime" : {
|
"$gte" : ISODate("2016-05-03T00:00:00.000+0000")
|
}
|
},
|
"nReturned" : NumberInt(0),
|
"executionTimeMillisEstimate" : NumberInt(20),
|
"works" : NumberInt(578),
|
"advanced" : NumberInt(0),
|
"needTime" : NumberInt(578),
|
"needYield" : NumberInt(0),
|
"saveState" : NumberInt(2413),
|
"restoreState" : NumberInt(2413),
|
"isEOF" : NumberInt(0),
|
"invalidates" : NumberInt(0),
|
"docsExamined" : NumberInt(578),
|
"alreadyHasObj" : NumberInt(0),
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : NumberInt(578),
|
"executionTimeMillisEstimate" : NumberInt(0),
|
"works" : NumberInt(578),
|
"advanced" : NumberInt(578),
|
"needTime" : NumberInt(0),
|
"needYield" : NumberInt(0),
|
"saveState" : NumberInt(2413),
|
"restoreState" : NumberInt(2413),
|
"isEOF" : NumberInt(0),
|
"invalidates" : NumberInt(0),
|
"keyPattern" : {
|
"Counters.Name" : NumberInt(1),
|
"StartTime" : NumberInt(1)
|
},
|
"indexName" : "Counters.Name_1_StartTime_1",
|
"isMultiKey" : true,
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : NumberInt(1),
|
"direction" : "forward",
|
"indexBounds" : {
|
"Counters.Name" : [
|
"[\"ClusterManager.Retrieve\", \"ClusterManager.Retrieve\"]"
|
],
|
"StartTime" : [
|
"(true, new Date(1462924799000)]"
|
]
|
},
|
"keysExamined" : NumberInt(578),
|
"dupsTested" : NumberInt(578),
|
"dupsDropped" : NumberInt(0),
|
"seenInvalidated" : NumberInt(0)
|
}
|
}
|
},
|
{
|
"nReturned" : NumberInt(101),
|
"executionTimeMillisEstimate" : NumberInt(40),
|
"totalKeysExamined" : NumberInt(578),
|
"totalDocsExamined" : NumberInt(578),
|
"executionStages" : {
|
"stage" : "FETCH",
|
"filter" : {
|
"Counters.Name" : {
|
"$eq" : "ClusterManager.Retrieve"
|
}
|
},
|
"nReturned" : NumberInt(101),
|
"executionTimeMillisEstimate" : NumberInt(40),
|
"works" : NumberInt(578),
|
"advanced" : NumberInt(101),
|
"needTime" : NumberInt(477),
|
"needYield" : NumberInt(0),
|
"saveState" : NumberInt(9),
|
"restoreState" : NumberInt(9),
|
"isEOF" : NumberInt(0),
|
"invalidates" : NumberInt(0),
|
"docsExamined" : NumberInt(578),
|
"alreadyHasObj" : NumberInt(0),
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : NumberInt(578),
|
"executionTimeMillisEstimate" : NumberInt(0),
|
"works" : NumberInt(578),
|
"advanced" : NumberInt(578),
|
"needTime" : NumberInt(0),
|
"needYield" : NumberInt(0),
|
"saveState" : NumberInt(9),
|
"restoreState" : NumberInt(9),
|
"isEOF" : NumberInt(0),
|
"invalidates" : NumberInt(0),
|
"keyPattern" : {
|
"StartTime" : NumberInt(1)
|
},
|
"indexName" : "StartTime_1",
|
"isMultiKey" : false,
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : NumberInt(1),
|
"direction" : "forward",
|
"indexBounds" : {
|
"StartTime" : [
|
"[new Date(1462233600000), new Date(1462924799000)]"
|
]
|
},
|
"keysExamined" : NumberInt(578),
|
"dupsTested" : NumberInt(0),
|
"dupsDropped" : NumberInt(0),
|
"seenInvalidated" : NumberInt(0)
|
}
|
}
|
}
|
]
|
},
|
"serverInfo" : {
|
"host" : "telemetry-mongodb-3",
|
"port" : NumberInt(27017),
|
"version" : "3.2.10",
|
"gitVersion" : "79d9b3ab5ce20f51c272b4411202710a082d0317"
|
},
|
"ok" : NumberInt(1)
|
}
|
Let me know if you need anything else
|