| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Roberto Moreda <moreda(at)sanluis(dot)net> |
| Cc: | gpsql-general <pgsql-general(at)hub(dot)org> |
| Subject: | Re: [GENERAL] How to manage processes in the backend? |
| Date: | 1999-08-13 05:05:43 |
| Message-ID: | 199908130505.BAA24503@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Duncan Kinder | 1999-08-13 07:13:09 | Environmental Variables |
| Previous Message | Vadim Mikheev | 1999-08-13 01:33:18 | Re: [GENERAL] v6.5 foreign key trigger reposted with details |