Horton

RE: [Proposal] Add accumulated statistics for wait event

Yotsunaga, Naoki <yotsunaga.naoki@jp.fujitsu.com>

View thread
From: "Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>
To: 'Phil Florent' <philflorent@hotmail.com>, 'Michael Paquier' <michael@paquier.xyz>
Cc: 'Tomas Vondra' <tomas.vondra@2ndquadrant.com>, "'pgsql-hackers@lists.postgresql.org'" <pgsql-hackers@lists.postgresql.org>
Date: 2018-10-29T01:20:49Z
Lists: 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 legard’s 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.