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

From Yotsunaga, Naoki
Subject RE: [Proposal] Add accumulated statistics
Date
Msg-id 8E9126CB6CE2CD42962059AB0FBF7B0DC842A3@g01jpexmbkw23
Whole thread Raw
In response to Re: [Proposal] Add accumulated statistics  (Bruce Momjian <bruce@momjian.us>)
Responses RE: [Proposal] Add accumulated statistics
RE: [Proposal] Add accumulated statistics
Re: [Proposal] Add accumulated statistics
List 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



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: A few new options for vacuumdb
Next
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] Macros bundling RELKIND_* conditions