Improve lock monitoring - new dashboard "Lock Details"
Current monitoring methods do not fully cover the blocking situation, limiting themselves only to information about the types of locks and their number.
There is no visibility of which specific objects (relation, statement) are the sources of locks and how long they hold them.
The new dashboard "Lock Details" gives detailed information about the heavyweight locks:
Additionally
- The collection frequency has been reduced from 1 minute to 10 seconds for the 'locks', 'locks_mode' metrics.
- Now it corresponds to the 'backends' and 'blocking_locks' metrics.
- Update grafana to v10.2.2
Edited by Vitaliy Kukharik