RE: [Proposal] Add accumulated statistics for wait event - Mailing list pgsql-hackers

From Yotsunaga, Naoki
Subject RE: [Proposal] Add accumulated statistics for wait event
Date
Msg-id 8E9126CB6CE2CD42962059AB0FBF7B0DC46829@g01jpexmbkw23
Whole thread Raw
In response to RE: [Proposal] Add accumulated statistics for wait event  (Phil Florent <philflorent@hotmail.com>)
Responses RE: [Proposal] Add accumulated statistics for wait event  ("Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>)
List pgsql-hackers

On Thu, Oct 4, 2018 at 0:54 AM, Phil Florent wrote:

 

Phil, Michael, I appreciate your polite comments.

I understand as follows.

We can find it if we shorten the sampling interval, but a lot of information comes out.

# The balance is important.

Also, it is not good unless we have enough samples.

And I have to do various other things.

Is my understand correct?

 

It seems to me that it is difficult for me if my understanding is right.

Is DBA really able to solve bottlenecks with sampling?

# Since I am a beginner, I feel that way. And other people may not feel it difficult.

 

What I would like to say is that if we have information on the number of wait events and the wait time(like other DB), we can investigate more easily.

Of course, I understand that it also affects performance. So, I suggest a way that it can switch on and off, defaults is off.

 

-----

Naoki, Yotsunaga.

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: [HACKERS] Optional message to user when terminating/cancellingbackend
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: shared-memory based stats collector