locking/waiting queries

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: locking/waiting queries
Date: 2009-08-20 19:18:26
Message-ID: 200908201318.26976.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all ;

were seeing a backlog of queries in pg_stat_activity. The system has slowed
big time.

I see many many queries where waiting = 't'

I want to find out for each query which query they are waiting on (who's doing
the blocking).

What's the best way to find this, I looked at pg_locks for rows where granted =
'f' but its not helping me determine which query is doing the blocking.

Thanks in advance...

Browse pgsql-general by date

  From Date Subject
Next Message Vikram Patil 2009-08-20 20:19:30 Regarding installing & starting Postgres on Windows
Previous Message Alvaro Herrera 2009-08-20 18:31:02 Re: "ownership" of sequences, pseudo random unique id