Re: How to determine database activity???

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: How to determine database activity???
Дата
Msg-id 200510310205.35769.peter_e@gmx.net
обсуждение исходный текст
Ответ на How to determine database activity???  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Список pgsql-admin
Joost Kraaijeveld wrote:
> Is there a way to actually determine if the database is doing
> anything after a query is send to the backend during *long* lasting
> queries besides waiting and hoping?

strace or ltrace will give you an idea, but I think you will find that
the answer is usually "yes" and you just have to be patient. :)

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Joost Kraaijeveld
Дата:
Сообщение: How to determine database activity???
Следующее
От: adey
Дата:
Сообщение: Re: How to determine database activity???