summaryrefslogtreecommitdiff
path: root/check_postgres.pl
diff options
context:
space:
mode:
authorChristoph Berg2016-06-08 20:14:59 +0000
committerChristoph Berg2016-06-08 20:14:59 +0000
commit3d6f175a9303753b7a36a59d4179d21b5e5d9a02 (patch)
tree23067fa239015ad647f20d8114255d803f8da03f /check_postgres.pl
parent0984bbc4effc2bcc64ac53c5957ce23e1def832a (diff)
txn_idle: Document that --includeuser can be used to work around superuser checks
Close #81.
Diffstat (limited to 'check_postgres.pl')
-rwxr-xr-xcheck_postgres.pl4
1 files changed, 4 insertions, 0 deletions
diff --git a/check_postgres.pl b/check_postgres.pl
index 84065bad6..76514448f 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -9995,6 +9995,10 @@ are given and the numbers are unsigned, the units are assumed to be seconds.
This action requires Postgres 8.3 or better.
+Superuser privileges are required to see the queries of all users in the system;
+UNKNOWN is returned if queries cannot be checked. To only include queries by
+the connecting user, use I<--includeuser>.
+
Example 1: Give a warning if any connection has been idle in transaction for more than 15 seconds:
check_postgres_txn_idle --port=5432 --warning='15 seconds'