1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
// Confirms that profiled delete execution contains all expected metrics with proper values.
(function() {
"use strict";
load("jstests/libs/profiler.js"); // For getLatestProfilerEntry.
// Setup test db and collection.
var testDB = db.getSiblingDB("profile_delete");
assert.commandWorked(testDB.dropDatabase());
var coll = testDB.getCollection("test");
testDB.setProfilingLevel(2);
//
// Confirm metrics for single document delete.
//
var i;
for (i = 0; i < 10; ++i) {
assert.writeOK(coll.insert({a: i, b: i}));
}
assert.commandWorked(coll.createIndex({a: 1}));
assert.writeOK(coll.remove({a: {$gte: 2}, b: {$gte: 2}},
db.getMongo().writeMode() === "commands"
? {justOne: true, collation: {locale: "fr"}}
: {justOne: true}));
var profileObj = getLatestProfilerEntry(testDB);
assert.eq(profileObj.ns, coll.getFullName(), tojson(profileObj));
assert.eq(profileObj.op, "remove", tojson(profileObj));
if (db.getMongo().writeMode() === "commands") {
assert.eq(profileObj.collation, {locale: "fr"}, tojson(profileObj));
}
assert.eq(profileObj.ndeleted, 1, tojson(profileObj));
assert.eq(profileObj.keysExamined, 1, tojson(profileObj));
assert.eq(profileObj.docsExamined, 1, tojson(profileObj));
assert.eq(profileObj.keysDeleted, 2, tojson(profileObj));
assert.eq(profileObj.planSummary, "IXSCAN { a: 1.0 }", tojson(profileObj));
assert(profileObj.execStats.hasOwnProperty("stage"), tojson(profileObj));
assert(profileObj.hasOwnProperty("millis"), tojson(profileObj));
assert(profileObj.hasOwnProperty("numYield"), tojson(profileObj));
assert(profileObj.hasOwnProperty("locks"), tojson(profileObj));
//
// Confirm metrics for multiple document delete.
//
coll.drop();
for (i = 0; i < 10; ++i) {
assert.writeOK(coll.insert({a: i}));
}
assert.writeOK(coll.remove({a: {$gte: 2}}));
profileObj = getLatestProfilerEntry(testDB);
assert.eq(profileObj.ndeleted, 8, tojson(profileObj));
assert.eq(profileObj.keysDeleted, 8, 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.writeOK(coll.insert({a: i, b: i}));
}
assert.writeOK(coll.remove({a: 3, b: 3}));
profileObj = getLatestProfilerEntry(testDB);
assert.eq(profileObj.fromMultiPlanner, true, tojson(profileObj));
})();
|