postgresql plugin: Define default queries in a configuration file.

[collectd.git] / src / postgresql_default.conf

diff --git a/src/postgresql_default.conf b/src/postgresql_default.conf
new file mode 100644 (file)
index 0000000..1391147
--- /dev/null
+++ b/src/postgresql_default.conf
@@ -0,0 +1,38 @@
+# Pre-defined queries of collectd's postgresql plugin.
+
+<Query user_tables>
+       Query "SELECT sum(seq_scan), sum(seq_tup_read), \
+                       sum(idx_scan), sum(idx_tup_fetch), \
+                       sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
+                       sum(n_tup_hot_upd), sum(n_live_tup), sum(n_dead_tup) \
+               FROM pg_stat_user_tables"
+
+       Column pg_scan    seq
+       Column pg_scan    seq_tup_read
+       Column pg_scan    idx
+       Column pg_scan    idx_tup_fetch
+       Column pg_n_tup_c ins
+       Column pg_n_tup_c upd
+       Column pg_n_tup_c del
+       Column pg_n_tup_c hot_upd
+       Column pg_n_tup_g live
+       Column pg_n_tup_g dead
+</Query>
+
+<Query io_user_tables>
+       Query "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) \
+               FROM pg_statio_user_tables;"
+
+       Column pg_blks heap_read
+       Column pg_blks heap_hit
+       Column pg_blks idx_read
+       Column pg_blks idx_hit
+       Column pg_blks toast_read
+       Column pg_blks toast_hit
+       Column pg_blks tidx_read
+       Column pg_blks tidx_hit
+</Query>
+