How to find which query a waiting query waiting for?

From: wd <wd(at)wdicc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to find which query a waiting query waiting for?
Date: 2012-12-07 15:02:33
Message-ID: CABexzmgN+6inTwsHnNZMxGEkFsuamHSSSOrp6VR79oX5GDPdDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

From pg_stat_activity I can find a query is at waiting state, and from
pg_locks and pg_class can find which relation the query is waiting for, But
how to find witch query is lock the relation?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2012-12-07 15:06:02 Re: How to find which query a waiting query waiting for?
Previous Message Hari Babu 2012-12-07 14:34:49 Re: Backend process is still runs even postmaster got killed