telegraf-pgbouncer's Introduction

telegraph-pgbouncer

Poll pgBouncer for stats to submit to Telegraf using the Exec Input Plugin.

Usage

The application is meant to be used via the Exec Input Plugin

Example Telegraf Configuration

[[inputs.exec]]
  ## Commands array
  commands = [
    "telegraf-pgbouncer -h localhost -p 6432 -U monitor all"
  ]
  timeout = "5s"
  name_suffix = "_pgbouncer"
  data_format = "json"

CLI Usage

$ telegraf-pgbouncer --help
usage: pgBouncer Stats Collector for Telegraf

positional arguments:
  COMMAND               The SHOW command to run for extracting stats. Choices:
                        all, lists, databases, mem, pools, stats

optional arguments:
  -h HOST, --host HOST  database server host or socket directory (default: localhost)
  -p PORT, --port PORT  database server port number (default: 5432)
  -U USERNAME, --username USERNAME
                        The PostgreSQL username to operate as (default: pgbouncer)
  -W, --password        Force password prompt (should happen automatically)
                        (default: False)
  -v, --version         output version information, then exit
  -?, --help            show this help, then exit

Authentication

Specify the password in a .pgpass file for the application to connect properly without specifying a password.

telegraf-pgbouncer's People

Contributors

Stargazers

Watchers

telegraf-pgbouncer's Issues

question on input

Thanks for your work on this. It looks cool. Got a question.

How does the input (like for stats) which is output as dictionary...end up in influxdb? I don't see where you are identifying a key as described in the JSON doc. I was assuming the output should be an array where tag_keys = ["database"] and then the output for stats is:

[
{"database": "test",
  "avg_query_count": 8,
   "avg_query_time": 3309
},
{"database": "another_db",
  "avg_query_count": 4,
   "avg_query_time": 809
}
]

and the telegraf.conf file would be something like:

[[inputs.exec]]
  commands = ["<command to output stats here>"]
  data_format = "json"
  name_override = "stats_pgbouncer"
  tag_keys = ["database"]
  timeout = "5s"

Recommend Projects