Horton

RE: [Proposal] Add accumulated statistics

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

View thread
From: "Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>
To: 'Bruce Momjian' <bruce@momjian.us>
Cc: 'Phil Florent' <philflorent@hotmail.com>, 'Michael Paquier' <michael@paquier.xyz>, 'Tomas Vondra' <tomas.vondra@2ndquadrant.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2018-12-21T01:47:40Z
Lists: pgsql-hackers 
On Wed, Nov 21, 2018 at 9:27 PM, Bruce Momjian wrote:

Hi, thank you for the information.
I understood that sampling is effective for investigation of waiting events. 

By the way, you can see the number of wait events with "LWLOCK_STATS", right?
Is this function implemented because it is necessary to know the number of waiting events for investigation?
If so, is not that the number of wait events is useful information?
Now, I need to rebuild to get this information and I feel inconvenience.

So, how about checking the number of wait events in the view?
Also, I think that it will be useful if you know the waiting time.
I think that it is easy to investigate when it is clearly known how long waiting time is occupied with processing time.

-- 
Naoki Yotsunaga