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.