JusDB
Free DB Audit

The JusDB Database Engineering Blog

Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.

1 canonical articlesBrowse the complete archive

Popular Searches

Latest Articles

Showing 1 of 1 articles

PostgreSQL Lock Waits: How to Find the Blocking Query and Fix It

Find the session behind a PostgreSQL lock wait with pg_blocking_pids, see why a waiting ALTER TABLE stalls every SELECT, and choose between cancel, terminate, and timeouts.

PostgreSQL18 minOct 27, 2026
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed