projects
/
collectd.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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.
# 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), \
<Query user_tables>
Query "SELECT sum(seq_scan), sum(seq_tup_read), \
sum(idx_scan), sum(idx_tup_fetch), \