Boundary PostgreSQL Plugin

Extracts metrics from a PostgreSQL database instance.

Prerequisites

Supported OS

OS	Linux	Windows	SmartOS	OS X
Supported	v	v	v	v

Boundary Meter Versions V4.0 or later

• To install new meter go to Settings->Installation or [see instructons|https://help.boundary.com/hc/en-us/sections/200634331-Installation].
• To upgrade the meter to the latest version - [see instructons|https://help.boundary.com/hc/en-us/articles/201573102-Upgrading-the-Boundary-Meter].

For Boundary Meter less than V4.0

Runtime	node.js	Python	Java
Required		+

• How to install Python?
• Python libraries: PsycoPG2, postgresql-devel, python-devel

Plugin Setup

For Boundary Meter Versions Less than V4.0

Installation of the PsycoPG2 Library Using pip

1. Install pip if not already installed

    $ curl -s https://bootstrap.pypa.io/get-pip.py > get-pip.py
    $ sudo python get-pip.py

2. Install the psycopy2 module

    $ pip install psycopg2

Plugin Configuration Fields

For All Versions

Field Name	Description
host	database host name or IP
port	PostgreSQL Port
database	database name
username	PostgreSQL username
password	PostgreSQL Password (if not required put anything)
source	display name

Metrics Collected

For All Versions

Metric Name	Description
PostgreSQL - Locks Exclusive	PostgreSQL - Locks Exclusive
PostgreSQL - Locks Row Exclusive	PostgreSQL - Locks Row Exclusive
PostgreSQL - Locks Share Row Exclusive	PostgreSQL - Locks Share Row Exclusive
PostgreSQL - Locks Share Update Exclusive Locks	PostgreSQL - Locks Share Update Exclusive Locks
PostgreSQL - Locks Share	PostgreSQL - Locks Share
PostgreSQL - Locks Access Share	PostgreSQL - Locks Access Share
PostgreSQL - Checkpoint Write Time	PostgreSQL Checkpoint Write Time
PostgreSQL - Checkpoints Timed	PostgreSQL - Checkpoints Timed
PostgreSQL - Buffers Allocated	PostgreSQL Buffers Allocated
PostgreSQL - Buffers Clean	PostgreSQL - Buffers Clean
PostgreSQL - Buffers Backend Fsync	PostgreSQL - Buffers Backend Fsync
PostgreSQL - Checkpoint Synchronization Time	PostgreSQL - Checkpoint Synchronization Time
PostgreSQL - Checkpoints Requested	PostgreSQL - Checkpoints Requested
PostgreSQL - Buffers Backend	PostgreSQL - Buffers Backend
PostgreSQL - Maximum Written Clean	PostgreSQL - Maximum Written Clean
PostgreSQL - Buffers Checkpoint	PostgreSQL - Buffers Checkpoint
PostgreSQL - Blocks Read	PostgreSQL - Blocks Read
PostgreSQL - Disk Size	PostgreSQL - Disk Size
PostgreSQL - Transaction Committed	PostgreSQL - Transaction Committed
PostgreSQL - Transactions Rolledback	PostgreSQL - Transactions Rolledback
PostgreSQL - Blocks Hit	PostgreSQL - Blocks Hit
PostgreSQL - Tuples Deleted	PostgreSQL - Tuples Deleted
PostgreSQL - Tuples Fetched	PostgreSQL - Tuples Fetched
PostgreSQL - Tuples Inserted	PostgreSQL - Tuples Inserted
PostgreSQL - Tuples Returned	PostgreSQL - Tuples Returned
PostgreSQL - Tuples Updated	PostgreSQL - Tuples Updated