RE: [Proposal] Add accumulated statistics

Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com>

From: "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>

To: 'Adrien NAYRAT' <adrien.nayrat@anayrat.info>, "Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>, 'Bruce Momjian' <bruce@momjian.us>, "'Phil Florent'" <philflorent@hotmail.com>, 'Michael Paquier' <michael@paquier.xyz>, 'Tomas Vondra' <tomas.vondra@2ndquadrant.com>

Cc: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>

Date: 2019-01-09T01:24:06Z

Lists: pgsql-hackers

From: Adrien NAYRAT [mailto:adrien.nayrat@anayrat.info]
> FIY, wait events have been added in PoWA by using pg_wait_sampling
> extension :
> https://rjuju.github.io/postgresql/2018/07/09/wait-events-support-for-
> powa.html
> 
> pg_wait_sampling sample the wait events in shared memory and PoWA store
> them.

Great.  Also FYI, Amazon RDS/Aurora Performance Insights already provides a load profiling feature based on the wait events collected from pg_stat_activity, which samples once a second.  An intuitive 5 minute video for introduction is here:

Using Amazon RDS Performance Insights
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.html

Although I cannot see the graphics as I'm almost blind, the explanation  sounds like it mimics Oracle Enterprise Manager.  Cool.

Aren't you thinking of incorporating your work into PostgreSQL as a contrib like pg_stat_statements?


Regards
Takayuki Tsunakawa