Postgres issues

From Delft Solutions
Revision as of 08:45, 24 March 2026 by Vincent (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

Retrieved from "https://docs.delftsolutions.nl/index.php?title=Postgres_issues&oldid=698"