Finding deadlocks on postgresql ?

Поиск
Список
Период
Сортировка
От Machiel Richards
Тема Finding deadlocks on postgresql ?
Дата
Msg-id 1281692207.1874.37.camel@machielr-laptop
обсуждение исходный текст
Ответы Re: Finding deadlocks on postgresql ?  (Edi Stojicevic <estojicevic@debianworld.org>)
Re: Finding deadlocks on postgresql ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi All

       I am trying to find out the following and google doesn't seem to be very helpful today :-(

         As part of creating a Daily health check for  some postgresql databases, I am trying to determine whether the database have any deadlocks.

          I am not sure however how to do this and thus I am hoping someone can assist me here.


        Is there a method to check postgresql for any deadlocks via a query or perhaps other methods?

    I would really appreciate the help here.

Regards
Machiel

Вложения

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Installation problem (RH5, x86-64, Postgresql 8.4.4)
Следующее
От: Edi Stojicevic
Дата:
Сообщение: Re: Finding deadlocks on postgresql ?