Re: LWLocks by LockManager slowing large DB

[Nikolay Samokhvalov <samokhvalov@xxxxxxxxx>]

On Mon, Apr 12, 2021 at 14:57 Andres Freund <andres@xxxxxxxxxxx> wrote:

Without knowing the proportion of LockManager wait events compared to
the rest it's hard to know what to make of it.

These OSS tools can be useful to understand the proportion:

- pgCenter 

https://github.com/lesovsky/pgcenter

- pg_wait_sampling (can be used together with POWA monitoring) 

https://github.com/postgrespro/pg_wait_sampling

- pgsentinel 

https://github.com/pgsentinel/pgsentinel

- PASH Viewer (good for visualization, integrates with pgsentinel) 

https://github.com/dbacvetkov/PASH-Viewer