postgresql plugin: Renamed the "Query" config option to "Statement".
[collectd.git] / src / postgresql_default.conf
index 61844a0..ab0f178 100644 (file)
@@ -1,7 +1,7 @@
 # Pre-defined queries of collectd's postgresql plugin.
 
 <Query backends>
-       Query "SELECT count(*) \
+       Statement "SELECT count(*) \
                FROM pg_stat_activity \
                WHERE datname = $1;"
 
@@ -11,7 +11,7 @@
 </Query>
 
 <Query transactions>
-       Query "SELECT xact_commit, xact_rollback \
+       Statement "SELECT xact_commit, xact_rollback \
                FROM pg_stat_database \
                WHERE datname = $1;"
 
@@ -22,7 +22,7 @@
 </Query>
 
 <Query queries>
-       Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del) \
+       Statement "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del) \
                FROM pg_stat_user_tables;"
 
        Column pg_n_tup_c ins
@@ -33,7 +33,7 @@
 </Query>
 
 <Query queries>
-       Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
+       Statement "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
                        sum(n_tup_hot_upd) \
                FROM pg_stat_user_tables;"
 
@@ -46,7 +46,7 @@
 </Query>
 
 <Query query_plans>
-       Query "SELECT sum(seq_scan), sum(seq_tup_read), \
+       Statement "SELECT sum(seq_scan), sum(seq_tup_read), \
                        sum(idx_scan), sum(idx_tup_fetch) \
                FROM pg_stat_user_tables;"
 
@@ -57,7 +57,7 @@
 </Query>
 
 <Query table_states>
-       Query "SELECT sum(n_live_tup), sum(n_dead_tup) \
+       Statement "SELECT sum(n_live_tup), sum(n_dead_tup) \
                FROM pg_stat_user_tables;"
 
        Column pg_n_tup_g live
@@ -67,7 +67,7 @@
 </Query>
 
 <Query disk_io>
-       Query "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
+       Statement "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
                        sum(idx_blks_read), sum(idx_blks_hit), \
                        sum(toast_blks_read), sum(toast_blks_hit), \
                        sum(tidx_blks_read), sum(tidx_blks_hit) \
@@ -84,7 +84,7 @@
 </Query>
 
 <Query disk_usage>
-       Query "SELECT pg_database_size($1);"
+       Statement "SELECT pg_database_size($1);"
 
        Param database