Re: Killing a child process

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Killing a child process
Дата
Msg-id 7605.1018916938@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Killing a child process  ("Bojan Belovic" <bbelovic@usa.net>)
Ответы Re: Killing a child process  (David Stanaway <david@stanaway.net>)
Список pgsql-admin
"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.

            regards, tom lane

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

Предыдущее
От: "Bojan Belovic"
Дата:
Сообщение: Killing a child process
Следующее
От: Brian McCane
Дата:
Сообщение: Re: Query planner quirk?