index 1391147cbb4470a2b074d0e5e4a752bcef206ed4..d304de537b2a647a0ea7375cf5e60a40b6ee8d77 100644 (file)
# Pre-defined queries of collectd's postgresql plugin.
+<Query database>
+ Query "SELECT numbackends, xact_commit, xact_rollback \
+ FROM pg_stat_database \
+ WHERE datname = $1;"
+
+ Param database
+
+ Column pg_numbackends
+ Column pg_xact commit
+ Column pg_xact rollback
+</Query>
+
<Query user_tables>
Query "SELECT sum(seq_scan), sum(seq_tup_read), \
sum(idx_scan), sum(idx_tup_fetch), \