Use of Lock Tree SQL to view locks hierarquicaly

[alepaes1975]

Hi,

In lock view, a better way to see locks, IMHO, is with a "lock tree":
https://postgres.ai/blog/20211018-postgresql-lock-trees

Another approach is to have a programable shortcut to assign our own querys to 'buttons' in a conf file to acomplissh this and other custom monitoring querys.

Congrats for this great tool. ;)

Best regards,

Alexandre

[blogh]

Nice idea will look into it.

[ifyouseewendy]

If there is a hierarchy view for locking, that'll be super helpful.