This new advanced mode feature helps identify blocking and waiting sessions responsible for database lock contention, which can hinder performance. Through visual relationship graphs and session details, database administrators can quickly pinpoint dominant queries or objects causing contention.
Historical lock contention data persists for 15 months, enabling trend analysis and retrospective diagnostics without needing custom query scripts or log examinations. Available across all AWS Regions, this capability streamlines troubleshooting for PostgreSQL workloads hosted on RDS, though external validation regarding detection accuracy and operational benefits has not been independently reported.
Source & further reading
Amazon CloudWatch now provides lock contention diagnostics for Amazon RDS for PostgreSQL ↗Source published 2026-02-26. This report was prepared with AI assistance from the linked primary-source material. Claims and limitations should be checked against the original announcement or research.