Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I know how to do this, thanks.


On Fri, Dec 7, 2012 at 11:09 PM, Fabrízio de Royes Mello <fabriziomello@xxxxxxxxx> wrote:

On Fri, Dec 7, 2012 at 1:02 PM, wd <wd@xxxxxxxxx> 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].


--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux