How to get totalDocsExamined with explain in pymongo

[Prasad_Saya]

Hello @harris,

In PyMongo, there is only one way to specify the explain on aggregate method - that is via the db.command (that is same as mongo shell’s runCommand). And, there are no option to specify the executionStats and allPlansExecution modes. This is an earlier post discussing the syntax:

Explain on aggregate function with python pymongo

Hello @harris, The explain method on the aggregation pipeline can be used as follows. Note that the command collection.aggregate doesn’t support the explain in PyMongo - you need to use the db.command syntax as shown in the example. agg_pipeline = [ { "$match": { "timestamp1": {"$gte": datetime.strptime("2020-01-01 00:05:00", "%Y-%m-%d %H:%M:%S"), "$lte" :datetime.strptime("2020-01-01 01:05:00", "%Y-%m-%d %H:%M:%S")} } }, { …