Re: [GENERAL] How to manage processes in the backend? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] How to manage processes in the backend?
Date
Msg-id 199908130505.BAA24503@candle.pha.pa.us
Whole thread Raw
In response to How to manage processes in the backend?  (Roberto Moreda <moreda@sanluis.net>)
List pgsql-general
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> How can I obtain information about who is connected?
> How can I see what queries are actually running and what are locking/waiting
> any table?
> How can I remove locks from transactions initiated by died processes?

On most platforms, 'ps' with proper flags will show user, database, and
query type (SELECT,UPDATE, etc).

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Duncan Kinder"
Date:
Subject: Environmental Variables
Next
From: Stuart Rison
Date:
Subject: Re: Select Maximum Question