What tools did you use for learning and optimizing SQL queries in the database?

To study and optimize SQL queries, I used the following tools:

• EXPLAIN and EXPLAIN ANALYZE — help understand the query execution plan and identify bottlenecks.
• pgAdmin — a graphical interface for working with PostgreSQL, including query analysis.
• Profilers and logging — enabled slow query logs to find problematic queries.
• Index testing — added and tested the impact of indexes on speed.

Example of using EXPLAIN ANALYZE:

EXPLAIN ANALYZE SELECT * FROM users WHERE email = 'example@example.com';

This shows how long the query takes and what operations are performed.