Re: Finding deadlocks on postgresql ? - Mailing list pgsql-novice

From Edi Stojicevic
Subject Re: Finding deadlocks on postgresql ?
Date
Msg-id 20100813123623.GA32062@kayo
Whole thread Raw
In response to Finding deadlocks on postgresql ?  (Machiel Richards <machielr@rdc.co.za>)
List pgsql-novice
* Machiel Richards <machielr@rdc.co.za> [2010-08-13 11:36:47 +0200] wrote :

> 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

Hi,

Is there a thing I found in the archives :

http://archives.postgresql.org/pgsql-admin/2006-08/msg00248.php

Regards,
--
 .''`.  Edi Stojicevic
: :'  : Debian GNU/Linux user, admin & developer - http://www.debian.org
`. `~'
  `-
AUTHOR
FvwmAuto just appeared one day, nobody knows how.
        -- FvwmAuto(1x)

pgsql-novice by date:

Previous
From: Machiel Richards
Date:
Subject: Finding deadlocks on postgresql ?
Next
From: Tom Lane
Date:
Subject: Re: Finding deadlocks on postgresql ?