Re: Killing a child process

Поиск
Список
Период
Сортировка
От David Stanaway
Тема Re: Killing a child process
Дата
Msg-id 1018933616.1888.30.camel@debian
обсуждение исходный текст
Ответ на Re: Killing a child process  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Mon, 2002-04-15 at 19:28, Tom Lane wrote:
> "Bojan Belovic" <bbelovic@usa.net> 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

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Dan MacNeil"
Дата:
Сообщение: Re: psql command line history not working
Следующее
От: Jean-Arthur Silve
Дата:
Сообщение: Vacuum blocking...