// @tags: [does_not_support_stepdowns, requires_profiling] // Confirms that profiled aggregation execution contains all expected metrics with proper values. (function() { "use strict"; // For getLatestProfilerEntry and getProfilerProtocolStringForCommand load("jstests/libs/profiler.js"); var testDB = db.getSiblingDB("profile_agg"); assert.commandWorked(testDB.dropDatabase()); var coll = testDB.getCollection("test"); testDB.setProfilingLevel(2); // // Confirm metrics for agg w/ $match. // var i; for (i = 0; i < 10; ++i) { assert.commandWorked(coll.insert({a: i})); } assert.commandWorked(coll.createIndex({a: 1})); assert.eq( 8, coll.aggregate([{$match: {a: {$gte: 2}}}], {collation: {locale: "fr"}, comment: "agg_comment"}) .itcount()); var profileObj = getLatestProfilerEntry(testDB); assert.eq(profileObj.ns, coll.getFullName(), tojson(profileObj)); assert.eq(profileObj.op, "command", tojson(profileObj)); assert.eq(profileObj.nreturned, 8, tojson(profileObj)); assert.eq(profileObj.keysExamined, 8, tojson(profileObj)); assert.eq(profileObj.docsExamined, 8, tojson(profileObj)); assert.eq(profileObj.planSummary, "IXSCAN { a: 1 }", tojson(profileObj)); assert.eq(profileObj.protocol, getProfilerProtocolStringForCommand(testDB.getMongo()), tojson(profileObj)); assert.eq(profileObj.command.aggregate, coll.getName(), tojson(profileObj)); assert.eq(profileObj.command.collation, {locale: "fr"}, tojson(profileObj)); assert.eq(profileObj.command.comment, "agg_comment", tojson(profileObj)); assert(profileObj.hasOwnProperty("responseLength"), tojson(profileObj)); assert(profileObj.hasOwnProperty("millis"), tojson(profileObj)); assert(profileObj.hasOwnProperty("numYield"), tojson(profileObj)); assert(profileObj.hasOwnProperty("locks"), tojson(profileObj)); assert(!profileObj.hasOwnProperty("hasSortStage"), tojson(profileObj)); // Testing that 'usedDisk' is set when disk is used requires either using a lot of data or // configuring a server parameter which could mess up other tests. This testing is // done elsewhere so that this test can stay in the core suite assert(!profileObj.hasOwnProperty("usedDisk"), tojson(profileObj)); assert.eq(profileObj.appName, "MongoDB Shell", tojson(profileObj)); // // Confirm "fromMultiPlanner" metric. // coll.drop(); assert.commandWorked(coll.createIndex({a: 1})); assert.commandWorked(coll.createIndex({b: 1})); for (i = 0; i < 5; ++i) { assert.commandWorked(coll.insert({a: i, b: i})); } assert.eq(1, coll.aggregate([{$match: {a: 3, b: 3}}]).itcount()); profileObj = getLatestProfilerEntry(testDB); assert.eq(profileObj.fromMultiPlanner, true, tojson(profileObj)); // // Confirm that the "hint" modifier is in the profiler document. // coll.drop(); assert.commandWorked(coll.createIndex({a: 1})); for (i = 0; i < 5; ++i) { assert.commandWorked(coll.insert({a: i, b: i})); } assert.eq(1, coll.aggregate([{$match: {a: 3, b: 3}}], {hint: {_id: 1}}).itcount()); profileObj = getLatestProfilerEntry(testDB); assert.eq(profileObj.command.hint, {_id: 1}, tojson(profileObj)); // // Confirm that aggregations are truncated in the profiler as { $truncated: , comment: // } when a comment parameter is provided. // let matchPredicate = {}; for (let i = 0; i < 501; i++) { matchPredicate[i] = "a".repeat(150); } assert.eq(coll.aggregate([{$match: matchPredicate}], {comment: "profile_agg"}).itcount(), 0); profileObj = getLatestProfilerEntry(testDB); assert.eq((typeof profileObj.command.$truncated), "string", tojson(profileObj)); assert.eq(profileObj.command.comment, "profile_agg", tojson(profileObj)); })();