Skip to content

Instantly share code, notes, and snippets.

@mewben
Forked from Stoffo/remove_documents_mongodb.js
Created February 13, 2019 13:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mewben/5f96138d7f4364bd67ad187d59b49b73 to your computer and use it in GitHub Desktop.
Save mewben/5f96138d7f4364bd67ad187d59b49b73 to your computer and use it in GitHub Desktop.
Remove Documents older than x days in MongoDB
var date = new Date();
var daysToDeletion = 120;
var deletionDate = new Date(date.setDate(date.getDate() - daysToDeletion));
printjson(deletionDate);
var db = db.getSiblingDB('db')
db.getMongo().setSlaveOk();
printjson(db.messages.find({insertDate : {$lt : deletionDate}}).count());
//delete old Messages:
db.messages.remove({insertDate : {$lt : deletionDate}});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment