[check_postgres] [commit] Show percentage on backends.

[check_postgres at bucardo.org]

Committed by Greg Sabino Mullane <greg at endpoint.com>

Show percentage on backends.

---
 check_postgres.pl |    7 +++++--
 1 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/check_postgres.pl b/check_postgres.pl
index 023d4ec..ada6d32 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -1635,7 +1635,8 @@ sub check_backends {
 		if ($MRTG) {
 			do_mrtg({one => 1, msg => "DB=$db->{dbname} Max connections=$limit"});
 		}
-		add_ok qq{1 of $limit connections};
+		my $percent = (int 1/$limit*100) || 1;
+		add_ok qq{1 of $limit connections ($percent%)};
 		return;
 	}
 
@@ -1658,7 +1659,8 @@ sub check_backends {
 			add_unknown 'T-EXCLUDE-DB';
 			next;
 		}
-		my $msg = qq{$total of $limit connections};
+		my $percent = (int $total / $limit*100) || 1;
+		my $msg = qq{$total of $limit connections ($percent%)};
 		my $ok = 1;
 		if ($e1) { ## minus
 			$ok = 0 if $limit-$total >= $e2;
@@ -4819,6 +4821,7 @@ Items not specifically attributed are by Greg Sabino Mullane.
 =item B<Version 2.3.11>
 
  Pretty up the time output for last vacuum and analyze actions.
+ Show the percentage of backends on the check_backends action.
 
 =item B<Version 2.3.10>
 
-- 
1.5.5.4