Search code examples
mongodbaggregation-frameworkpymongoexplain

pymongo aggregate don't allow explain option

I succesfully run:

result = my_col.aggregate(my_pipeline, allowDiskUse=True)

Now when I try:

result = my_col.aggregate(my_pipeline, allowDiskUse=True, explain=True)

it fails saying:

pymongo.errors.ConfigurationError: The explain option is not supported. Use Database.command instead.

Thus I try so as to add the needed option:

result = mydb.command('aggregate', 'mycol', my_pipeline, {'explain':True})

but it fails saying:

pymongo.errors.OperationFailure: 'pipeline' option must be specified as an array

What is wrong?

Thanks for any advice.

Christian

Solution

  • Pass your pipeline using the "pipeline" keyword argument to "command":

    db.command('aggregate', 'mycol', pipeline=my_pipeline, explain=True)

    For example:

    db.command('aggregate', 'mycol', pipeline=[{'$project': {'name': '$field'}}], explain=True)