Re: Odd blocking (or massively latent) issue - even with EXPLAIN

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