postgresql

Postgres Template for InfluxDB v2

Provided by: Ignacio Van Droogenbroeck

This Dashboard offers you information about your Postgres instance. CPU Usage, RAM Usage, Deadlocks, Fetch, Update, Return Data and more.

Quick Install

InfluxDB UI

In the InfluxDB UI, go to Settings->Templates and enter this URL: https://raw.githubusercontent.com/influxdata/community-templates/master/postgresql/postgres.yml

Influx CLI

If you have your InfluxDB credentials configured in the CLI, you can install this template with:

influx apply -u https://raw.githubusercontent.com/influxdata/community-templates/master/postgresql/postgres.yml

Included Resources

• 1 Telegraf Configuration: 'postgres-config
• 1 Dashboards: 'Postgres'
• 1 Label: 'postgres'
• 1 Bucket: 'postgres'

Setup Instructions

General instructions on using InfluxDB Templates can be found in the use a template document.

Telegraf Configuration requires the following environment variables

• INFLUX_TOKEN - The token with the permissions to read Telegraf configs and write data to the telegraf bucket. You can just use your operator token to get started.
• INFLUX_ORG - The name of your Organization.
• INFLUX_HOST - The address of you InfluxDB
• INFLUX_BUCKET - The name of the Bucket. If you going to use the bucket included, you need to export the variable. Ex: export INFLUX_BUCKET=postgres

In order to use this Dashboard, you need to specify the connection string to the Postgres instance as variable. The same needs to define user and password (read only recommended)

ex: $ export PSQL_STRING_CONNECTIONG=postgres://postgres:mysecretpassword@localhost:5432

Contact

Author: Ignacio Van Droogenbroeck

Email: ignacio[at]vandroogenbroeck[dot]net

Github and Gitlab user: @xe-nvdk

Influx Slack: Ignacio Van Droogenbroeck