git_queue_times.js

total = count = max = 0;
min = 999;
lastWeek = new Date('2014-05-07');
db.git_queue.find({status: {$ne: 'error'}, notified_build: {$ne: null}, finished_build: {$ne: null}}).forEach(function(el) {
	if (new Date(el.notified_build) > lastWeek) {
		total_ms = new Date(el.finished_build) - new Date(el.notified_build);
		total_secs = total_ms / 1000;
		total_mins = total_secs / 60;
		count++;
		total += total_mins;
		max = Math.max(max, total_mins);
		min = Math.min(min, total_mins);
	}
});
print("AVG: " + total / count + "\nMAX: " + max + "\nMIN: " + min);

Here are the results for the last week:

> db.git_queue.find({status: {$ne: 'error'}, notified_build: {$ne: null}, finished_build: {$ne: null}}).forEach(function(el) {
... if (new Date(el.notified_build) > lastWeek) {
... total_ms = new Date(el.finished_build) - new Date(el.notified_build);
... total_secs = total_ms / 1000;
... total_mins = total_secs / 60;
... count++;
... total += total_mins;
... max = Math.max(max, total_mins);
... min = Math.min(min, total_mins);
... }
... });
> print("AVG: " + total / count + "\nMAX: " + max + "\nMIN: " + min);
AVG: 2.7350282485875708
MAX: 8.166666666666666
MIN: 0.8166666666666667