ALL ARTICLES
SHARE

ActiveStorage N+1 Queries: has_one_attached & has_many_attached

Christian Paez
Development
3 min read
ActiveStorage N+1 Queries: has_one_attached & has_many_attached

One of the greatest additions to recent versions of Ruby On Rails is the introduction of Active Storage, which helps us manage file uploads for different storage services and handles Active Record associations and migrations out of the box. A common method from the Active Storage module is has_one_attached, used to establish a one to one mapping between a model and a file (a user’s avatar in our example):

When you install and configure Active Storage, a number of database tables and columns will be created. These tables are polymorphic, so when you need to add ActiveStorage to another model in the future, no database migrations are needed. Thus, we do not need to define the avatar column, Active Storage will handle this under the hood by creating a has_one association to a ActiveStorage::Attachment record and a has_one: through: association to an ActiveStorage::Blob record. There is no need to access these associations directly, we can just call the association name to get a user’s avatar. Here’s an example of accessing the AvtiveStorage relationship:

The Problem: ActiveStorage N+1 Queries

A very common feature to implement in an `index` action would be to display a list of resources and their respective avatar:

Looking for Expert Ruby on Rails Development Services?
See how our experts can help you
SCHEDULE A MEETING

The Solution: Eager Loading

When you call methods from within a loop, you should always be aware of N+1 database queries. An N+1 query is one that hits the database in every iteration of your loop. Doing this can cause very poor performance issues and can even result in request timeouts in some cases. The example above contains an N+1 query. This is because user.avatar is an ActiveStorage has_one relationship. Our model (User), will call its ActiveStorage::Attachment (avatar) relationship on every iteration of the loop in this example code.

So, how do we prevent this N+1 query from occurring? The solution to this is to eager load users’ attachments, just like you would do for any ActiveRecord association. ActiveStorage provides the with_attached_x method to accomplish this out of the box:

It is possible to set up a one-to-many relationship between models and files using the `has_many_attached` macro:

N+1 problems related to ActiveStorage can be handled using the with_attached_attachments helper:

The result is that loading images will take just one query, instead of nested database queries occurring within a loop.

Expert Ruby on Rails Development Services

Flatirons is a top-rated Ruby on Rails service provider.

Schedule a Meeting

Get the CEO's Take

Handpicked tech insights and trends from our CEO.

E-mail

Expert Ruby on Rails Development Services

Flatirons is a top-rated Ruby on Rails service provider.

Schedule a Meeting

Get the CEO's Take

Handpicked tech insights and trends from our CEO.

E-mail
Christian Paez
More ideas.
Record Information System (RIS)
Development

Record Information System (RIS) for Healthcare Data Management

Flatirons

Jul 02, 2025
Proof of Concept
Business

Proof of Concept Examples: Validating Ideas in Action

Flatirons

Jun 30, 2025
Javascript Developer
Development

Javascript Developer Salary Insights in the US

Flatirons

Jun 28, 2025
Electron Alternatives
Development

Powerful Electron Alternatives for Cross-Platform App Development

Flatirons

Jun 28, 2025
Why Is Python So Popular
Development

Why Is Python So Popular – Explained for Beginners

Flatirons

Jun 28, 2025
White Label Apps
Business

What is a White Label App?

Flatirons

Jun 28, 2025
Record Information System (RIS)
Development

Record Information System (RIS) for Healthcare Data Management

Flatirons

Jul 02, 2025
Proof of Concept
Business

Proof of Concept Examples: Validating Ideas in Action

Flatirons

Jun 30, 2025
Javascript Developer
Development

Javascript Developer Salary Insights in the US

Flatirons

Jun 28, 2025
Electron Alternatives
Development

Powerful Electron Alternatives for Cross-Platform App Development

Flatirons

Jun 28, 2025
Why Is Python So Popular
Development

Why Is Python So Popular – Explained for Beginners

Flatirons

Jun 28, 2025
White Label Apps
Business

What is a White Label App?

Flatirons

Jun 28, 2025
Record Information System (RIS)
Development

Record Information System (RIS) for Healthcare Data Management

Flatirons

Jul 02, 2025
Proof of Concept
Business

Proof of Concept Examples: Validating Ideas in Action

Flatirons

Jun 30, 2025
Javascript Developer
Development

Javascript Developer Salary Insights in the US

Flatirons

Jun 28, 2025
Electron Alternatives
Development

Powerful Electron Alternatives for Cross-Platform App Development

Flatirons

Jun 28, 2025
Why Is Python So Popular
Development

Why Is Python So Popular – Explained for Beginners

Flatirons

Jun 28, 2025
White Label Apps
Business

What is a White Label App?

Flatirons

Jun 28, 2025
Record Information System (RIS)
Development

Record Information System (RIS) for Healthcare Data Management

Flatirons

Jul 02, 2025
Proof of Concept
Business

Proof of Concept Examples: Validating Ideas in Action

Flatirons

Jun 30, 2025
Javascript Developer
Development

Javascript Developer Salary Insights in the US

Flatirons

Jun 28, 2025
Electron Alternatives
Development

Powerful Electron Alternatives for Cross-Platform App Development

Flatirons

Jun 28, 2025
Why Is Python So Popular
Development

Why Is Python So Popular – Explained for Beginners

Flatirons

Jun 28, 2025
White Label Apps
Business

What is a White Label App?

Flatirons

Jun 28, 2025