How to manage processes in the backend?

Started by Roberto Moredaover 26 years ago2 messagesgeneral

moreda@sanluis.net

over 26 years ago

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?

Thanks a lot

Roberto

--
Roberto Moreda
Resp. Dpto. Informï¿½tica Handem/San Luis
Tlf +34 981 779000
Fax +34 981 779022
Pol. Piadela Sur, Autovï¿½a A6 Sal.567
15300 Betanzos (A Coruï¿½a) - Espaï¿½a

Bruce Momjian

bruce@momjian.us

over 26 years ago

In reply to: Roberto Moreda (#1)

Re: [GENERAL] How to manage processes in the backend?

[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