PostgreSQL Data Collector Edit on GitHub Request doc changes

Contributors netapp-alavoie

Cloud Insights uses this data collector to gather metrics from PostgreSQL.

Installation

  1. From Admin > Data Collectors, click +Data Collector. Under Services, choose PostgreSQL.

    Select the Operating System or Platform on which the Telegraf agent is installed.

  2. If you haven’t already installed an Agent for collection, or you wish to install an Agent for a different Operating System or Platform, click Show Instructions to expand the Agent installation instructions.

  3. Select the Agent Access Key for use with this data collector. You can add a new Agent Access Key by clicking the + Agent Access Key button. Best practice: Use a different Agent Access Key only when you want to group data collectors, for example, by OS/Platform.

  4. Follow the configuration steps to configure the data collector. The instructions vary depending on the type of Operating System or Platform you are using to collect data.

PostgreSQL configuration

Setup

Information may be found in the PostgreSQL documentation.

Objects and Counters

The following objects and their counters are collected:

Object: Identifiers: Attributes: Datapoints:

PostgreSQL Server

Namespace
Database
Server

Node Name
Node IP

Buffers Allocated
Buffers Backend
Buffers Backend File Sync
Buffers Checkpoint
Buffers Clean
Checkpoints Sync Time
Checkpoints Write Time
Checkpoints Requests
Checkpoints Timed
Max Written Clean

PostgreSQL Database

Namespace
Database
Server

Database OID
Node Name
Node IP

Blocks Read Time
Blocks Write Time
Blocks Hits
Blocks Reads
Conflicts
Deadlocks
Client Number
Temp Files Bytes
Temp Files Number
Rows Deleted
Rows Fetched
Rows Inserted
Rows Returned
Rows Updated
Transactions Committed
Transactions Rollbacked

Troubleshooting

Additional information may be found from the Support page.