N+1 queries
How you'll know: The log shows the same SELECT fired once per row, and the page gets slower every month as records pile up.
Fix: Load associations up front with includes or preload. The Bullet gem flags these in development, and strict_loading (Rails 6.1 and later) makes a lazy load raise instead of passing quietly.
Missing indexes
How you'll know: One query in the log takes most of the request, usually filtering or sorting on a column nobody indexed.
Fix: Run EXPLAIN on it and add the index. On PostgreSQL, build it with algorithm: :concurrently so the table isn't locked while customers are using it.
Callbacks doing real work on every save
How you'll know: Saving one record takes seconds, and a CSV import runs for an hour.
Fix: after_save hooks that send email, recalculate totals or call another API belong in background jobs, through Active Job with Sidekiq or Solid Queue.
Ruby doing what the database should
How you'll know: Code that loads a whole table with .all and then filters, counts or sums it in a loop.
Fix: Push the filter into the query, use pluck for single columns, and add counter caches where a count shows on every page.
Views rendering partials one by one
How you'll know: The database is quick, but view rendering dominates the request time in the log.
Fix: Render lists with render collection: and add fragment caching on the parts that don't change per visitor.