Vincent
Created page with "''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 - h..."