PostgreSQL Metrics
See also: PostgreSQL integration information.
Metric Name | Type | Description |
---|---|---|
| gauge | The number of sequential scans initiated on this table. |
| gauge | The number of index scans initiated on this table. |
| gauge | The number of live rows fetched by index scans. |
| gauge | The number of rows HOT updated, meaning no separate index update was needed. |
| gauge | The estimated number of live rows. |
| gauge | The estimated number of dead rows. |
| gauge | The number of index entries returned by scans on this index. |
| gauge | The total disk space used by the specified table. Includes TOAST, free space map, and visibility map. Excludes indexes. |
| gauge | The total disk space used by indexes attached to the specified table. |
| gauge | The total disk space used by the table, including indexes and TOAST data. |
| gauge | The number of disk blocks read from this table. |
| gauge | The number of buffer hits in this table. |
| gauge | The number of disk blocks read from all indexes on this table. |
| gauge | The number of buffer hits in all indexes on this table. |
| gauge | The number of disk blocks read from this table's TOAST table. |
| gauge | The number of buffer hits in this table's TOAST table. |
| gauge | The number of disk blocks read from this table's TOAST table index. |
| gauge | The number of buffer hits in this table's TOAST table index. |
| gauge | The number of active queries in this database. |
| gauge | The number of WAL files that have been successfully archived. |
| gauge | The number of failed attempts for archiving WAL files. |
| gauge | The number of transactions that can occur until a transaction wraparound. |
| rate | The number of live rows fetched by index scans. |
| gauge | The number of 'idle in transaction' transactions in this database. |
| gauge | The number of open transactions in this database. |
| gauge | The number of waiting queries in this database. |
| gauge | The number of buffers allocated |
| gauge | The number of buffers written directly by a backend. |
| gauge | The of times a backend had to execute its own fsync call instead of the background writer. |
| gauge | The number of buffers written during checkpoints. |
| gauge | The number of buffers written by the background writer. |
| gauge | The number of requested checkpoints that were performed. |
| gauge | The number of scheduled checkpoints that were performed. |
| gauge. | The number of times the background writer stopped a cleaning scan due to writing too many buffers. |
| gauge | The total amount of checkpoint processing time spent synchronizing files to disk. |
| gauge | The total amount of checkpoint processing time spent writing files to disk. |
| gauge | The number of times disk blocks were found in the buffer cache, preventing the need to read from the database. |
| gauge | The number of transactions that have been committed in this database. |
| gauge | The number of active connections to this database. |
| gauge | The disk space used by this database. |
| gauge | The number of deadlocks detected in this database |
| gauge | The number of disk blocks read in this database. |
| gauge | The number of locks active for this database. |
| gauge | The maximum number of client connections allowed to this database. |
| gauge | The number of connections to this database as a fraction of the maximum number of allowed connections. |
| gauge | The current replication delay in seconds. Only available with PostgreSQL 9.1 and newer. |
| gauge | The current replication delay in bytes. Only available with PostgreSQL 9.2 and newer. |
| gauge | The number of transactions that have been rolled back in this database. |
| gauge | The number of rows deleted by queries in this database. |
| gauge | The number of rows fetched by queries in this database. |
| gauge | The number of rows inserted by queries in this database. The metrics can be segmented by 'db' or 'table' and can be viewed per-relation. |
| gauge | The number of rows returned by queries in this database. The metrics can be segmented by 'db' or 'table' and can be viewed per-relation. |
| gauge | The number of rows updated by queries in this database. |
| gauge | The number of rows deleted by queries in this database. The metrics can be segmented by 'db' or 'table' and can be viewed per-relation. |
| gauge | The number of user tables in this database. |
| gauge | The amount of data written to temporary files by queries in this database. |
| gauge | The number of temporary files created by queries in this database. |
| gauge | The number of disk blocks read from this table's TOAST table. |
| gauge | The number of 'idle in transaction' transactions in this database. |
| gauge | The number of open transactions in this database. |