[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