pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Jim C. Nasby <jnasby@pervasive.com>
Cc: Craig A. James <cjames@modgraph-usa.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Some queries starting to hang
Date: Tue, 06 Jun 2006 17:11:14 -0400
Message-ID: <23270.1149628274@sss.pgh.pa.us> (raw)
In-Reply-To: <1149627741.25526.224.camel@state.g2switchworks.com>
References: <1149534308.3583.56.camel@bg002441.pro-unlimited.com>
	<22706.1149538039@sss.pgh.pa.us>
	<20060605203851.GB7071@phlogiston.dyndns.org>
	<23915.1149541591@sss.pgh.pa.us>
	<1149604741.2621.487.camel@localhost.localdomain>
	<17148.1149605005@sss.pgh.pa.us>
	<1149605576.2621.502.camel@localhost.localdomain>
	<17426.1149606369@sss.pgh.pa.us>
	<4485C061.2080206@modgraph-usa.com>
	<1149616467.25526.213.camel@state.g2switchworks.com>
	<20060606205117.GB45331@pervasive.com>
	<1149627741.25526.224.camel@state.g2switchworks.com>

Scott Marlowe <smarlowe@g2switchworks.com> writes:
> The cost of not aborting on the first sort is that you may never see
> what the part of the plan is that's killing your query, since you never
> get the actual plan.

Well, you can get the plan without waiting a long time; that's what
plain EXPLAIN is for.  But I still disagree with the premise that you
can extrapolate anything very useful from an unfinished EXPLAIN ANALYZE
run.  As an example, if the plan involves setup steps such as sorting or
loading a hashtable, cancelling after a minute might make it look like
the setup step is the big problem, distracting you from the possibility
that the *rest* of the plan would take weeks to run if you ever got to
it.

			regards, tom lane



view thread (28+ messages)  latest in thread

Message-ID: <23270.1149628274@sss.pgh.pa.us>
Permalink:  ../23270.1149628274@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/23270.1149628274@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, smarlowe@g2switchworks.com, jnasby@pervasive.com, cjames@modgraph-usa.com
  Subject: Re: Some queries starting to hang
  In-Reply-To: <23270.1149628274@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox