postgresql

README

PostgreSQL Input Plugin

This postgresql plugin provides metrics for your postgres database. It currently works with postgres versions 8.1+. It uses data from the built in pg_stat_database and pg_stat_bgwriter views. The metrics recorded depend on your version of postgres. See table:

pg version      9.2+   9.1   8.3-9.0   8.1-8.2   7.4-8.0(unsupported)
---             ---    ---   -------   -------   -------
datid            x      x       x         x
datname          x      x       x         x
numbackends      x      x       x         x         x
xact_commit      x      x       x         x         x
xact_rollback    x      x       x         x         x
blks_read        x      x       x         x         x
blks_hit         x      x       x         x         x
tup_returned     x      x       x
tup_fetched      x      x       x
tup_inserted     x      x       x
tup_updated      x      x       x
tup_deleted      x      x       x
conflicts        x      x
temp_files       x
temp_bytes       x
deadlocks        x
blk_read_time    x
blk_write_time   x
stats_reset*     x      x

* value ignored and therefore not recorded.

More information about the meaning of these metrics can be found in the PostgreSQL Documentation

Configuration

Specify address via a postgresql connection string:

host=localhost port=5432 user=cua database=cua

Or via an url matching:

postgres://[pqgotest[:password]]@host:port[/dbname]?sslmode=[disable|verify-ca|verify-full]

All connection parameters are optional. Without the dbname parameter, the driver will default to a database with the same name as the user. This dbname is just for instantiating a connection with the server and doesn't restrict the databases we are trying to grab metrics for.

A list of databases to explicitly ignore. If not specified, metrics for all databases are gathered. Do NOT use with the 'databases' option.

ignored_databases = ["postgres", "template0", "template1"]

A list of databases to pull metrics about. If not specified, metrics for all databases are gathered. Do NOT use with the 'ignored_databases' option.

databases = ["app_production", "testing"]

TLS Configuration

Add the sslkey, sslcert and sslrootcert options to your DSN:

host=localhost user=pgotest dbname=app_production sslmode=require sslkey=/etc/circonus-unified-agent/key.pem sslcert=/etc/circonus-unified-agent/cert.pem sslrootcert=/etc/circonus-unified-agent/ca.pem

Configuration example

[[inputs.postgresql]]
  address = "postgres://cua@localhost/someDB"
  ignored_databases = ["template0", "template1"]

Documentation

Index

• type Postgresql
  • func (p *Postgresql) Description() string
  • func (p *Postgresql) Gather(ctx context.Context, acc cua.Accumulator) error
  • func (p *Postgresql) IgnoredColumns() map[string]bool
  • func (p *Postgresql) SampleConfig() string
• type Service
  • func (p *Service) SanitizedAddress() (sanitizedAddress string, err error)
  • func (p *Service) Start(ctx context.Context, acc cua.Accumulator) (err error)
  • func (p *Service) Stop()

Types

type Postgresql

type Postgresql struct {
	Service
	Databases        []string
	IgnoredDatabases []string
}

func (*Postgresql) Description

func (p *Postgresql) Description() string

func (*Postgresql) Gather

func (p *Postgresql) Gather(ctx context.Context, acc cua.Accumulator) error

func (*Postgresql) IgnoredColumns

func (p *Postgresql) IgnoredColumns() map[string]bool

func (*Postgresql) SampleConfig

func (p *Postgresql) SampleConfig() string

type Service

type Service struct {
	Address       string
	Outputaddress string
	MaxIdle       int
	MaxOpen       int
	MaxLifetime   internal.Duration
	DB            *sql.DB
	IsPgBouncer   bool
}

Service common functionality shared between the postgresql and postgresql_extensible packages.

func (*Service) SanitizedAddress

func (p *Service) SanitizedAddress() (sanitizedAddress string, err error)

SanitizedAddress utility function to strip sensitive information from the connection string.

func (*Service) Start

func (p *Service) Start(ctx context.Context, acc cua.Accumulator) (err error)

Start starts the ServiceInput's service, whatever that may be

func (*Service) Stop

func (p *Service) Stop()

Stop stops the services and closes any necessary channels and connections