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.

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

We build reliable cloud solutions with Infrastructure as code
We are experts in security, Linux and databases
We support your dev team to perform

Understanding database Indexes in PostgreSQL

Warning

Do you need DevOps-experts?