PostgreSQL Documentation: log_lock

Type:	`bool`
Default:	`off`
Context:	`superuser`
Restart:	`false`

Logs long lock waits

Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock. This is useful in determining if lock waits are causing poor performance. The default is off. Only superusers and users with the appropriate SET privilege can change this setting.

Official docs

Search in source code

Recommendations

Useful for performance analysis.

By annotated.conf

On StackOverflow

What exactly means the collation 'de-DE-u-kn-true'
Lazily (de-)serialize JSON with EF Core
Connect to a heroku database with pgadmin
Get breakdown from de-normalized SQL table
PostGIS & Hibernate can't de-serialize point geometry

On pgsql-hackers

A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.
Re: Add “FOR UPDATE NOWAIT” lock details to the log.
Re: Patch: Show queries of processes holding a lock
Patch: Show queries of processes holding a lock
deadlock-soft isolation test is failing on newest Fedora

log_lock_waits

Recommendations

On StackOverflow

On pgsql-hackers

Comments