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
eventscollected 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
