Search Postgresql Archives

How to find which query a waiting query waiting for?

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

To: pgsql-general@xxxxxxxxxxxxxx
Subject: How to find which query a waiting query waiting for?
From: wd <wd@xxxxxxxxx>
Date: Fri, 7 Dec 2012 23:02:33 +0800

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?

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

Follow-Ups:
- Re: How to find which query a waiting query waiting for?
  - From: Fabrízio de Royes Mello
- Re: How to find which query a waiting query waiting for?
  - From: hubert depesz lubaczewski

Prev by Date: Re: Backend process is still runs even postmaster got killed
Next by Date: Re: How to find which query a waiting query waiting for?
Previous by thread: Backend process is still runs even postmaster got killed
Next by thread: Re: How to find which query a waiting query waiting for?
Index(es):
- Date
- Thread

[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