Show locks data [enhancement]

[ohaddahan]

I think a very useful enhancement will be extracting lock data from the DB.
Locks can be the underlining reasons for many long / non-end queries and making them more visible is highly valuable in my eyes.

[seanlinsley]

A starting point: https://wiki.postgresql.org/wiki/Lock_Monitoring

[seanlinsley]

It looks like there's a blocked_queries method, but it doesn't have a UI.

[ankane]

Hey @ohaddahan, thanks for the suggestion. As @seanlinsley mentioned, there is a Ruby method for it, but it's not used in the UI. Are you interested in seeing that a long running query is due to a lock, or did you have something else in mind?

[ankane]

Cleaning up stale issues

[maximmladenov]

Hey @ankane I am interested in seeing long running queries which are due to a lock. Do you have any plan to develop this kind of feature?

[slava-nikulin]

@ankane yeah, I'm interested to see blocked queries too