Thank you all for your help. I will also get the rest of the
information so it will be more clear.
From: Greg Smith [mailto:greg(at)2ndquadrant(dot)com]
Sent: Friday, August 27, 2010 10:31 AM
To: Ozer, Pam
Subject: Re: [PERFORM] Slow Query
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: Scott Marlowe||Date: 2010-08-27 17:57:54|
|Subject: Re: turn off caching for performance test|
|Previous:||From: Greg Smith||Date: 2010-08-27 17:30:50|
|Subject: Re: Slow Query|