mongo-slow-queries
v2.1.0
Published
Utility for identifying slow queries in Mongo
Downloads
25
Maintainers
Readme
mongo-slow-queries
A module for pulling slow queries from Mongo, tagged with metadata as well.
Install
$ npm install mongo-slow-queries
Usage
Initialization
To use mongo-slow-queries
you just need to provide a Mongo DB reference when
creating an instance:
const mongojs = require('mongojs');
const MongoSlowQueryChecker = require('mongo-slow-queries');
let db = mongojs('mongodb://localhost:27017/admin');
let slowQueries = new MongoSlowQueryChecker({ db });
If the db
object has an adminCommand
method, it need not be a reference to
the admin
database.
Querying for slow queries
Querying for slow queries is then as simple as calling get
:
slowQueries.get((err, queries) => {
if (err) {
console.log('Failed to retrieve slow queries: ' + queries);
} else {
console.log('slow queries: ' + JSON.stringify(queries));
}
});
Query duration threshold
By default, mongo-slow-queries
only returns queries that are currently
running that have already taken greater than five seconds to run. If you wish
to use a different threshold value, simply pass it in when you construct the
Mongo slow query checker:
let slowQueries = new MongoSlowQueryChecker({
db,
queryThreshold: 2 // The unit of time is in seconds.
});
Changelog
- 1.0.1 Fix which
query
we fingerprint. - 1.0.0 Initial release.