| From: | "Ozer, Pam" <pozer(at)automotive(dot)com> |
|---|---|
| To: | "Greg Smith" <greg(at)2ndquadrant(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Slow Query |
| Date: | 2010-08-27 17:44:19 |
| Message-ID: | C3CA20D47A2DF94FBF9CF0AE8D964CC412438E@mail-001.corp.automotive.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
Cc: pgsql-performance(at)postgresql(dot)org
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
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-08-27 17:57:54 | Re: turn off caching for performance test |
| Previous Message | Greg Smith | 2010-08-27 17:30:50 | Re: Slow Query |