[check_postgres] output pg_stat_activity on warn/error

Thomas Güttler guettliml at thomas-guettler.de
Wed Jun 11 07:36:47 UTC 2014


Since there was no reply on github, I try it here:

check_postgres works well. If I receive an error or warning, I know that something is wrong.

But I can't see what is going on.

It would be great to see the pg_stat_activity output if there is something wrong.

http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW

Our applications set the "application_name" which makes the output even more useful, but I guess a lot of applications 
don't do it.

See: https://github.com/bucardo/check_postgres/issues/65

We use check_postgres not with nagios, but a different solution which can  handle more output.

Any idea how to get more info if there is warning or error. It would be great to get more info to
see as soon as possible what makes the trouble.

   Thomas Güttler


More information about the Check_postgres mailing list