1 # Pre-defined queries of collectd's postgresql plugin.
4 Statement "SELECT count(*) AS count \
5 FROM pg_stat_activity \
17 Statement "SELECT xact_commit, xact_rollback \
18 FROM pg_stat_database \
25 InstancePrefix "commit"
26 ValuesFrom "xact_commit"
30 InstancePrefix "rollback"
31 ValuesFrom "xact_rollback"
36 Statement "SELECT sum(n_tup_ins) AS ins, \
37 sum(n_tup_upd) AS upd, \
38 sum(n_tup_del) AS del \
39 FROM pg_stat_user_tables;"
61 Statement "SELECT sum(n_tup_ins) AS ins, \
62 sum(n_tup_upd) AS upd, \
63 sum(n_tup_del) AS del, \
64 sum(n_tup_hot_upd) AS hot_upd \
65 FROM pg_stat_user_tables;"
84 InstancePrefix "hot_upd"
92 Statement "SELECT sum(seq_scan) AS seq, \
93 sum(seq_tup_read) AS seq_tup_read, \
94 sum(idx_scan) AS idx, \
95 sum(idx_tup_fetch) AS idx_tup_fetch \
96 FROM pg_stat_user_tables;"
105 InstancePrefix "seq_tup_read"
106 ValuesFrom "seq_tup_read"
115 InstancePrefix "idx_tup_fetch"
116 ValuesFrom "idx_tup_fetch"
121 Statement "SELECT sum(n_live_tup) AS live, sum(n_dead_tup) AS dead \
122 FROM pg_stat_user_tables;"
126 InstancePrefix "live"
131 InstancePrefix "dead"
139 Statement "SELECT sum(heap_blks_read) AS heap_read, \
140 sum(heap_blks_hit) AS heap_hit, \
141 sum(idx_blks_read) AS idx_read, \
142 sum(idx_blks_hit) AS idx_hit, \
143 sum(toast_blks_read) AS toast_read, \
144 sum(toast_blks_hit) AS toast_hit, \
145 sum(tidx_blks_read) AS tidx_read, \
146 sum(tidx_blks_hit) AS tidx_hit \
147 FROM pg_statio_user_tables;"
151 InstancePrefix "heap_read"
152 ValuesFrom "heap_read"
156 InstancePrefix "heap_hit"
157 ValuesFrom "heap_hit"
161 InstancePrefix "idx_read"
162 ValuesFrom "idx_read"
166 InstancePrefix "idx_hit"
171 InstancePrefix "toast_read"
172 ValuesFrom "toast_read"
176 InstancePrefix "toast_hit"
177 ValuesFrom "toast_hit"
181 InstancePrefix "tidx_read"
182 ValuesFrom "tidx_read"
186 InstancePrefix "tidx_hit"
187 ValuesFrom "tidx_hit"
192 Statement "SELECT pg_database_size($1) AS size;"
202 # vim: set ft=config :