zalando / pg_view

Get a detailed, real-time view of your PostgreSQL database and system metrics
https://pypi.python.org/pypi/pg-view
Other
496 stars 49 forks source link

Report waiting processes with a special color and the type of the event they are waiting for #93

Open alexeyklyukin opened 7 years ago

alexeyklyukin commented 7 years ago

For PostgreSQL 9.6, the wait events collect much more types of waits than a heavyweight locks used in the prior versions. We could report them to the user, as well as highlighting such backends with a color that is different from the one used by 'locked' processes nowadays (i.e. report 'locked' processes with red, report waiting processes that are not 'locked' in another color, together with the wait type).

Alternatively, we could report everything as 'locked' (and highlight in red), together with adding the event event.