Explain and explain analyze are very powerful tools for understanding query performance. http://www.postgresql.org/docs/9.4/static/using-explain.html http://ww

Explain and explain analyze are very powerful tools for understanding query performance. http://www.postgresql.org/docs/9.4/static/using-explain.html http://www.postgresql.org/docs/9.4/static/using-explain.html (Blog post I wrote) http://jimkeener.com/posts/explain-pg http://jimkeener.com/posts/explain-pg