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
| db.TBL.find({phone: {$regex: "138*"}}).explain() { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "Examle.TBL", "indexFilterSet" : false, "parsedQuery" : { "phone" : { "$regex" : "138*" } }, "queryHash" : "1722BD8D", "planCacheKey" : "E07652F2", "winningPlan" : { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "phone" : { "$regex" : "138*" } }, "keyPattern" : { "phone" : 1 }, "indexName" : "phone_1", "isMultiKey" : false, "multiKeyPaths" : { "phone" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "phone" : [ "[\"\", {})", "[/138*/, /138*/]" ] } } }, "rejectedPlans" : [ ] }, "serverInfo" : { "host" : "test-server", "port" : 27017, "version" : "4.2.15", "gitVersion" : "d7fd78dead621a539c20791a93abec34bb1be385" }, "ok" : 1 }
|