使用索引建议进行解释

前端之家收集整理的这篇文章主要介绍了使用索引建议进行解释前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
是否有任何(最好是开源)软件可以分析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

猜你在找的Postgre SQL相关文章