Pregunta de entrevista de Digis (Ukraine)

How would you optimize PostgreSQL queries for better performance?