src/postgresql_default.conf

   1 # Pre-defined queries of collectd's postgresql plugin.
   2
   3 <Query backends>
   4         Query "SELECT count(*) \
   5                 FROM pg_stat_activity \
   6                 WHERE datname = $1;"
   7
   8         Param database
   9
  10         Column pg_numbackends
  11 </Query>
  12
  13 <Query transactions>
  14         Query "SELECT xact_commit, xact_rollback \
  15                 FROM pg_stat_database \
  16                 WHERE datname = $1;"
  17
  18         Param database
  19
  20         Column pg_xact commit
  21         Column pg_xact rollback
  22 </Query>
  23
  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;"
  28
  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>
  34
  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;"
  39
  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>
  45
  46 <Query table_states>
  47         Query "SELECT sum(n_live_tup), sum(n_dead_tup) \
  48                 FROM pg_stat_user_tables;"
  49
  50         Column pg_n_tup_g live
  51         Column pg_n_tup_g dead
  52 </Query>
  53
  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;"
  60
  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>
  70
  71 <Query disk_usage>
  72         Query "SELECT pg_database_size($1);"
  73
  74         Param database
  75
  76         Column pg_db_size
  77 </Query>
  78