Understanding database Indexes in PostgreSQL

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.