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                 FROM pg_stat_user_tables;"
  27
  28         Column pg_n_tup_c ins
  29         Column pg_n_tup_c upd
  30         Column pg_n_tup_c del
  31
  32         MaxPGVersion 80299
  33 </Query>
  34
  35 <Query queries>
  36         Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
  37                         sum(n_tup_hot_upd) \
  38                 FROM pg_stat_user_tables;"
  39
  40         Column pg_n_tup_c ins
  41         Column pg_n_tup_c upd
  42         Column pg_n_tup_c del
  43         Column pg_n_tup_c hot_upd
  44
  45         MinPGVersion 80300
  46 </Query>
  47
  48 <Query query_plans>
  49         Query "SELECT sum(seq_scan), sum(seq_tup_read), \
  50                         sum(idx_scan), sum(idx_tup_fetch) \
  51                 FROM pg_stat_user_tables;"
  52
  53         Column pg_scan seq
  54         Column pg_scan seq_tup_read
  55         Column pg_scan idx
  56         Column pg_scan idx_tup_fetch
  57 </Query>
  58
  59 <Query table_states>
  60         Query "SELECT sum(n_live_tup), sum(n_dead_tup) \
  61                 FROM pg_stat_user_tables;"
  62
  63         Column pg_n_tup_g live
  64         Column pg_n_tup_g dead
  65
  66         MinPGVersion 80300
  67 </Query>
  68
  69 <Query disk_io>
  70         Query "SELECT coalesce(sum(heap_blks_read), 0), \
  71                         coalesce(sum(heap_blks_hit), 0), \
  72                         coalesce(sum(idx_blks_read), 0), \
  73                         coalesce(sum(idx_blks_hit), 0), \
  74                         coalesce(sum(toast_blks_read), 0), \
  75                         coalesce(sum(toast_blks_hit), 0), \
  76                         coalesce(sum(tidx_blks_read), 0), \
  77                         coalesce(sum(tidx_blks_hit), 0) \
  78                 FROM pg_statio_user_tables;"
  79
  80         Column pg_blks heap_read
  81         Column pg_blks heap_hit
  82         Column pg_blks idx_read
  83         Column pg_blks idx_hit
  84         Column pg_blks toast_read
  85         Column pg_blks toast_hit
  86         Column pg_blks tidx_read
  87         Column pg_blks tidx_hit
  88 </Query>
  89
  90 <Query disk_usage>
  91         Query "SELECT pg_database_size($1);"
  92
  93         Param database
  94
  95         Column pg_db_size
  96 </Query>
  97
  98 # vim: set ft=config :
  99