Re: Slow Query

[Greg Smith <greg@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx   www.2ndQuadrant.us