Can also warmly recommend the EXPLAIN visualizations generated by pgAdmin: http://www.pgadmin.org/

See an (simple) example here: http://www.pgadmin.org/images/screenshots/pgadmin3_macosx.pn...