If your database queries are slow, add observability before you add indexes.
Too often: slow page reported, developer adds an index to the obvious query, nothing improves because the real problem was N+1 queries or lock contention.
Know which queries are actually slow, how often they run, and what the execution plan looks like.
You can't optimize what you can't measure.