Thoughts, Tips, and Examples for Web Developers, HTML, CSS, PHP, PostgreSQL
Saturday, March 6, 2010
EXPLAIN ANALYZE is Your Friend
EXPLAIN ANALYZE is a useful tool to help see what query plan the planner creates for any query. One tool that I have found useful for some time is depesz's online tool, http://explain.depesz.com/. Simply "paste your explain analyze plan, and see the output."