Machiel Richards <machielr@rdc.co.za> writes:
> As part of creating a Daily health check for some postgresql
> databases, I am trying to determine whether the database have any
> deadlocks.
I'm not sure what you're imagining you need to do here. Deadlocks are
not persistent conditions in Postgres --- they're detected and one of
the competing transactions is rolled back to remove the deadlock.
regards, tom lane