Quick bucketing of PG logs

bucket.rb

#!/usr/bin/env ruby

outputs = {}
STDIN.each_line do |line|
  data = line.gsub(';', '').split(' ')
  outputs[data[1].to_i] = [] unless outputs[data[1].to_i]
  outputs[data[1].to_i] << data[0].to_f
end

outputs.keys.sort.each do |k|
  v = outputs[k]
  puts k
  puts "  Min: #{v.min}"
  puts "  Avg: #{v.inject{ |sum, el| sum + el }.to_f / v.size}"
  puts "  Max: #{v.max}"
end

command

cat pglog_oldskool | grep "SELECT \* " | cut -d " " -f 7,30 | ./bucket.rb