MongoDB एक्सप्लेन क्वेरी प्लान डिस्प्ले करें

क्वेरी प्लान की जानकारी के लिए explain() का उपयोग करें। पहले कलेक्शन बनाएं:

> db.demo202.insertOne({"StudentFirstName":"Chris","StudentAge":21}); 
{ "acknowledged": true, "insertedId": ObjectId("5e3c3bd103d395bdc21346e8") }
> db.demo202.insertOne({"StudentFirstName":"David","StudentAge":23}); 
{ "acknowledged": true, "insertedId": ObjectId("5e3c3bd803d395bdc21346e9") }
> db.demo202.insertOne({"StudentFirstName":"Bob","StudentAge":22}); 
{ "acknowledged": true, "insertedId": ObjectId("5e3c3bde03d395bdc21346ea") }

सभी डॉक्यूमेंट्स देखें:

> db.demo202.find();

आउटपुट:

{ "_id": ObjectId("5e3c3bd103d395bdc21346e8"), "StudentFirstName": "Chris", "StudentAge": 21 }
{ "_id": ObjectId("5e3c3bd803d395bdc21346e9"), "StudentFirstName": "David", "StudentAge": 23 }
{ "_id": ObjectId("5e3c3bde03d395bdc21346ea"), "StudentFirstName": "Bob", "StudentAge": 22 }

एक्सप्लेन क्वेरी प्लान डिस्प्ले करने की क्वेरी:

> db.demo202.find({"StudentFirstName":"David"}).explain();

परिणाम:

{ "queryPlanner": { "plannerVersion": 1, "namespace": "test.demo202", "indexFilterSet": false, "parsedQuery": { "StudentFirstName": { "$eq": "David" } }, "winningPlan": { "stage": "COLLSCAN", "filter": { "StudentFirstName": { "$eq": "David" } }, "direction": "forward" }, "rejectedPlans": [] }, "serverInfo": { "host": "DESKTOP-QN2RB3H", "port": 27017, "version": "4.0.5", "gitVersion": "3739429dd92b92d1b0ab120911a23d50bf03c412" }, "ok": 1 }