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 Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

• Prevents you from data breaches and liability risks
• Upgrade at your own pace
• Works with modern Rubies

Read more Show archive.org snapshot