SELECT CAST(event_data AS XML) FROM sys.fn_xe_telemetry_blob_target_read_file('system_health*.xel', NULL, NULL, NULL)
WHERE object_name = 'xml_deadlock_report';
Drop an .xdl / .xml deadlock report from SSMS or Extended Events system_health.
PostgreSQL Log Excerpt
-- Copy from postgresql.log starting at:
-- ERROR: deadlock detected
-- DETAIL: Process ... waits for ShareLock on transaction ...
Include the ERROR, DETAIL, HINT, and STATEMENT lines from your PostgreSQL server log.
MySQL / MariaDB InnoDB Status
SHOW ENGINE INNODB STATUS;
Paste either the full InnoDB monitor output or the LATEST DETECTED DEADLOCK section.