Ozer, Pam wrote:
>
> I am new to Postgres and I am trying to understand the Explain Analyze
> so I can tune the following query.
>
You should try http://explain.depesz.com/ , where you can post query
plans like this and see where the time is going in a very easy to work
with form. It will highlight row estimation mistakes for you too.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us