postgresql.connections (gauge) | The number of active connections to this database. If DBM is enabled, this metric is tagged with state, app, db and user Shown as connection |
postgresql.commits (gauge) | The number of transactions that have been committed in this database. Shown as transaction |
postgresql.rollbacks (gauge) | The number of transactions that have been rolled back in this database. Shown as transaction |
postgresql.disk_read (gauge) | The number of disk blocks read in this database. Shown as block |
postgresql.buffer_hit (gauge) | The number of times disk blocks were found in the buffer cache, preventing the need to read from the database. Shown as hit |
postgresql.rows_returned (gauge) | The number of rows returned by queries in this database Shown as row |
postgresql.rows_fetched (gauge) | The number of rows fetched by queries in this database Shown as row |
postgresql.rows_inserted (gauge) | The number of rows inserted by queries in this database Shown as row |
postgresql.rows_updated (gauge) | The number of rows updated by queries in this database Shown as row |
postgresql.rows_deleted (gauge) | The number of rows deleted by queries in this database Shown as row |
postgresql.database_size (gauge) | The disk space used by this database. Shown as byte |
postgresql.db.count (gauge) | The number of available databases. Shown as item |
postgresql.deadlocks (gauge) | The rate of deadlocks detected in this database Shown as lock |
postgresql.temp_bytes (gauge) | The amount of data written to temporary files by queries in this database. Shown as byte |
postgresql.temp_files (gauge) | The number of temporary files created by queries in this database. Shown as file |
postgresql.bgwriter.checkpoints_timed (count) | The number of scheduled checkpoints that were performed. |
postgresql.bgwriter.checkpoints_requested (count) | The number of requested checkpoints that were performed. |
postgresql.bgwriter.buffers_checkpoint (count) | The number of buffers written during checkpoints. |
postgresql.bgwriter.buffers_clean (count) | The number of buffers written by the background writer. |
postgresql.bgwriter.maxwritten_clean (count) | The number of times the background writer stopped a cleaning scan due to writing too many buffers. |
postgresql.bgwriter.buffers_backend (count) | The number of buffers written directly by a backend. Shown as buffer |
postgresql.bgwriter.buffers_alloc (count) | The number of buffers allocated |
postgresql.bgwriter.buffers_backend_fsync (count) | The of times a backend had to execute its own fsync call instead of the background writer. |
postgresql.bgwriter.write_time (count) | The total amount of checkpoint processing time spent writing files to disk. Shown as millisecond |
postgresql.bgwriter.sync_time (count) | The total amount of checkpoint processing time spent synchronizing files to disk. Shown as millisecond |
postgresql.locks (gauge) | The number of locks active for this database. Shown as lock |
postgresql.seq_scans (gauge) | The number of sequential scans initiated on this table. |
postgresql.seq_rows_read (gauge) | The number of live rows fetched by sequential scans. Shown as row |
postgresql.index_scans (gauge) | The number of index scans initiated on this table, tagged by index. |
postgresql.index_rel_scans (gauge) | The overall number of index scans initiated on this table. |
postgresql.index_rows_fetched (gauge) | The number of live rows fetched by index scans. Shown as row |
postgresql.index_rel_rows_fetched (gauge) | The number of live rows fetched by index scans. Shown as row |
postgresql.rows_hot_updated (gauge) | The number of rows HOT updated, meaning no separate index update was needed. Shown as row |
postgresql.live_rows (gauge) | The estimated number of live rows. Shown as row |
postgresql.dead_rows (gauge) | The estimated number of dead rows. Shown as row |
postgresql.vacuumed (count) | The number of times this table has been manually vacuumed. |
postgresql.autovacuumed (count) | The number of times this table has been vacuumed by the autovacuum daemon. |
postgresql.analyzed (count) | The number of times this table has been manually analyzed. |
postgresql.autoanalyzed (count) | The number of times this table has been analyzed by the autovacuum daemon. |
postgresql.index_rows_read (gauge) | The number of index entries returned by scans on this index. Shown as row |
postgresql.table_size (gauge) | The total disk space used by the specified table. Includes TOAST, free space map, and visibility map. Excludes indexes. Shown as byte |
postgresql.index_size (gauge) | The total disk space used by indexes attached to the specified table. Shown as byte |
postgresql.total_size (gauge) | The total disk space used by the table, including indexes and TOAST data. Shown as byte |
postgresql.table.count (gauge) | The number of user tables in this database. Shown as table |
postgresql.max_connections (gauge) | The maximum number of client connections allowed to this database. Shown as connection |
postgresql.percent_usage_connections (gauge) | The number of connections to this database as a fraction of the maximum number of allowed connections. Shown as fraction |
postgresql.replication_delay (gauge) | The current replication delay in seconds. Only available with postgresql 9.1 and newer Shown as second |
postgresql.replication_delay_bytes (gauge) | The current replication delay in bytes. Only available with postgresql 9.2 and newer Shown as byte |
postgresql.replication.wal_write_lag (gauge) | Time elapsed between flushing recent WAL locally and receiving notification that this standby server has written it (but not yet flushed it or applied it). This can be used to gauge the delay that synchronous_commit level remote_write incurred while committing if this server was configured as a synchronous standby. Only available with postgresql 10 and newer. Shown as second |
postgresql.replication.wal_flush_lag (gauge) | Time elapsed between flushing recent WAL locally and receiving notification that this standby server has written and flushed it (but not yet applied it). This can be used to gauge the delay that synchronous_commit level on incurred while committing if this server was configured as a synchronous standby. Only available with postgresql 10 and newer. Shown as second |
postgresql.replication.wal_replay_lag (gauge) | Time elapsed between flushing recent WAL locally and receiving notification that this standby server has written, flushed and applied it. This can be used to gauge the delay that synchronous_commit level remote_apply incurred while committing if this server was configured as a synchronous standby. Only available with postgresql 10 and newer. Shown as second |
postgresql.heap_blocks_read (gauge) | The number of disk blocks read from this table. Shown as block |
postgresql.heap_blocks_hit (gauge) | The number of buffer hits in this table. Shown as hit |
postgresql.index_blocks_read (gauge) | The number of disk blocks read from all indexes on this table. Shown as block |
postgresql.index_blocks_hit (gauge) | The number of buffer hits in all indexes on this table. Shown as hit |
postgresql.table_bloat (gauge) | The estimated percentage of table bloat. Shown as percent |
postgresql.index_bloat (gauge) | The estimated percentage of index bloat. Shown as percent |
postgresql.toast_blocks_read (gauge) | The number of disk blocks read from this table's TOAST table. Shown as block |
postgresql.toast_blocks_hit (gauge) | The number of buffer hits in this table's TOAST table. Shown as hit |
postgresql.toast_index_blocks_read (gauge) | The number of disk blocks read from this table's TOAST table index. Shown as block |
postgresql.toast_index_blocks_hit (gauge) | The number of buffer hits in this table's TOAST table index. Shown as block |
postgresql.transactions.open (gauge) | The number of open transactions in this database. Shown as transaction |
postgresql.transactions.idle_in_transaction (gauge) | The number of 'idle in transaction' transactions in this database. Shown as transaction |
postgresql.before_xid_wraparound (gauge) | The number of transactions that can occur until a transaction wraparound. Shown as transaction |
postgresql.active_queries (gauge) | The number of active queries in this database. |
postgresql.active_waiting_queries (gauge) | The number of waiting queries in this database in state active. |
postgresql.waiting_queries (gauge) | The number of waiting queries in this database. |
postgresql.queries.count (count) | The total query execution count per query_signature, db, and user. (DBM only) Shown as query |
postgresql.queries.time (count) | The total query execution time per query_signature, db, and user. (DBM only) Shown as nanosecond |
postgresql.queries.rows (count) | The total number of rows retrieved or affected per query_signature, db, and user. (DBM only) Shown as row |
postgresql.queries.shared_blks_hit (count) | Total number of shared block cache hits per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.shared_blks_read (count) | Total number of shared blocks read per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.shared_blks_dirtied (count) | Total number of shared blocks dirtied per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.shared_blks_written (count) | Total number of shared blocks written per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.local_blks_hit (count) | Total number of local block cache hits per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.local_blks_read (count) | Total number of local blocks read per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.local_blks_dirtied (count) | Total number of local blocks dirtied per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.local_blks_written (count) | Total number of local blocks written per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.temp_blks_read (count) | Total number of temp blocks read per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.temp_blks_written (count) | Total number of temp blocks written per query_signature, db, and user. (DBM only) Shown as block |
postgresql.queries.duration.max (gauge) | The age of the longest running query per user, db and app. (DBM only) Shown as nanosecond |
postgresql.queries.duration.sum (gauge) | The sum of the age of all running queries per user, db and app. (DBM only) Shown as nanosecond |
postgresql.transactions.duration.max (gauge) | The age of the longest running transaction per user, db and app. (DBM only) Shown as nanosecond |
postgresql.transactions.duration.sum (gauge) | The sum of the age of all running transactions per user, db and app. (DBM only) Shown as nanosecond |
postgresql.wal_age (gauge) | The age in seconds of the oldest WAL file. Shown as second |
postgresql.function.calls (rate) | The number of calls made to a function. |