Count yer queries!

gistfile1.rb

module QueryTracer
  def self.benchmark(benchmark_name = '')
    count = 0
    duration = 0
    counts = {}
    counts.default = 0

    callback = lambda{|namespace, started, ended, identifier, payload|
      unless 'SCHEMA' == payload[:name]
        duration += (ended - started)
        count += 1
        counts[payload[:name]] += 1
      end
    }

    ActiveSupport::Notifications.subscribed(callback, "sql.active_record") do
      yield.tap do
        puts "#{benchmark_name} count=#{count}, duration=#{duration}, #{counts.inspect}"
      end
    end
  end
end

so usage is just

QueryTracer.benchmark('some name') do
  User.way_too_complicated_action
end

?