PostgreSQL Metrics

See also: PostgreSQL integration information.

Metric Name	Type	Description
`postgresql.seq_scans`	gauge	The number of sequential scans initiated on this table.
`postgresql.index_scans`	gauge	The number of index scans initiated on this table.
`postgresql.index_rows_fetched`	gauge	The number of live rows fetched by index scans.
`postgresql.rows_hot_updated`	gauge	The number of rows HOT updated, meaning no separate index update was needed.
`postgresql.live_rows`	gauge	The estimated number of live rows.
`postgresql.dead_rows`	gauge	The estimated number of dead rows.
`postgresql.index_rows_read`	gauge	The number of index entries returned by scans on this index.
`postgresql.table_size`	gauge	The total disk space used by the specified table. Includes TOAST, free space map, and visibility map. Excludes indexes.
`postgresql.index_size`	gauge	The total disk space used by indexes attached to the specified table.
`postgresql.total_size`	gauge	The total disk space used by the table, including indexes and TOAST data.
`postgresql.heap_blocks_read`	gauge	The number of disk blocks read from this table.
`postgresql.heap_blocks_hit`	gauge	The number of buffer hits in this table.
`postgresql.index_blocks_read`	gauge	The number of disk blocks read from all indexes on this table.
`postgresql.index_blocks_hit`	gauge	The number of buffer hits in all indexes on this table.
`postgresql.toast_blocks_read`	gauge	The number of disk blocks read from this table's TOAST table.
`postgresql.toast_blocks_hit`	gauge	The number of buffer hits in this table's TOAST table.
`postgresql.toast_index_blocks_read`	gauge	The number of disk blocks read from this table's TOAST table index.
`postgresql.toast_index_blocks_hit`	gauge	The number of buffer hits in this table's TOAST table index.
`postgresql.active_queries`	gauge	The number of active queries in this database.
`postgresql.archiver.archived_count`	gauge	The number of WAL files that have been successfully archived.
`postgresql.archiver.failed_count`	gauge	The number of failed attempts for archiving WAL files.
`postgresql.before_xid_wraparound`	gauge	The number of transactions that can occur until a transaction wraparound.
`postgresql.index_rel_rows_fetched`	rate	The number of live rows fetched by index scans.
`postgresql.transactions.idle_in_transaction`	gauge	The number of 'idle in transaction' transactions in this database.
`postgresql.transactions.open`	gauge	The number of open transactions in this database.
`postgresql.waiting_queries`	gauge	The number of waiting queries in this database.
`postgresql.waiting_queries`	gauge	The number of buffers allocated
`postgresql.bgwriter.buffers_backend`	gauge	The number of buffers written directly by a backend.
`postgresql.bgwriter.buffers_backend_fsync`	gauge	The of times a backend had to execute its own fsync call instead of the background writer.
`postgresql.bgwriter.buffers_checkpoint`	gauge	The number of buffers written during checkpoints.
`postgresql.bgwriter.buffers_clean`	gauge	The number of buffers written by the background writer.
`postgresql.bgwriter.checkpoints_requested`	gauge	The number of requested checkpoints that were performed.
`postgresql.bgwriter.checkpoints_timed`	gauge	The number of scheduled checkpoints that were performed.
`postgresql.bgwriter.maxwritten_clean`	gauge.	The number of times the background writer stopped a cleaning scan due to writing too many buffers.
`postgresql.bgwriter.sync_time`	gauge	The total amount of checkpoint processing time spent synchronizing files to disk.
`postgresql.bgwriter.write_time`	gauge	The total amount of checkpoint processing time spent writing files to disk.
`postgresql.buffer_hit`	gauge	The number of times disk blocks were found in the buffer cache, preventing the need to read from the database.
`postgresql.commits`	gauge	The number of transactions that have been committed in this database.
`postgresql.connections`	gauge	The number of active connections to this database.
`postgresql.database_size`	gauge	The disk space used by this database.
`postgresql.deadlocks`	gauge	The number of deadlocks detected in this database
`postgresql.disk_read`	gauge	The number of disk blocks read in this database.
`postgresql.locks`	gauge	The number of locks active for this database.
`postgresql.max_connections`	gauge	The maximum number of client connections allowed to this database.
`postgresql.percent_usage_connections`	gauge	The number of connections to this database as a fraction of the maximum number of allowed connections.
`postgresql.replication_delay`	gauge	The current replication delay in seconds. Only available with PostgreSQL 9.1 and newer.
`postgresql.replication_delay_bytes`	gauge	The current replication delay in bytes. Only available with PostgreSQL 9.2 and newer.
`postgresql.rollbacks`	gauge	The number of transactions that have been rolled back in this database.
`postgresql.rows_deleted`	gauge	The number of rows deleted by queries in this database.
`postgresql.rows_fetched`	gauge	The number of rows fetched by queries in this database.
`postgresql.rows_inserted`	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.
`postgresql.rows_returned`	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.
`postgresql.rows_updated`	gauge	The number of rows updated by queries in this database.
`postgresql.rows_deleted`	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.
`postgresql.table.count`	gauge	The number of user tables in this database.
`postgresql.temp_bytes`	gauge	The amount of data written to temporary files by queries in this database.
`postgresql.temp_files`	gauge	The number of temporary files created by queries in this database.
`postgresql.toast_blocks_read`	gauge	The number of disk blocks read from this table's TOAST table.
`postgresql.transactions.idle_in_transaction`	gauge	The number of 'idle in transaction' transactions in this database.
`postgresql.transactions.open`	gauge	The number of open transactions in this database.

PostgreSQL Metrics

Search results