Waiting for PostgreSQL 20 – Add backend-level lock statistics

This article covers the new per-backend lock statistics feature committed for PostgreSQL 20. It introduces the pg_stat_get_backend_lock() function, which returns lock wait counts, wait times, and fast-path exceeded counts for each backend based on PID. The feature allows DBAs to join this data with pg_stat_activity for live lock behavior analysis. The article includes a practical example showing how to monitor locks across multiple backends, demonstrating the function's output and its usefulness for troubleshooting lock contention in PostgreSQL databases.