src/postgresql_default.conf

   1 # Pre-defined queries of collectd's postgresql plugin.
   2
   3 <Query backends>
   4         Statement "SELECT count(*) AS count \
   5                 FROM pg_stat_activity \
   6                 WHERE datname = $1;"
   7
   8         Param database
   9
  10         <Result>
  11                 Type "pg_numbackends"
  12                 ValuesFrom "count"
  13         </Result>
  14 </Query>
  15
  16 <Query transactions>
  17         Statement "SELECT xact_commit, xact_rollback \
  18                 FROM pg_stat_database \
  19                 WHERE datname = $1;"
  20
  21         Param database
  22
  23         <Result>
  24                 Type "pg_xact"
  25                 InstancePrefix "commit"
  26                 ValuesFrom "xact_commit"
  27         </Result>
  28         <Result>
  29                 Type "pg_xact"
  30                 InstancePrefix "rollback"
  31                 ValuesFrom "xact_rollback"
  32         </Result>
  33 </Query>
  34
  35 <Query queries>
  36         Statement "SELECT sum(n_tup_ins) AS ins, \
  37                         sum(n_tup_upd) AS upd, \
  38                         sum(n_tup_del) AS del \
  39                 FROM pg_stat_user_tables;"
  40
  41         <Result>
  42                 Type "pg_n_tup_c"
  43                 InstancePrefix "ins"
  44                 ValuesFrom "ins"
  45         </Result>
  46         <Result>
  47                 Type "pg_n_tup_c"
  48                 InstancePrefix "upd"
  49                 ValuesFrom "upd"
  50         </Result>
  51         <Result>
  52                 Type "pg_n_tup_c"
  53                 InstancePrefix "del"
  54                 ValuesFrom "del"
  55         </Result>
  56
  57         MaxPGVersion 80299
  58 </Query>
  59
  60 <Query queries>
  61         Statement "SELECT sum(n_tup_ins) AS ins, \
  62                         sum(n_tup_upd) AS upd, \
  63                         sum(n_tup_del) AS del, \
  64                         sum(n_tup_hot_upd) AS hot_upd \
  65                 FROM pg_stat_user_tables;"
  66
  67         <Result>
  68                 Type "pg_n_tup_c"
  69                 InstancePrefix "ins"
  70                 ValuesFrom "ins"
  71         </Result>
  72         <Result>
  73                 Type "pg_n_tup_c"
  74                 InstancePrefix "upd"
  75                 ValuesFrom "upd"
  76         </Result>
  77         <Result>
  78                 Type "pg_n_tup_c"
  79                 InstancePrefix "del"
  80                 ValuesFrom "del"
  81         </Result>
  82         <Result>
  83                 Type "pg_n_tup_c"
  84                 InstancePrefix "hot_upd"
  85                 ValuesFrom "hot_upd"
  86         </Result>
  87
  88         MinPGVersion 80300
  89 </Query>
  90
  91 <Query query_plans>
  92         Statement "SELECT sum(seq_scan) AS seq, \
  93                         sum(seq_tup_read) AS seq_tup_read, \
  94                         sum(idx_scan) AS idx, \
  95                         sum(idx_tup_fetch) AS idx_tup_fetch \
  96                 FROM pg_stat_user_tables;"
  97
  98         <Result>
  99                 Type "pg_scan"
 100                 InstancePrefix "seq"
 101                 ValuesFrom "seq"
 102         </Result>
 103         <Result>
 104                 Type "pg_scan"
 105                 InstancePrefix "seq_tup_read"
 106                 ValuesFrom "seq_tup_read"
 107         </Result>
 108         <Result>
 109                 Type "pg_scan"
 110                 InstancePrefix "idx"
 111                 ValuesFrom "idx"
 112         </Result>
 113         <Result>
 114                 Type "pg_scan"
 115                 InstancePrefix "idx_tup_fetch"
 116                 ValuesFrom "idx_tup_fetch"
 117         </Result>
 118 </Query>
 119
 120 <Query table_states>
 121         Statement "SELECT sum(n_live_tup) AS live, sum(n_dead_tup) AS dead \
 122                 FROM pg_stat_user_tables;"
 123
 124         <Result>
 125                 Type "pg_n_tup_g"
 126                 InstancePrefix "live"
 127                 ValuesFrom "live"
 128         </Result>
 129         <Result>
 130                 Type "pg_n_tup_g"
 131                 InstancePrefix "dead"
 132                 ValuesFrom "dead"
 133         </Result>
 134
 135         MinPGVersion 80300
 136 </Query>
 137
 138 <Query disk_io>
 139         Statement "SELECT sum(heap_blks_read) AS heap_read, \
 140                         sum(heap_blks_hit) AS heap_hit, \
 141                         sum(idx_blks_read) AS idx_read, \
 142                         sum(idx_blks_hit) AS idx_hit, \
 143                         sum(toast_blks_read) AS toast_read, \
 144                         sum(toast_blks_hit) AS toast_hit, \
 145                         sum(tidx_blks_read) AS tidx_read, \
 146                         sum(tidx_blks_hit) AS tidx_hit \
 147                 FROM pg_statio_user_tables;"
 148
 149         <Result>
 150                 Type "pg_blks"
 151                 InstancePrefix "heap_read"
 152                 ValuesFrom "heap_read"
 153         </Result>
 154         <Result>
 155                 Type "pg_blks"
 156                 InstancePrefix "heap_hit"
 157                 ValuesFrom "heap_hit"
 158         </Result>
 159         <Result>
 160                 Type "pg_blks"
 161                 InstancePrefix "idx_read"
 162                 ValuesFrom "idx_read"
 163         </Result>
 164         <Result>
 165                 Type "pg_blks"
 166                 InstancePrefix "idx_hit"
 167                 ValuesFrom "idx_hit"
 168         </Result>
 169         <Result>
 170                 Type "pg_blks"
 171                 InstancePrefix "toast_read"
 172                 ValuesFrom "toast_read"
 173         </Result>
 174         <Result>
 175                 Type "pg_blks"
 176                 InstancePrefix "toast_hit"
 177                 ValuesFrom "toast_hit"
 178         </Result>
 179         <Result>
 180                 Type "pg_blks"
 181                 InstancePrefix "tidx_read"
 182                 ValuesFrom "tidx_read"
 183         </Result>
 184         <Result>
 185                 Type "pg_blks"
 186                 InstancePrefix "tidx_hit"
 187                 ValuesFrom "tidx_hit"
 188         </Result>
 189 </Query>
 190
 191 <Query disk_usage>
 192         Statement "SELECT pg_database_size($1) AS size;"
 193
 194         Param database
 195
 196         <Result>
 197                 Type pg_db_size
 198                 ValuesFrom "size"
 199         </Result>
 200 </Query>
 201
 202 # vim: set ft=config :
 203