How to Use Count in Rails: Syntax and Examples

In Rails, you use the count method on ActiveRecord models or relations to get the number of records. For example, User.count returns the total number of users in the database.

Syntax

The count method can be called on an ActiveRecord model or a relation to return the number of matching records.

• Model.count: Returns total records in the model's table.
• Model.where(condition).count: Returns count of records matching the condition.
• relation.count(:column): Counts non-null values in the specified column.

ruby

User.count
User.where(active: true).count
User.count(:email)

Example

This example shows how to count all users and how to count only active users using the count method.

ruby

class User < ApplicationRecord
end

# Count all users
all_users = User.count

# Count only active users
active_users = User.where(active: true).count

puts "Total users: #{all_users}"
puts "Active users: #{active_users}"

Output

Total users: 42
Active users: 30

Common Pitfalls

One common mistake is using size or length instead of count. count runs a SQL COUNT query, which is efficient. size or length may load all records into memory, which is slower for large datasets.

Also, calling count on an array (not a relation) counts elements in memory, not in the database.

ruby

# Inefficient: loads all records
users = User.all
puts users.length  # loads all users into memory

# Efficient: runs SQL COUNT query
puts User.count

# Wrong: counting on array, not relation
users_array = User.where(active: true).to_a
puts users_array.count  # counts array elements in memory

Quick Reference

Usage	Description
Model.count	Returns total number of records in the table
Model.where(condition).count	Returns count of records matching condition
relation.count(:column)	Counts non-null values in specified column
array.count	Counts elements in Ruby array, not database

Key Takeaways

Use count on ActiveRecord models or relations to get record counts efficiently.

count runs a SQL COUNT query, avoiding loading all records into memory.

Avoid using length or size on relations for counting large datasets.

Calling count on arrays counts elements in memory, not in the database.

Use where with count to count records matching specific conditions.