danchann

danchann / mongo_check_size_count_by_date_range.js

Last active January 15, 2019 08:23

Mongo shell queries

	var d = new Date("2019-01-01"); // input required start date here in local timezone
	var days = 31; // input number of days required
	var date = new Date(d.getTime() + (d.getTimezoneOffset() * 60 * 1000)); // adjust utc offset
	var totalSize = 0;
	var totalCount = 0;
	for (var i = 0; i < days; i++) {
	var size = 0, count =0;
	if (date > new Date()) continue; // the input date cannot be greater than today
	var date1 = new Date(date.getFullYear(), date.getMonth(), date.getDate()+1, date.getHours());
	db.getCollection('logs').aggregate([