Pergunta de entrevista da empresa Digis (Ukraine)

How would you optimize PostgreSQL queries for better performance?