1 # Pre-defined queries of collectd's postgresql plugin.
4 Query "SELECT numbackends, xact_commit, xact_rollback \
5 FROM pg_stat_database \
12 Column pg_xact rollback
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"
23 Column pg_scan seq_tup_read
25 Column pg_scan idx_tup_fetch
29 Column pg_n_tup_c hot_upd
30 Column pg_n_tup_g live
31 Column pg_n_tup_g dead
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