Calculate QPS (queries per second) from an Apache log.

qps.sh

#!/bin/bash

#Naive calculation of QPS from Apache Log
#Usage: qps.sh /path/to/logfile

LOG=$1

START=$(head -n 1 $LOG | cut -d ' ' -f 4 | tr -d [)
END=$(tail -n 1 $LOG | cut -d ' ' -f 4 | tr -d [)

LINES=$(cat $LOG | wc -l)

DIFF=$(python -c "import sys,datetime; dt=lambda st: datetime.datetime.strptime(st, '%d/%b/%Y:%H:%M:%S'); print (dt(sys.argv[1]) - dt(sys.argv[2])).seconds" $END $START)

printf "scale=3\n$LINES/$DIFF\n"| bc -l