d304de537b2a647a0ea7375cf5e60a40b6ee8d77
1 # Pre-defined queries of collectd's postgresql plugin.
3 <Query database>
4 Query "SELECT numbackends, xact_commit, xact_rollback \
5 FROM pg_stat_database \
6 WHERE datname = $1;"
8 Param database
10 Column pg_numbackends
11 Column pg_xact commit
12 Column pg_xact rollback
13 </Query>
15 <Query user_tables>
16 Query "SELECT sum(seq_scan), sum(seq_tup_read), \
17 sum(idx_scan), sum(idx_tup_fetch), \
18 sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
19 sum(n_tup_hot_upd), sum(n_live_tup), sum(n_dead_tup) \
20 FROM pg_stat_user_tables"
22 Column pg_scan seq
23 Column pg_scan seq_tup_read
24 Column pg_scan idx
25 Column pg_scan idx_tup_fetch
26 Column pg_n_tup_c ins
27 Column pg_n_tup_c upd
28 Column pg_n_tup_c del
29 Column pg_n_tup_c hot_upd
30 Column pg_n_tup_g live
31 Column pg_n_tup_g dead
32 </Query>
34 <Query io_user_tables>
35 Query "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
36 sum(idx_blks_read), sum(idx_blks_hit), \
37 sum(toast_blks_read), sum(toast_blks_hit), \
38 sum(tidx_blks_read), sum(tidx_blks_hit) \
39 FROM pg_statio_user_tables;"
41 Column pg_blks heap_read
42 Column pg_blks heap_hit
43 Column pg_blks idx_read
44 Column pg_blks idx_hit
45 Column pg_blks toast_read
46 Column pg_blks toast_hit
47 Column pg_blks tidx_read
48 Column pg_blks tidx_hit
49 </Query>