[Mongo DB long queries aggregation] Aggregate for queries running on shards to detect if there are too many or too long queries slowing the system down

MongodbAggregateLongQueries.js

use admin

var threshold = 500;

db.aggregate([
   { $currentOp : { allUsers: true } },
   { $match: { "secs_running" : { $gt: threshold } , "ns" : { $not : /oplog/ } } },
   { $group : { 
       _id: '$shard',
       "n_query": { $sum: 1 },
       "avg_secs_running": { $avg: '$secs_running' }
       ,"operations" : { $push : { "opid" : '$opid' , "secs_running" : '$secs_running' } }
		}
	},
	{ $sort : { "n_query": 1 } }
]).pretty()