Yes I checked. The connection I inspected is the longest running one.
There was no other connections blocking it. And I also see all locks are
granted for it. Does the planning phase require some internal locks?
在 2014/7/28 0:28, Tom Lane 写道:
> Yeah, that's what the stack trace suggests. Have you looked into pg_locks
> and pg_stat_activity to see which lock it wants and what's holding said
> lock?
>
> regards, tom lane
>
