Ah, it all makes sense now after seeing that pg_locks query.

Thanks for sharing your design! :)