This page provides an overview of what you can do with the PostgreSQL integration. The documentation pages only for a limited number of integrations contain the setup steps and instructions. If you do not see the setup steps here, navigate to the Operations for Applications GUI. The detailed instructions for setting up and configuring all integrations, including the PostgreSQL integration are on the Setup tab of the integration.
- Log in to your Operations for Applications instance.
- Click Integrations on the toolbar, search for and click the PostgreSQL tile.
- Click the Setup tab and you will see the most recent and up-to-date instructions.
PostgreSQL Integration
PostgreSQL is a popular open source database. This integration installs and configures Telegraf to send PostgreSQL server metrics into Wavefront. Telegraf is a light-weight server process capable of collecting, processing, aggregating, and sending metrics to a Wavefront proxy.
In addition to setting up the metrics flow, this integration also installs a dashboard. Here’s the databases section of a dashboard displaying PostgreSQL metrics:
Metrics
For details about these metrics, see the PostgreSQL Statistics Collector documentation.
| Metric Name | Description |
|---|---|
| postgresql.blk.* | Read and write time for a block. |
| postgresql.blk.read.time | |
| postgresql.blk.write.time | |
| postgresql.blks.* | Number of blocks hit and read. |
| postgresql.blks.hit | |
| postgresql.blks.read | |
| postgresql.buffers.* | Buffer metrics. |
| postgresql.buffers.alloc | |
| postgresql.buffers.backend | |
| postgresql.buffers.backend.fsync | |
| postgresql.buffers.checkpoint | |
| postgresql.buffers.clean | |
| postgresql.checkpoint.* | Checkpoint metrics. |
| postgresql.checkpoint.sync.time | |
| postgresql.checkpoint.write.time | |
| postgresql.checkpoints.req | |
| postgresql.checkpoints.timed | |
| postgresql.conflicts | Number of queries that were canceled due to recovery conflicts. |
| postgresql.datid | |
| postgresql.deadlocks | Number of deadlocks. |
| postgresql.maxwritten.clean | Number of times the background writer stopped a cleaning scan because it had written too many buffers. |
| postgresql.numbackends | Number of buffers written directly by a backend. |
| postgresql.temp.* | Temp metrics. |
| postgresql.temp.bytes | |
| postgresql.temp.files | |
| postgresql.tup.* | Metrics for the number of rows deleted, fetched, inserted, etc. |
| postgresql.tup.deleted | |
| postgresql.tup.fetched | |
| postgresql.tup.inserted | |
| postgresql.tup.returned | |
| postgresql.tup.updated | |
| postgresql.xact.commit | Number of committed transactions. |
| postgresql.xact.rollback | Number of rolled back transactions. |