Re: LWLocks by LockManager slowing large DB

From: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Paul Friedman <paul(dot)friedman(at)streetlightdata(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: LWLocks by LockManager slowing large DB
Date: 2021-04-12 23:33:45
Message-ID: CANNMO+LRFitgTg054hJ0ts4ie2EWj30JqkNKYMCRFrSpMgmT5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 12, 2021 at 14:57 Andres Freund <andres(at)anarazel(dot)de> 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

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Paquier 2021-04-13 07:34:23 Re: [PATCH] force_parallel_mode and GUC categories
Previous Message Andres Freund 2021-04-12 23:03:54 Re: LWLocks by LockManager slowing large DB