Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Query - Mailing list pgsql-performance

From Greg Smith
Subject Re: Slow Query
Date
Msg-id 4C77F64A.8030102@2ndquadrant.com
Whole thread Raw
In response to Slow Query  ("Ozer, Pam" <pozer@automotive.com>)
Responses Re: Slow Query  ("Ozer, Pam" <pozer@automotive.com>)
List pgsql-performance
Tree view
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@2ndQuadrant.com   www.2ndQuadrant.us

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: turn off caching for performance test
Next
From: "Ozer, Pam"
Date:
Subject: Re: Slow Query