Re: [Proposal] Add accumulated statistics for wait event

Egor Rogov <e.rogov@postgrespro.ru>

From: Egor Rogov <e.rogov@postgrespro.ru>
To: pgsql-hackers@lists.postgresql.org
Date: 2018-07-23T08:41:38Z
Lists: pgsql-hackers
Hi,

that will be a great feature.


On 23.07.2018 10:53, Michael Paquier wrote:
> I have comments about your patch.  First, I don't think that you need to
> count precisely the number of wait events triggered as usually when it
> comes to analyzing a workload's bottleneck what counts is a periodic
> *sampling* of events

If I get it right, this patch is not about sampling. It gathers 
cumulative statistics, which is regrettably missing in PostgreSQL. 
That's why it should not only count exact number of wait events, but 
also min time and stddev would be helpful (as in pg_stat_statements).

--
Egor Rogov
Postgres Professional http://www.postgrespro.com