| From: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | 'Adrien NAYRAT' <adrien(dot)nayrat(at)anayrat(dot)info>, "Yotsunaga, Naoki" <yotsunaga(dot)naoki(at)jp(dot)fujitsu(dot)com>, 'Bruce Momjian' <bruce(at)momjian(dot)us>, "'Phil Florent'" <philflorent(at)hotmail(dot)com>, 'Michael Paquier' <michael(at)paquier(dot)xyz>, 'Tomas Vondra' <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: [Proposal] Add accumulated statistics |
| Date: | 2019-01-09 01:24:06 |
| Message-ID: | 0A3221C70F24FB45833433255569204D1FB6317D@G01JPEXMBYT05 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
From: Adrien NAYRAT [mailto:adrien(dot)nayrat(at)anayrat(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2019-01-09 01:33:00 | Re: A few new options for vacuumdb |
| Previous Message | Masahiko Sawada | 2019-01-09 01:14:34 | Re: Using logical replication with older version subscribers |