Link to home
Start Free TrialLog in
Avatar of elimesika
elimesikaFlag for Israel

asked on

how to get the deadlock graph in postgres

HI
I would like to know how to get the deadlock graph in postgres when a deadlock occurs.

Thanks
Avatar of earth man2
earth man2
Flag of United Kingdom of Great Britain and Northern Ireland image

select * from pg_locks;
SOLUTION
Avatar of elimesika
elimesika
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of elimesika

ASKER

I have found the solution by myself.