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