Showing WaitEvents as percentages

[psvampa]

Hello Jobin!

The Session Details section currently presents WaitEvent values as cardinal numbers, E.g., WalWriterMain:1937,WALWrite:40,WALSync:16,CPU:7
What do you think about presenting those cardinal numbers as percentages? Wouldn’t it be more human-readable/friendly?
Using cardinal numbers over the data-collection time, we could say something like, “This session was statistically spending ##% of its time doing this, this, and that".
It adds no additional value but still, it can help to understand the output.

Best regards,

[jobinau]

Thank you, @psvampa , This is important. This can make the data more human-readable and understandable.
I have been thinking about this for quite some time.
Technically the SQL statement :

pg_gather/gather_report.sql

Line 201 in 63f0d7f

SELECT * FROM (

Can have % calculation as well.

[jobinau]

Added this modification as part of the commit: 96de71e

[jobinau]

Anyone who would like to help the development with testing this feature/modification before the next release, please replace gather_report.sql with dev/report.sql for generating the report.
Any feedback would be great.

[psvampa]

I am testing it with the mentioned commit, which looks great. After checking several times with different data collections, I will share this with you.
TY, Jobin!