I found the linked article very helpful to refresh my understanding of database indexes. As a small bonus, it includes a few helpful SQL oneliners like these two:

• Detecting unused indexes Show archive.org snapshot
• Detecting duplicate indexes Show archive.org snapshot

Warning

Do not run random code snippets unless you understand them in detail - especially in production.

Rails professionals since 2007

Our laser focus on a single technology has made us a leader in this space. Need help?

• We build a solid first version of your product
• We train your development team
• We rescue your project in trouble

Read more Show archive.org snapshot