Adam,
> > Are there any good rules of thumb of things one should be looking
> out for in
> > EXPLAIN output? ie <blah> means that an index would be good here
> etc
Also try:
1) Various articles on Techdocs.postgresql.org
2) Ewald G.'s PostgreSQL Book
Explain output is not that easily converted into a plan of action ...
otherwise, Postgres would have automated it, neh? You have to get a
feel for what looks good and bad dynamically.
-Josh Berkus