Indexes in PostgreSQL. How to understand what to create

Any developer knows that indexes are a powerful tool that can improve database queries and, as a result, reduce the response of an application or service to external queries.

But Andrew's experience, as a DBA, shows that developers have no understanding of what, when, and for what reasons to create an index. The speaker will give simple and clear examples, which you can easily repeat on your real databases.