1 # Pre-defined queries of collectd's postgresql plugin.
3 <Query backends>
4 Query "SELECT count(*) \
5 FROM pg_stat_activity \
6 WHERE datname = $1;"
8 Param database
10 Column pg_numbackends
11 </Query>
13 <Query transactions>
14 Query "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 Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
26 sum(n_tup_hot_upd) \
27 FROM pg_stat_user_tables;"
29 Column pg_n_tup_c ins
30 Column pg_n_tup_c upd
31 Column pg_n_tup_c del
32 Column pg_n_tup_c hot_upd
33 </Query>
35 <Query query_plans>
36 Query "SELECT sum(seq_scan), sum(seq_tup_read), \
37 sum(idx_scan), sum(idx_tup_fetch) \
38 FROM pg_stat_user_tables;"
40 Column pg_scan seq
41 Column pg_scan seq_tup_read
42 Column pg_scan idx
43 Column pg_scan idx_tup_fetch
44 </Query>
46 <Query table_states>
47 Query "SELECT sum(n_live_tup), sum(n_dead_tup) \
48 FROM pg_stat_user_tables;"
50 Column pg_n_tup_g live
51 Column pg_n_tup_g dead
52 </Query>
54 <Query disk_io>
55 Query "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
56 sum(idx_blks_read), sum(idx_blks_hit), \
57 sum(toast_blks_read), sum(toast_blks_hit), \
58 sum(tidx_blks_read), sum(tidx_blks_hit) \
59 FROM pg_statio_user_tables;"
61 Column pg_blks heap_read
62 Column pg_blks heap_hit
63 Column pg_blks idx_read
64 Column pg_blks idx_hit
65 Column pg_blks toast_read
66 Column pg_blks toast_hit
67 Column pg_blks tidx_read
68 Column pg_blks tidx_hit
69 </Query>
71 <Query disk_usage>
72 Query "SELECT pg_database_size($1);"
74 Param database
76 Column pg_db_size
77 </Query>