Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Date
Msg-id 29948.1343056156@sss.pgh.pa.us
Whole thread Raw
In response to 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
List pgsql-performance
Tree view 
Jim Vanns <james.vanns@framestore.com> writes:
> We're seeing SELECT statements and even EXPLAIN (no ANAYLZE)
> statements hang indefinitely until *something* (we don't know what)
> releases some kind of resource or no longer becomes a massive bottle
> neck. These are the symptoms.

Does anything show up as blocked in the pg_locks view?

Could you attach to the stuck process with gdb and get a stack trace?

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Shards + hash = forever running queries
Next
From: Jim Vanns
Date:
Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN