Skip to content

Improve lock monitoring - new dashboard "Lock Details"

Vitaliy Kukharik requested to merge blocking-locks into master

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:

image image image

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

Merge request reports