Slowest sql query filter from rails logs

# Usage:
# cat <environment>.log | grep Load | grep SELECT | ruby filter.rb

MAX_TIME = 300.0

h = {}

STDIN.read.split("\n").each do |line|
  list = line.split('  ')
  time = list[2].scan(/\((.*)\./).flatten[0].to_f
  h[list[3]] = time
end

h.sort_by{ |query, time| time }.reverse.select{ |query, time| time > MAX_TIME }.each do |query, time|
  puts "#{time} - #{query}"
  puts
end