From: | Paul Friedman <paul(dot)friedman(at)streetlightdata(dot)com> |
---|---|
To: | Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | RE: LWLocks by LockManager slowing large DB |
Date: | 2021-04-13 16:36:36 |
Message-ID: | c23b420ebe5c3b8f058ea3eb6e66d6ea@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks for this – these tools (and the raw selects on pg_stat_activity and
pg_locks) are all showing wait events being created by LockManager waiting
on an LWLock.
---Paul
Paul Friedman
CTO
677 Harrison St | San Francisco, CA 94107
*M:* (650) 270-7676
*E-mail:* paul(dot)friedman(at)streetlightdata(dot)com
*From:* Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
*Sent:* Monday, April 12, 2021 4:34 PM
*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
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2021-04-13 18:16:46 | Re: LWLocks by LockManager slowing large DB |
Previous Message | Paul Friedman | 2021-04-13 16:33:48 | RE: LWLocks by LockManager slowing large DB |