Question d’entretien chez Digis (Ukraine)

How would you optimize PostgreSQL queries for better performance?