使用索引建议进行解释

概述是否有任何(最好是开源)软件可以分析PostgreSQL EXPLAIN,并推荐必要的索引,以加快查询速度？ 我几乎在几分钟之前就发现了这个： http://explain.depesz.com/.你粘贴了EXPLAIN ANALYZE的结果,它会显示可能存在问题的地方(它甚至是彩色编码的). 从帮助部分… explain.depesz.com is tool for finding real c 是否有任何(最好是开源)软件可以分析Postgresql EXPLAIN,并推荐必要的索引,以加快查询速度？ 我几乎在几分钟之前就发现了这个： http://explain.depesz.com/.你粘贴了EXPLAIN ANALYZE的结果,它会显示可能存在问题的地方(它甚至是彩色编码的).

从帮助部分…

explain.depesz.com is tool for finding real cause for slow querIEs. Generally,one would use EXPLAIN ANALYZE query; and read the output. The problem is that not all parts of the output are easily understandable by anybody,and it’s not always obvIoUs whether node that executes in 17.3ms is faster or slower than the one that runs in 100ms – given the fact that the first one is executed 7 times. To use the site,simply go to its first page and paste there explain analyze output from your psql. This output Could look like this. After uploading you will be directed to page which shows parsed,and nicely (well,at least nice for me 总结

以上是内存溢出为你收集整理的使用索引建议进行解释全部内容，希望文章能够帮你解决使用索引建议进行解释所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

欢迎分享，转载请注明来源：内存溢出

原文地址: http://outofmemory.cn/sjk/1168875.html