Re: Odd blocking (or massively latent) issue - even with EXPLAIN - Mailing list pgsql-performance

From Craig Ringer
Subject Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Date
Msg-id 500DEC9E.90603@ringerc.id.au
Whole thread Raw
In response to Re: Odd blocking (or massively latent) issue - even with EXPLAIN  (Jim Vanns <james.vanns@framestore.com>)
Responses Re: Odd blocking (or massively latent) issue - even with EXPLAIN  (Jim Vanns <james.vanns@framestore.com>)
List pgsql-performance
On 07/23/2012 10:46 PM, Jim Vanns wrote:
> Nothing obvious - and we log a fair amount. No tmp table creations,
> no locks held.
>
> To add to this EXPLAIN reports it took only 0.23ms to run (for example)
> whereas the wall clock time is more like 20-30 minutes (or up to n hours
> as I said where everything appears to click back into place at the same
> time).
How many concurrent connections do you have?

--
Craig Ringer

pgsql-performance by date:

Previous
From: Kenneth Tilton
Date:
Subject: Re: Efficiency of EXISTS?
Next
From: "Martin French"
Date:
Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN