1 # Pre-defined queries of collectd's postgresql plugin.
3 <Query backends>
4 Statement "SELECT count(*) AS count \
5 FROM pg_stat_activity \
6 WHERE datname = $1;"
8 Param database
10 <Result>
11 Type "pg_numbackends"
12 ValuesFrom "count"
13 </Result>
14 </Query>
16 <Query transactions>
17 Statement "SELECT xact_commit, xact_rollback \
18 FROM pg_stat_database \
19 WHERE datname = $1;"
21 Param database
23 <Result>
24 Type "pg_xact"
25 InstancePrefix "commit"
26 ValuesFrom "xact_commit"
27 </Result>
28 <Result>
29 Type "pg_xact"
30 InstancePrefix "rollback"
31 ValuesFrom "xact_rollback"
32 </Result>
33 </Query>
35 <Query queries>
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;"
41 <Result>
42 Type "pg_n_tup_c"
43 InstancePrefix "ins"
44 ValuesFrom "ins"
45 </Result>
46 <Result>
47 Type "pg_n_tup_c"
48 InstancePrefix "upd"
49 ValuesFrom "upd"
50 </Result>
51 <Result>
52 Type "pg_n_tup_c"
53 InstancePrefix "del"
54 ValuesFrom "del"
55 </Result>
57 MaxPGVersion 80299
58 </Query>
60 <Query queries>
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;"
67 <Result>
68 Type "pg_n_tup_c"
69 InstancePrefix "ins"
70 ValuesFrom "ins"
71 </Result>
72 <Result>
73 Type "pg_n_tup_c"
74 InstancePrefix "upd"
75 ValuesFrom "upd"
76 </Result>
77 <Result>
78 Type "pg_n_tup_c"
79 InstancePrefix "del"
80 ValuesFrom "del"
81 </Result>
82 <Result>
83 Type "pg_n_tup_c"
84 InstancePrefix "hot_upd"
85 ValuesFrom "hot_upd"
86 </Result>
88 MinPGVersion 80300
89 </Query>
91 <Query query_plans>
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;"
98 <Result>
99 Type "pg_scan"
100 InstancePrefix "seq"
101 ValuesFrom "seq"
102 </Result>
103 <Result>
104 Type "pg_scan"
105 InstancePrefix "seq_tup_read"
106 ValuesFrom "seq_tup_read"
107 </Result>
108 <Result>
109 Type "pg_scan"
110 InstancePrefix "idx"
111 ValuesFrom "idx"
112 </Result>
113 <Result>
114 Type "pg_scan"
115 InstancePrefix "idx_tup_fetch"
116 ValuesFrom "idx_tup_fetch"
117 </Result>
118 </Query>
120 <Query table_states>
121 Statement "SELECT sum(n_live_tup) AS live, sum(n_dead_tup) AS dead \
122 FROM pg_stat_user_tables;"
124 <Result>
125 Type "pg_n_tup_g"
126 InstancePrefix "live"
127 ValuesFrom "live"
128 </Result>
129 <Result>
130 Type "pg_n_tup_g"
131 InstancePrefix "dead"
132 ValuesFrom "dead"
133 </Result>
135 MinPGVersion 80300
136 </Query>
138 <Query disk_io>
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;"
149 <Result>
150 Type "pg_blks"
151 InstancePrefix "heap_read"
152 ValuesFrom "heap_read"
153 </Result>
154 <Result>
155 Type "pg_blks"
156 InstancePrefix "heap_hit"
157 ValuesFrom "heap_hit"
158 </Result>
159 <Result>
160 Type "pg_blks"
161 InstancePrefix "idx_read"
162 ValuesFrom "idx_read"
163 </Result>
164 <Result>
165 Type "pg_blks"
166 InstancePrefix "idx_hit"
167 ValuesFrom "idx_hit"
168 </Result>
169 <Result>
170 Type "pg_blks"
171 InstancePrefix "toast_read"
172 ValuesFrom "toast_read"
173 </Result>
174 <Result>
175 Type "pg_blks"
176 InstancePrefix "toast_hit"
177 ValuesFrom "toast_hit"
178 </Result>
179 <Result>
180 Type "pg_blks"
181 InstancePrefix "tidx_read"
182 ValuesFrom "tidx_read"
183 </Result>
184 <Result>
185 Type "pg_blks"
186 InstancePrefix "tidx_hit"
187 ValuesFrom "tidx_hit"
188 </Result>
189 </Query>
191 <Query disk_usage>
192 Statement "SELECT pg_database_size($1) AS size;"
194 Param database
196 <Result>
197 Type pg_db_size
198 ValuesFrom "size"
199 </Result>
200 </Query>
202 # vim: set ft=config :