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 8E9126CB6CE2CD42962059AB0FBF7B0DC5A0B3@g01jpexmbkw23
Whole thread Raw
In response to RE: [Proposal] Add accumulated statistics for wait event  ("Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>)
Responses RE: [Proposal] Add accumulated statistics for wait event  (legrand legrand <legrand_legrand@hotmail.com>)
RE: [Proposal] Add accumulated statistics for wait event  (Phil Florent <philflorent@hotmail.com>)
List pgsql-hackers

On Thu, Oct 4, 2018 at 8:22 PM, Yotsunaga Naoki wrote:

 

Hi, I understood and thought of your statistic comment once again. In the case of sampling, is there enough statistic to investigate?

In the case of a long SQL, I think that it is possible to obtain a sufficient sampling number.

 

However, in the case of about 1 minute of SQL, only 60 samples can be obtained at most.

#Because legards comment.

https://www.postgresql.org/message-id/1539158356795-0.post%40n3.nabble.com

 

Does this sampling number of 60 give information that I really want?

Perhaps it is not to miss the real problem part?

---------------------------------------

Naoki, Yotsunaga.

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Transactions involving multiple postgres foreignservers, take 2
Next
From: Michael Paquier
Date:
Subject: Re: [PATCH] Tab complete EXECUTE FUNCTION for CREATE (EVENT) TRIGGER