about EXPLAIN [ANALYZE] statement postgresql.org/docs/9.3/static/sql-explain.html — handy for figuring out which parts of complex queries need optimising.