Security News
JSR Working Group Kicks Off with Ambitious Roadmap and Plans for Open Governance
At its inaugural meeting, the JSR Working Group outlined plans for an open governance model and a roadmap to enhance JavaScript package management.
mongodb-explain-plan-model
Advanced tools
Ampersand model abstraction for MongoDB explain plans (3.0+)
Ampersand model abstraction for MongoDB explain plans.
Parses the JSON output of the explain cursor option in MongoDB, which provides useful information about the query planning and execution stats.
Currently, this model only works on regular queries and not for the Aggregation Framework.
Here is an example with the node.js driver to populate an explain plan model for a given query:
var MongoClient = require('mongodb').MongoClient;
var ExplainPlanModel = require('mongodb-explain-plan-model');
MongoClient.connect('mongodb://localhost:27018/mongodb', function(err, db) {
db.collection('fanclub')
.find({age: {$gte: 33, $lte: 40}})
.explain(function(err2, explain) {
var model = new ExplainPlanModel(explain, {parse: true});
console.log(model.executionSuccess); // ==> true
console.log(model.isCovered); // ==> false
console.log(model.isCollectionScan); // ==> false
console.log(model.usedIndex); // ==> "age_1"
console.log(model.inMemorySort); // ==> false
console.log(model.nReturned); // ==> 191665
console.log(model.executionTimeMillis); // ==> 146
// ...
db.close();
});
});
To access the raw information of any execution stage, you can use the
.findStageByName()
method. This walks the tree of stage (depth-first,
pre-order) and returns the first stage matching the name (or null
if
the stage is not present).
For example, to get information about the
IXSCAN
stage, use:
var ixscan = model.findStageByName('IXSCAN');
if (ixscan) {
console.log('IXSCAN took', ixscan.executionTimeMillisEstimate, 'ms.');
} else {
console.log('no IXSCAN stage found.');
}
This model works best with explain plan output from MongoDB 3.0 and higher,
but it does have a legacy mode and tries to infer the values from older formats.
However, depending on the explain plan, some fields may be null
for older
formats.
If the explain plan is from an older (2.6 or below) version, the legacyMode
flag is set to true.
Apache 2.0
FAQs
Ampersand model abstraction for MongoDB explain plans (3.0+)
The npm package mongodb-explain-plan-model receives a total of 2 weekly downloads. As such, mongodb-explain-plan-model popularity was classified as not popular.
We found that mongodb-explain-plan-model demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 28 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
At its inaugural meeting, the JSR Working Group outlined plans for an open governance model and a roadmap to enhance JavaScript package management.
Security News
Research
An advanced npm supply chain attack is leveraging Ethereum smart contracts for decentralized, persistent malware control, evading traditional defenses.
Security News
Research
Attackers are impersonating Sindre Sorhus on npm with a fake 'chalk-node' package containing a malicious backdoor to compromise developers' projects.