Counting things in Active Record

Seemingly it may seem that counting records in the database with ActiveRecord is straightforward. In reality, it looks more complex as .count, .size, and .length methods are not working the same way. The lack of knowledge about their behavior may lead to performance problems.