X-Git-Url: https://git.octo.it/?a=blobdiff_plain;f=src%2Fpostgresql_default.conf;fp=src%2Fpostgresql_default.conf;h=d304de537b2a647a0ea7375cf5e60a40b6ee8d77;hb=b762e50bdd12424dc40a58f82a25bb86c7348849;hp=1391147cbb4470a2b074d0e5e4a752bcef206ed4;hpb=883531cd6271cb8e47adf24973893062db0d3d43;p=collectd.git
diff --git a/src/postgresql_default.conf b/src/postgresql_default.conf
index 1391147c..d304de53 100644
--- a/src/postgresql_default.conf
+++ b/src/postgresql_default.conf
@@ -1,5 +1,17 @@
# Pre-defined queries of collectd's postgresql plugin.
+
+ 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 "SELECT sum(seq_scan), sum(seq_tup_read), \
sum(idx_scan), sum(idx_tup_fetch), \