How to delete N numbers of documents in mongodb

by

You can’t set a limit when using remove or findAndModify. So, if you want to precisely limit the number of documents removed, you’ll need to do it in two steps. 

db.collectionName.find({}, {_id : 1})
    .limit(100)
    .sort({timestamp:-1})
    .toArray()
    .map(function(doc) { return doc._id; });  // Pull out just the _ids

Then pass the returned _ids to the remove method:

db.collectionName.remove({_id: {$in: removeIdsArray}})

FYI: you cannot remove documents from a capped collection.

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Authentication failure while trying to save to mongodb
  3. How to change the type of a field?
  4. MongoDB logging all queries
  5. Querying internal array size in MongoDB
  6. Unhandled promise rejection: Error: URL malformed, cannot be parsed
  7. How to query MongoDB to test if an item exists?
  8. Find duplicate records in MongoDB
  9. Working with special characters in a Mongo collection
  10. How to return Mongoose results from the find method?
  11. MongoDB: output ‘id’ instead of ‘_id’
  12. MongoDB: Updating subdocument
  13. MongoDB: Calculate dwell time between every status value change
  14. How to export all collections in MongoDB?
  15. How to ignore nulls while unmarshalling a MongoDB document?
  16. How to use mongoimport to import CSV files?
  17. Remove Duplicates from MongoDB
  18. Spring data MongoDb: MappingMongoConverter remove _class
  19. How to access overall document count during arithmetic aggregation expression
  20. How to find min value in mongodb
  21. Does MongoDB support floating point types?
  22. How to deal with the timezone issue when storing dates in utc using mongod?
  23. Sum in nested document MongoDB
  24. MongoDB.service failed with result exit-code
  25. How can I sort a Meteor collection by time of insertion?
  26. MongoDB index/RAM relationship
  27. How to do pagination using range queries in MongoDB?
  28. Export mongodb aggregation framework result to a new collection
  29. MongoDB aggregate by field exists
  30. MongoDB {aggregation $match} vs {find} speed

Leave a Comment