PostgreSQL plugin

This plugin

extracts metrics from a PostgreSQL database instance.

Prerequisites

Meter 4.2 or later must be installed.

The PostgreSQL plugin supports the following Operating Systems.

Linux	✅️
Windows	✅️
Smart OS	✅️
OS X	✅️

Plugin Setup

To install the PsycoPG2 library using pip

Install pip, if you do not have it installed.
$ curl -s https://bootstrap.pypa.io/get-pip.py > get-pip.py
$ sudo python get-pip.py
Install the psycopy2 module
$ pip install psycopg2

To install the plugin

From the top right of the screen, perform one of the following actions:
- Click > Data Collection, select the TrueSight meter, and select the Sources tab.
- Click > Configure Sources.
Use the search box or scroll through the page to find the source system which has the TrueSight meter on which you want to install the plugin.
Click the name of the source to view source details.
Select the Plugins tab.
Use the search box or scroll through the page to find the plugin you want to install.
Click + Install to start the installation.
Refer to the following sections for the configuration details required to collect data and view the list of plugin metrics.

Configuration details

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

Advanced configuration

To customize this plugin, see PostgreSQL plugin on GitHub.

Plugin metrics

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