PostgreSQL Lock Contention Diagnosis

Summary

This skill provides a structured workflow for diagnosing PostgreSQL lock contention, including identifying blocking chains, analysing wait events, and resolving deadlocks. It guides the agent through investigating idle-in-transaction sessions and recommending configuration changes to mitigate lock-related performance issues.