Find slowest queries

from the Artful MySQL Tips List


Performance_schema must be enabled.

SELECT 
  digest_text, count_star, first_seen, last_seen
  avg_timer_wait/1024/1024/1024/1024 as avg_wait_secs
FROM performance_schema.events_statements_summary_by_digest 
ORDER BY avg_timer_wait DESC
LIMIT 10;




Return to the Artful MySQL Tips page