Re: help interpreting "explain analyze" output

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: David Rysdam <drysdam(at)ll(dot)mit(dot)edu>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: help interpreting "explain analyze" output
Date: 2013-11-27 16:54:43
Message-ID: 20131127165443.GA19602@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 26, 2013 at 12:24:08PM -0500, David Rysdam wrote:
> I'm not really looking for information on how to speed this query
> up. I'm just trying to interpret the output enough to tell me which step
> is slow:

You might want to read this:
http://www.depesz.com/tag/unexplainable/

Best regards,

depesz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-11-27 18:02:20 Re: nested query vs left join: query planner very confused
Previous Message David Johnston 2013-11-27 16:38:04 Re: Complex sql, limit-for-each group by, arrays, updates