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

From Yotsunaga, Naoki
Subject RE: [Proposal] Add accumulated statistics
Date
Msg-id 8E9126CB6CE2CD42962059AB0FBF7B0DC61229@g01jpexmbkw23
Whole thread Raw
In response to Re: [Proposal] Add accumulated statistics for wait event  (Michael Paquier <michael@paquier.xyz>)
Responses RE: [Proposal] Add accumulated statistics
Re: [Proposal] Add accumulated statistics
List pgsql-hackers

On Sat, Nov 3, 2018 at 1:28 AM, Phil Florent wrote:

 

>2) it consumes system resources

While the system is running, you are always sampling system information, do not you? Like Oracle ASH.

If so, does sampling have no significant impact on performance? Even if the interval is 0.01 s or more.

 

>The main interest of sampling is to discard negligible activity to allow the DBA to work on meaningful queries and events.

In other words, do you mean narrowing down candidate of problems?

 

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

Naoki Yotsunaga

 

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Two pass CheckDeadlock in contentent case
Next
From: Thomas Munro
Date:
Subject: Re: Strange failure in LWLock on skink in REL9_5_STABLE