RE: LWLocks by LockManager slowing large DB

Поиск
Список
Период
Сортировка
От Paul Friedman
Тема RE: LWLocks by LockManager slowing large DB
Дата
Msg-id c23b420ebe5c3b8f058ea3eb6e66d6ea@mail.gmail.com
обсуждение исходный текст
Ответ на LWLocks by LockManager slowing large DB  (Paul Friedman <paul.friedman@streetlightdata.com>)
Список 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.friedman@streetlightdata.com

 

From: Nikolay Samokhvalov <samokhvalov@gmail.com>
Sent: Monday, April 12, 2021 4:34 PM
To: Andres Freund <andres@anarazel.de>
Cc: Paul Friedman <paul.friedman@streetlightdata.com>; pgsql-performance@lists.postgresql.org
Subject: Re: LWLocks by LockManager slowing large DB

 

 

 

On Mon, Apr 12, 2021 at 14:57 Andres Freund <andres@anarazel.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 

- pg_wait_sampling (can be used together with POWA monitoring) 

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

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Paul Friedman
Дата:
Сообщение: RE: LWLocks by LockManager slowing large DB
Следующее
От: Andres Freund
Дата:
Сообщение: Re: LWLocks by LockManager slowing large DB