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
In response to
pgsql-performance by date
|Next:||From: Ozer, Pam||Date: 2010-08-27 17:44:19|
|Subject: Re: Slow Query|
|Previous:||From: Greg Smith||Date: 2010-08-27 17:28:30|
|Subject: Re: turn off caching for performance test|