Query Count

Rails 7.2 introduced built-in query counting functionality, making this gem redundant for Rails 7.2 and newer.

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.