src/postgresql_default.conf

   1 # Pre-defined queries of collectd's postgresql plugin.
   2
   3 <Query user_tables>
   4         Query "SELECT sum(seq_scan), sum(seq_tup_read), \
   5                         sum(idx_scan), sum(idx_tup_fetch), \
   6                         sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
   7                         sum(n_tup_hot_upd), sum(n_live_tup), sum(n_dead_tup) \
   8                 FROM pg_stat_user_tables"
   9
  10         Column pg_scan    seq
  11         Column pg_scan    seq_tup_read
  12         Column pg_scan    idx
  13         Column pg_scan    idx_tup_fetch
  14         Column pg_n_tup_c ins
  15         Column pg_n_tup_c upd
  16         Column pg_n_tup_c del
  17         Column pg_n_tup_c hot_upd
  18         Column pg_n_tup_g live
  19         Column pg_n_tup_g dead
  20 </Query>
  21
  22 <Query io_user_tables>
  23         Query "SELECT sum(heap_blks_read), sum(heap_blks_hit), \
  24                         sum(idx_blks_read), sum(idx_blks_hit), \
  25                         sum(toast_blks_read), sum(toast_blks_hit), \
  26                         sum(tidx_blks_read), sum(tidx_blks_hit) \
  27                 FROM pg_statio_user_tables;"
  28
  29         Column pg_blks heap_read
  30         Column pg_blks heap_hit
  31         Column pg_blks idx_read
  32         Column pg_blks idx_hit
  33         Column pg_blks toast_read
  34         Column pg_blks toast_hit
  35         Column pg_blks tidx_read
  36         Column pg_blks tidx_hit
  37 </Query>
  38