A zero-configuration gem to count the number of SQL queries performed by the ActiveRecord. Supports Rails 4.2 and Ruby 2.0 (the complete testing matrix is here).

Add this line to your application's Gemfile:

gem 'query_count'

Run bundle install.

The gem will automatically include the number of SQL queries to the default Rails log.

ActiveRecord: 34.0ms | SQL Queries: 8 (1 cached)

This log example shows that the total number of queries was 8, and 1 was cached, which means the request hit the database 7 times.

QueryCount::Counter provides public methods counter, counter_cache, reset_counter, reset_counter_cache.

RSpec 3 example:

it 'performs exactly 5 queries' do
  QueryCount::Counter.reset_counter
  5.times { User.last }
  expect(QueryCount::Counter.counter).to eq 5
end

query_count © Dmitriy Tarasov. Released under the MIT license.