Postgres Pro
Downloads
Home   >   mailing lists

How to find which query a waiting query waiting for? - Mailing list pgsql-general

From wd
Subject How to find which query a waiting query waiting for?
Date
Msg-id CABexzmgN+6inTwsHnNZMxGEkFsuamHSSSOrp6VR79oX5GDPdDw@mail.gmail.com
Whole thread Raw
Responses Re: How to find which query a waiting query waiting for?  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: How to find which query a waiting query waiting for?  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Hari Babu
Date:
Subject: Re: Backend process is still runs even postmaster got killed
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: How to find which query a waiting query waiting for?