Sentenças por tempo total: consulta SQL para MySQL

MySQL · SQL

SELECT LEFT(digest_text, 160) AS statement,
       schema_name,
       count_star AS calls,
       ROUND(sum_timer_wait / 1e12, 1) AS total_seconds,
       ROUND(avg_timer_wait / 1e9, 2) AS avg_ms,
       sum_rows_examined AS rows_examined,
       sum_rows_sent AS rows_sent
FROM performance_schema.events_statements_summary_by_digest
WHERE schema_name IS NOT NULL
ORDER BY sum_timer_wait DESC
LIMIT 20

Precisa de algo no servidor: O performance_schema precisa estar ON (é o padrão desde a 5.6).

Esta consulta faz parte do pacote "Saúde do MySQL": conecte o banco no DataRunner e instale o pacote inteiro — consultas, painel e verificações — de uma vez.