pgbouncer

package

v0.0.0-...-6ade924 Latest Latest Go to latest Published: Oct 8, 2022 License: GPL-3.0 Imports: 13 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/bflanigan-sfdc/go.d.plugin

README ¶

PgBouncer monitoring with Netdata

PgBouncer is an open-source connection pooler for PostgreSQL.

This module monitors one or more PgBouncer servers, depending on your configuration.

Executed queries:

SHOW VERSION;
SHOW CONFIG;
SHOW DATABASES;
SHOW STATS;
SHOW POOLS;

Information about the queries can be found in the PgBouncer Documentation.

Requirements

PgBouncer v1.8.0+.
A user with stats_users permissions to query your PgBouncer instance.

To create the netdata user:

Add netdata user to the pgbouncer.ini file:
```
stats_users = netdata
```
Add a password for the netdata user to the userlist.txt file:
```
"netdata" "<PASSWORD>"
```
To verify the credentials, run the following command
```
psql -h localhost -U netdata -p 6432 pgbouncer -c "SHOW VERSION;" >/dev/null 2>&1 && echo OK || echo FAIL
```
When it prompts for a password, enter the password you added to userlist.txt.

Metrics

All metrics have "pgbouncer." prefix.

Metric	Scope	Dimensions	Units
client_connections_utilization	global	used	percentage
db_client_connections	database	active, waiting, cancel_req	connections
db_server_connections	database	active, idle, used, tested, login	connections
db_server_connections_utilization	database	used	percentage
db_clients_wait_time	database	time	seconds
db_client_max_wait_time	database	time	seconds
db_transactions	database	transactions	transactions/s
db_transactions_time	database	time	seconds
db_transaction_avg_time	database	time	seconds
db_queries	database	queries	queries/s
db_queries_time	database	time	seconds
db_query_avg_time	database	time	seconds
db_network_io	database	received, sent	B/s

Configuration

Edit the go.d/pgbouncer.conf configuration file using edit-config from the Netdata config directory, which is typically at /etc/netdata.

cd /etc/netdata # Replace this path with your Netdata config directory
sudo ./edit-config go.d/pgbouncer.conf

DSN (Data Source Name) may either be in URL format or key=word format. See Connection Strings for details.

jobs:
  - name: local
    dsn: 'postgres://postgres:postgres@127.0.0.1:6432/pgbouncer'

  - name: local
    dsn: 'host=/tmp dbname=pgbouncer user=postgres port=6432'

  - name: remote
    dsn: 'postgres://postgres:postgres@203.0.113.10:6432/pgbouncer'

For all available options see module configuration file.

Troubleshooting

To troubleshoot issues with the pgbouncer collector, run the go.d.plugin with the debug option enabled. The output should give you clues as to why the collector isn't working.

Navigate to the plugins.d directory, usually at /usr/libexec/netdata/plugins.d/. If that's not the case on your system, open netdata.conf and look for the plugins setting under [directories].
```
cd /usr/libexec/netdata/plugins.d/
```
Switch to the netdata user.
```
sudo -u netdata -s
```
Run the go.d.plugin to debug the collector:
```
./go.d.plugin -d -m pgbouncer
```

Documentation ¶

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

This section is empty.

Types ¶

type Config ¶

type Config struct {
	DSN     string       `yaml:"dsn"`
	Timeout web.Duration `yaml:"timeout"`
}

type PgBouncer ¶

type PgBouncer struct {
	module.Base
	Config `yaml:",inline"`
	// contains filtered or unexported fields
}

func New ¶

func New() *PgBouncer

func (*PgBouncer) Charts ¶

func (p *PgBouncer) Charts() *module.Charts

func (*PgBouncer) Check ¶

func (p *PgBouncer) Check() bool

func (*PgBouncer) Cleanup ¶

func (p *PgBouncer) Cleanup()

func (*PgBouncer) Collect ¶

func (p *PgBouncer) Collect() map[string]int64

func (*PgBouncer) Init ¶

func (p *PgBouncer) Init() bool

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL