Soapower - useful query

gistfile1.js

// Count request per environment
db.requestData.aggregate( [ { $group : { _id : "$environmentName", count: { $sum: 1 } } } ] );

// Count all services
db.environments.aggregate( 
  [ 
    { $unwind : "$services" }, 
    { $group : { _id : null, number : { $sum : 1 } } } 
  ] 
);

// Count all services per environment
db.environments.aggregate( 
  [ 
    { $unwind : "$services" }, 
    { $group : { _id : "$name", number : { $sum : 1 } } },
    { $sort: { "_id": 1 } }
  ] 
);

// Size in MB of requestData collection
db.requestData.stats(1024*1024).size