Re: How to find which query a waiting query waiting for?

From: Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
To: wd <wd(at)wdicc(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to find which query a waiting query waiting for?
Date: 2012-12-07 15:09:24
Message-ID: CAFcNs+or46avACveoS4Q34gZQeH2pFLaxK71mmBfon5bzpC1ig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 7, 2012 at 1:02 PM, wd <wd(at)wdicc(dot)com> wrote:

> 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?
>

Maybe you found what you need here [1].

[1] http://wiki.postgresql.org/wiki/Lock_Monitoring

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-12-07 15:16:06 Re: logs encoding problem Windows
Previous Message hubert depesz lubaczewski 2012-12-07 15:06:02 Re: How to find which query a waiting query waiting for?