Pick a command to see what it blocks

Pick an Operation

Updates rows from a table

Example Query

UPDATE some_table 
SET some_col = 'some_val'
WHERE some_col = 'some_other_val';

Non-blocking operation

Table Lock

Ref Table Lock

Row Lock

Postgres Locks Explained