Postgres issues
Jump to navigation
Jump to search
WIP
When you suspect database/postgres issues causing degraded performance on a service, you can check the following:
Check blocking sessions
A function listing the sessions preventing a session from acquiring a lock
- https://pgpedia.info/p/pg_blocking_pids.html
Lock monitoring
Viewing information on current locking state
- https://wiki.postgresql.org/wiki/Lock_Monitoring
Postgres logging
Options for logging locking issues in postgres
- https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-LOCK-WAITS