postgresql plugin: Moved pg_stat_database query to postgresql_default.conf.

[collectd.git] / src / postgresql_default.conf

diff --git a/src/postgresql_default.conf b/src/postgresql_default.conf
index 1391147..d304de5 100644 (file)
--- a/src/postgresql_default.conf
+++ b/src/postgresql_default.conf
@@ -1,5 +1,17 @@
 # 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), \