Postgres issues: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

24 March 2026

  • curprev 08:4508:45, 24 March 2026Vincent talk contribs 560 bytes +560 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..."