Postgres issues

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