Can't say much about 1 & 3. But, pgAdmin[1] has a great visual "explain" tool.

[1] http://www.pgadmin.org/