N+1 detection tools in Ruby on Rails

Introduction

N+1 detection tools help find slow database queries caused by loading data inefficiently. They show where your app asks the database too many times instead of once.

When your web page loads slowly and you suspect database queries are the cause.

When you want to improve app performance by reducing repeated database calls.

When you add new features that fetch related data and want to avoid extra queries.

When reviewing code to ensure it follows best practices for database access.

Syntax

Ruby on Rails

gem 'bullet'

# In config/environments/development.rb
Rails.application.configure do
  config.after_initialize do
    Bullet.enable = true
    Bullet.alert = true
    Bullet.bullet_logger = true
    Bullet.console = true
    Bullet.rails_logger = true
  end
end

Bullet is a popular gem to detect N+1 queries in Rails apps.

Enable Bullet only in development to avoid slowing production.

Examples

This enables Bullet and shows browser alerts when N+1 queries happen.

Ruby on Rails

Bullet.enable = true
Bullet.alert = true

This logs N+1 warnings to a file and the browser console for easier debugging.

Ruby on Rails

Bullet.bullet_logger = true
Bullet.console = true

This adds N+1 warnings to the Rails server log.

Ruby on Rails

Bullet.rails_logger = true

Sample Program

This setup uses Bullet to detect N+1 queries when loading posts and their comments without eager loading.

Bullet will alert you in the browser and logs about the N+1 problem caused by calling post.comments.count inside the loop.

Ruby on Rails

# Gemfile
gem 'bullet'

# config/environments/development.rb
Rails.application.configure do
  config.after_initialize do
    Bullet.enable = true
    Bullet.alert = true
    Bullet.bullet_logger = true
    Bullet.console = true
    Bullet.rails_logger = true
  end
end

# app/controllers/posts_controller.rb
class PostsController < ApplicationController
  def index
    @posts = Post.all
  end
end

# app/views/posts/index.html.erb
<% @posts.each do |post| %>
  <p><%= post.title %></p>
  <p><%= post.comments.count %></p> <!-- This triggers N+1 if comments not eager loaded -->
<% end %>

Important Notes

Always fix N+1 warnings by eager loading related data using includes or preload.

Bullet can also detect unused eager loading to keep queries efficient.

Use Bullet only in development to avoid performance impact in production.

Summary

N+1 detection tools find repeated database queries that slow your app.

Bullet gem is a common tool in Rails to catch these problems early.

Fixing N+1 issues improves app speed and user experience.