Digis (Ukraine) interview question

How would you optimize PostgreSQL queries for better performance?