src/postgresql_default.conf

   1 # Pre-defined queries of collectd's postgresql plugin.
   2
   3 <Query database>
   4         Query "SELECT numbackends, xact_commit, xact_rollback \
   5                 FROM pg_stat_database \
   6                 WHERE datname = $1;"
   7
   8         Param database
   9
  10         Column pg_numbackends
  11         Column pg_xact commit
  12         Column pg_xact rollback
  13 </Query>
  14
  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"
  21
  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>
  33
  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;"
  40
  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>
  50