Monitoring for blocked Postgres sessions?

General
1

CheckMKs Postgres agent plugin communicates metrics about shared/exclusive lock usage. But it doesn’t currently warn about sessions which have been blocked for a long time. I could really use that, in the same way that the MSSQL agent plugin will warn about blocked sessions.

Am I overlooking something in the current Postgres agent plugin? Or would it require adding some code to the agent plugin (and to CheckMK for interpreting it)? If the latter is the case, I might give it a shot.

2

Hello troelsarvin,
unfortunately the Postgres agent plugin currently does not support monitoring blocked Postgres sessions.

If you would like to give your suggestion more visibility, we would like to invite you to post it in our Ideas Portal.
This will enable other users to vote on it, allowing us to prioritize it in a targeted manner in the future and, as appropriate, incorporate it into our strategic development planning.

Thanks,
Andrea

1 Like