Milliseid tööriistu kasutasite SQL-päringute jõudluse analüüsimiseks?

To analyze SQL query performance, I often use the following tools:

• EXPLAIN / EXPLAIN ANALYZE — allows you to see the execution plan of a query, understand which indexes are used, and where full table scans occur.
• pg_stat_statements (for PostgreSQL) — collects statistics on query execution, helps identify the 'heaviest' queries.
• Database profilers — for example, SQL Server Profiler, MySQL Performance Schema.
• Built-in monitoring tools in the DBMS, such as Query Store in SQL Server.
• External tools: pgBadger, Percona Toolkit, which analyze logs and provide performance reports.

In Go projects, you can also log query durations and metrics using Prometheus for real-time monitoring.