https://docs.delftsolutions.nl/index.php?action=history&feed=atom&title=Postgres_issues 2026-04-03T22:08:26Z Revision history for this page on the wiki MediaWiki 1.39.3 https://docs.delftsolutions.nl/index.php?title=Postgres_issues&diff=698&oldid=prev 2026-03-24T15:45:54Z

<p>Created page with &quot;&#039;&#039;WIP&#039;&#039; 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...&quot;</p> <p><b>New page</b></p><div>&#039;&#039;WIP&#039;&#039;<br /> <br /> When you suspect database/postgres issues causing degraded performance on a service, you can check the following:<br /> <br /> == Check blocking sessions ==<br /> <br /> A function listing the sessions preventing a session from acquiring a lock<br /> <br /> - https://pgpedia.info/p/pg_blocking_pids.html<br /> <br /> == Lock monitoring ==<br /> <br /> Viewing information on current locking state<br /> <br /> - https://wiki.postgresql.org/wiki/Lock_Monitoring<br /> <br /> == Postgres logging ==<br /> <br /> Options for logging locking issues in postgres<br /> <br /> - https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-LOCK-WAITS</div>

Vincent