1 # Pre-defined queries of collectd's postgresql plugin.
3 <Query backends>
4 Statement "SELECT count(*) \
5 FROM pg_stat_activity \
6 WHERE datname = $1;"
8 Param database
10 Column pg_numbackends
11 </Query>
13 <Query transactions>
14 Statement "SELECT xact_commit, xact_rollback \
15 FROM pg_stat_database \
16 WHERE datname = $1;"
18 Param database
20 Column pg_xact commit
21 Column pg_xact rollback
22 </Query>
24 <Query queries>
25 Statement "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del) \
26 FROM pg_stat_user_tables;"
28 Column pg_n_tup_c ins
29 Column pg_n_tup_c upd
30 Column pg_n_tup_c del
32 MaxPGVersion 80299
33 </Query>
35 <Query queries>
36 Statement "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
37 sum(n_tup_hot_upd) \
38 FROM pg_stat_user_tables;"
40 Column pg_n_tup_c ins
41 Column pg_n_tup_c upd
42 Column pg_n_tup_c del
43 Column pg_n_tup_c hot_upd
45 MinPGVersion 80300
46 </Query>
48 <Query query_plans>
49 Statement "SELECT sum(seq_scan), sum(seq_tup_read), \
50 sum(idx_scan), sum(idx_tup_fetch) \
51 FROM pg_stat_user_tables;"
53 Column pg_scan seq
54 Column pg_scan seq_tup_read
55 Column pg_scan idx
56 Column pg_scan idx_tup_fetch
57 </Query>
59 <Query table_states>
60 Statement "SELECT sum(n_live_tup), sum(n_dead_tup) \
61 FROM pg_stat_user_tables;"
63 Column pg_n_tup_g live
64 Column pg_n_tup_g dead
66 MinPGVersion 80300
67 </Query>
69 <Query disk_io>
70 Statement "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
71 sum(idx_blks_read), sum(idx_blks_hit), \
72 sum(toast_blks_read), sum(toast_blks_hit), \
73 sum(tidx_blks_read), sum(tidx_blks_hit) \
74 FROM pg_statio_user_tables;"
76 Column pg_blks heap_read
77 Column pg_blks heap_hit
78 Column pg_blks idx_read
79 Column pg_blks idx_hit
80 Column pg_blks toast_read
81 Column pg_blks toast_hit
82 Column pg_blks tidx_read
83 Column pg_blks tidx_hit
84 </Query>
86 <Query disk_usage>
87 Statement "SELECT pg_database_size($1);"
89 Param database
91 Column pg_db_size
92 </Query>