我几乎在几分钟之前就发现了这个：
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 原文链接：https://www.f2er.com/postgresql/192526.html
