On Mon, 2002-04-15 at 19:28, Tom Lane wrote: > "Bojan Belovic" <[EMAIL PROTECTED]> writes: > > Every once in a while I'll spot a query that is taking unusually long time > > to run (a chiled process that keeps the processor at 100% for like 3 > > minutes). Is there a way to see the queries currently executing > > ps, top? Also see the stats views, if you are running 7.2. > > > and/or kill > > a single process without affecting the operation of the server > > kill -INT to a backend will issue a query cancel, which is pretty safe.
There is also pgmonitor (Which I think is in contrib) which shows the stats on the current backend processes (Works on 7.1.3 for me) and is much nicer for working out whats using CPU, and the query that is causing the problem. -- David Stanaway
signature.asc
Description: This is a digitally signed message part
