什么是MySQL相当于PostgreSQL的EXPLAIN ANALYZE [英] What is the MySQL equivalent of PostgreSQL's EXPLAIN ANALYZE

问题描述

我想在MySQL中得到一个详细的查询计划，类似于PostgreSQL中的EXPLAIN ANALYZE。是否有等效的？

I'd like to get a detailed query plan in MySQL similar to EXPLAIN ANALYZE shows in PostgreSQL. Is there an equivalent?

推荐答案

编辑：虽然不是直接等同或详细解释分析，查看

While not a direct equivalent or as detailed as Explain Analyze here are some tools that you can look at

mysql提供EXPLAIN和过程分析（）

http://dev.mysql.com/doc/refman/5.0/en/explain.html

http://dev.mysql.com/doc/refman/5.0/en/ procedure-analyse.html

mysql offers EXPLAIN and procedure analyse()
http://dev.mysql.com/doc/refman/5.0/en/explain.html
http://dev.mysql.com/doc/refman/5.0/en/procedure-analyse.html

这篇关于什么是MySQL相当于PostgreSQL的EXPLAIN ANALYZE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！