Re: - Mailing list pgsql-general

From Tom Lane
Subject Re:
Date
Msg-id 19199.1138118327@sss.pgh.pa.us
Whole thread Raw
In response to  (Rick Gigger <rick@alpinenetworking.com>)
List pgsql-general
Rick Gigger <rick@alpinenetworking.com> writes:
> Every once in a while I've noticed the number of processes I've got
> running jumps up a little higher than normal.  So I check it out and
> realize that I'm building up a bunch of processes that just aren't
> completing.  About half of the one's not completing say "SELECT
> waiting".  I'm not doing anything that I am aware of that could be
> blocking anything.  I am only doing regular vacuums.  I am not
> explicitly locking anything that I know of.  Is there a way to figure
> out what each of these processes are waiting on?

Look at the pg_locks view to see what locks they are waiting for and
who's got conflicting locks.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: user defined function
Next
From: Tony Caduto
Date:
Subject: Re: Does this look ethical to you?