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
|
// Confirms that profiled geonear 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_geonear");
assert.commandWorked(testDB.dropDatabase());
var conn = testDB.getMongo();
var coll = testDB.getCollection("test");
testDB.setProfilingLevel(2);
//
// Confirm metrics for distinct with query.
//
var i;
for (i = 0; i < 10; ++i) {
assert.writeOK(coll.insert({a: i, loc: {type: "Point", coordinates: [i, i]}}));
}
assert.commandWorked(coll.createIndex({loc: "2dsphere"}));
assert.commandWorked(testDB.runCommand({
geoNear: "test",
near: {type: "Point", coordinates: [1, 1]},
spherical: true,
collation: {locale: "fr"}
}));
var profileObj = getLatestProfilerEntry(testDB);
assert.eq(profileObj.ns, coll.getFullName(), tojson(profileObj));
assert.eq(profileObj.op, "command", tojson(profileObj));
assert.eq(profileObj.keysExamined, 82, tojson(profileObj));
assert.eq(profileObj.docsExamined, 10, tojson(profileObj));
assert.eq(
profileObj.planSummary, "GEO_NEAR_2DSPHERE { loc: \"2dsphere\" }", tojson(profileObj));
assert(profileObj.hasOwnProperty("execStats"), tojson(profileObj));
assert.eq(profileObj.protocol, getProfilerProtocolStringForCommand(conn), tojson(profileObj));
assert.eq(coll.getName(), profileObj.command.geoNear, tojson(profileObj));
assert.eq({locale: "fr"}, profileObj.command.collation, 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.eq(profileObj.appName, "MongoDB Shell", tojson(profileObj));
// We cannot confirm "fromMultiPlanner" or "replanned" metrics as there can be at most one
// valid index choice for geoNear. The reason for this is:
// - geoNear requires at least one "2d" or "2dsphere" index
// - geoNear requires there be at most one 2dsphere and at most one 2d index
// - geoNear will always prefer a 2d index over a 2dsphere index if both are defined
})();
|