From: Adrien NAYRAT [mailto:adrien.nay...@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
