In MongoDB’s pymongo, how do I do a count()?

by

Since pymongo version 3.7.0 and above count() is deprecated. Instead use Collection.count_documents. Running cursor.count or collection.count will result in following warning message:

DeprecationWarning: count is deprecated. Use Collection.count_documents instead.

To use count_documents the code can be adjusted as follows

import pymongo

db = pymongo.MongoClient()
col = db[DATABASE][COLLECTION]

find = {"test_set":"abc"}
sort = [("abc",pymongo.DESCENDING)]
skip = 10
limit = 10

doc_count = col.count_documents(find, skip=skip)
results = col.find(find).sort(sort).skip(skip).limit(limit)

for doc in result:
   //Process Document

Note: count_documents method performs relatively slow as compared to count method. In order to optimize you can use collection.estimated_document_count. This method will return estimated number of docs(as the name suggested) based on collection metadata.

Related Contents:

  1. MongoDB vs. Cassandra [closed]
  2. How do you query for “is not null” in Mongo?
  3. How do you rename a MongoDB database?
  4. How to remove a field completely from a MongoDB document?
  5. mongo – couldn’t connect to server 127.0.0.1:27017
  6. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  7. Store images in a MongoDB database
  8. Find duplicate records in MongoDB
  9. How can I tell where mongoDB is storing data? (its not in the default /data/db!)
  10. What is a good choice of database for a small .NET application? [closed]
  11. Is mongodb running?
  12. Where does mongodb stand in the CAP theorem?
  13. Performing regex queries with PyMongo
  14. How to export collection to CSV in MongoDB?
  15. A list of indices in MongoDB?
  16. What are the advantages of using a schema-free database like MongoDB compared to a relational database?
  17. How do I update a Mongo document after inserting it?
  18. Can you specify a key for $addToSet in Mongo?
  19. Mongodb – Difference between running “mongo” and “mongod” databases
  20. In Mongo, how do I pretty-print results so .find() looks like .findOne()
  21. Pros and cons of MongoDB? [closed]
  22. What should I choose: MongoDB/Cassandra/Redis/CouchDB? [closed]
  23. How is the data in a MongoDB database stored on disk?
  24. How to stop insertion of Duplicate documents in a mongodb collection
  25. MongoDB opposite of $addToSet
  26. MongoDB normalization, foreign key and joining
  27. How do I do a “NOT IN” query in Mongo?
  28. Select MongoDB documents where a field either does not exist, is null, or is false?
  29. List all values of a certain field in mongodb
  30. Find all duplicate documents in a MongoDB collection by a key field
  31. Test empty string in mongodb and pymongo
  32. How to get the object id in PyMongo after an insert?
  33. MongoDB vs. Cassandra vs. MySQL for real-time advertising platform
  34. Are MongoDB and CouchDB perfect substitutes?
  35. Create Superuser in mongo
  36. MongoDB update with condition
  37. Get names of all keys in the collection
  38. Node.js Mongoose.js string to ObjectId function
  39. Understanding MongoDB BSON Document size limit
  40. Installing MongoDB with Homebrew
  41. How do I make case-insensitive queries on Mongodb?
  42. Difference between Document-based and Key/Value-based databases?
  43. MongoDB nested lookup with 3 levels
  44. How can I use mongodump to dump out records matching a specific date range?
  45. How to limit number of updating documents in mongodb
  46. What’s the difference between “deletemany” and “remove” in mongodb?
  47. How do I rename fields when performing search/projection in MongoDB?
  48. Duplicate a document in MongoDB using a new _id
  49. Insert a Pandas Dataframe into mongodb using PyMongo
  50. Row count of a column family in Cassandra

Leave a Comment