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(tick)
Windows(tick)
Smart OS(tick)
OS X(tick)

Plugin Setup

To install the PsycoPG2 library using pip

  1. 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
  2. Install the psycopy2 module

     $ pip install psycopg2

To install the plugin

  1. From the top right of the screen, perform one of the following actions:
    • Click Settings > Data Collection, select the TrueSight meter, and select the Sources tab.

    • Click Settings > Configure Sources.
  2. 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.
  3. Click the name of the source to view source details.
  4. Select the Plugins tab.
  5. Use the search box or scroll through the page to find the plugin you want to install.
  6. 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 NameDescription
hostdatabase host name or IP
portPostgreSQL Port
databasedatabase name
usernamePostgreSQL username
passwordPostgreSQL Password (if not required put anything)
sourcedisplay name

Advanced configuration

To customize this plugin, see PostgreSQL plugin on GitHub.

Plugin metrics 

Metric NameDescription
PostgreSQL - Locks ExclusivePostgreSQL - Locks Exclusive
PostgreSQL - Locks Row ExclusivePostgreSQL - Locks Row Exclusive
PostgreSQL - Locks Share Row ExclusivePostgreSQL - Locks Share Row Exclusive
PostgreSQL - Locks Share Update Exclusive LocksPostgreSQL - Locks Share Update Exclusive Locks
PostgreSQL - Locks SharePostgreSQL - Locks Share
PostgreSQL - Locks Access SharePostgreSQL - Locks Access Share
PostgreSQL - Checkpoint Write TimePostgreSQL Checkpoint Write Time
PostgreSQL - Checkpoints TimedPostgreSQL - Checkpoints Timed
PostgreSQL - Buffers AllocatedPostgreSQL Buffers Allocated
PostgreSQL - Buffers CleanPostgreSQL - Buffers Clean
PostgreSQL - Buffers Backend FsyncPostgreSQL - Buffers Backend Fsync
PostgreSQL - Checkpoint Synchronization TimePostgreSQL - Checkpoint Synchronization Time
PostgreSQL - Checkpoints RequestedPostgreSQL - Checkpoints Requested
PostgreSQL - Buffers BackendPostgreSQL - Buffers Backend
PostgreSQL - Maximum Written CleanPostgreSQL - Maximum Written Clean
PostgreSQL - Buffers CheckpointPostgreSQL - Buffers Checkpoint
PostgreSQL - Blocks ReadPostgreSQL - Blocks Read
PostgreSQL - Disk SizePostgreSQL - Disk Size
PostgreSQL - Transaction CommittedPostgreSQL - Transaction Committed
PostgreSQL - Transactions RolledbackPostgreSQL - Transactions Rolledback
PostgreSQL - Blocks HitPostgreSQL - Blocks Hit
PostgreSQL - Tuples DeletedPostgreSQL - Tuples Deleted
PostgreSQL - Tuples FetchedPostgreSQL - Tuples Fetched
PostgreSQL - Tuples InsertedPostgreSQL - Tuples Inserted
PostgreSQL - Tuples ReturnedPostgreSQL - Tuples Returned
PostgreSQL - Tuples UpdatedPostgreSQL - Tuples Updated
Was this page helpful? Yes No Submitting... Thank you

Comments