X-Git-Url: https://git.octo.it/?a=blobdiff_plain;f=src%2Fpostgresql_default.conf;fp=src%2Fpostgresql_default.conf;h=1391147cbb4470a2b074d0e5e4a752bcef206ed4;hb=09c001b38efcb0344c517c5944df87127ea30ee6;hp=0000000000000000000000000000000000000000;hpb=12d48e6b453a4f028d4550d8cea159c913534c5d;p=collectd.git

diff --git a/src/postgresql_default.conf b/src/postgresql_default.conf
new file mode 100644
index 00000000..1391147c
--- /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>
+