How to learn how to schedule PostgreSQL queries?

Question

PostgreSQL

How to learn to analyze the database well? Namely the part of reading of plans (EXPLAIN SQL) of requests interests.
Those courses on SQL that I see and books that I read do not pay attention to this at all.
Maybe someone knows a good course or book in Russian where this topic is covered?
Preferably for PostgreSQL, but other SQL DBMS will work too.

Answer 1

It happens evolutionarily. As they say, make it run, make it right, make it fast. First you learn how to somehow work with the bases. Then you learn how to design them correctly from the standpoint of ease of use and refinement. Then you learn to design them with performance in mind. At the first stage, the SQL tutorial for beginners helps. At the second stage textbooks on the theory of relational databases. On the third, the documentation of a specific RDBMS and combat experience. One textbook is not enough, years of walking on a rake are needed.
Specifically, about the analysis of the execution plan, there are good articles on Habré - one , two , three , four , five .