Re: [Proposal] Add accumulated statistics for wait event

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [Proposal] Add accumulated statistics for wait event
Дата
Msg-id 20181004105841.GD1256@paquier.xyz
обсуждение исходный текст
Ответ на RE: [Proposal] Add accumulated statistics for wait event  (Phil Florent <philflorent@hotmail.com>)
Ответы RE: [Proposal] Add accumulated statistics for wait event
Список pgsql-hackers
On Thu, Oct 04, 2018 at 09:32:37AM +0000, Phil Florent wrote:
> I am a DB beginner, so please tell me. It says that you can find
> events that are bottlenecks in sampling, but as you saw above, you can
> not find events shorter than the sampling interval, right?

Yes, which is why it would be as simple as making the interval shorter,
still not too short so as it bloats the amount of information fetched
which needs to be stored and afterwards (perhaps) treated for analysis.
This gets rather close to signal processing.  A simple image is for
example, assuming that event A happens 100 times in an interval of 1s,
and event B only once in the same interval of 1s, then if the snapshot
interval is only 1s, then in the worst case A would be treated an equal
of B, which would be wrong.
--
Michael

Вложения

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

Предыдущее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: libpq compression
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Optional message to user when terminating/cancellingbackend