PostgreSQL

This dashboard provides an interface to view and analyze metrics from your PostgreSQL databases.

Metric visualization	Metric name	Description
Rows Fetched Vs Returned	postgresql_tup_fetched, postgresql_tup_returned	Number of rows fetched and returned by queries in this database.
Cache Hit Rate	postgresql_blks_hit, postgresql_blks_read	Number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system’s file system cache) divided by the number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system’s file system cache) including the number of disk blocks read in this database.
Active Connections	postgresql_numbackends	Number of backends currently connected to this database.
Queries Per Second	postgresql_xact_commit, postgresql_xact_rollback	Number of transactions in this database that have been committed and the number of transactions in this database that have been rolled back.
Conflicts Count	postgresql_conflicts	Number of queries canceled due to conflicts with recovery in this database.
Deadlocks Count	postgresql_deadlocks	Number of deadlocks detected in this database.
Row Insert/Update/Delete Rate	postgresql_tup_inserted, postgresql_tup_updated, postgresql_tup_deleted	Number of rows inserted, updated and deleted by queries in this database.
Row Fetch/Return Rate	postgresql_tup_fetched, postgresql_tup_returned	Number of rows fetched and returned by queries in this database.
Buffers	postgresql_tup_returned, postgresql_buffers_backend, postgresql_buffers_backend_fsync, postgresql_buffers_checkpoint, postgresql_buffers_clean	Number of buffers allocated, number of buffers written directly by a backend, number of times a backend had to execute its own fsync call (normally the background writer handles those even when the backend does its own write), number of buffers written during checkpoints, number of buffers written by the background writer.
Conflicts Vs Deadlocks	postgresql_deadlocks, postgresql_conflicts	Number of queries canceled due to conflicts with recovery in this database, number of deadlocks detected in this database.
Cache Hit Rate	postgresql_blks_hit, postgresql_blks_hit	Number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system’s file system cache) divided by the sum of number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system’s file system cache) and the number of disk blocks read in this database.
Active Connections	postgresql_numbackends	Number of backends currently connected to this database.
Checkpoints	postgresql_checkpoints_timed, postgresql_checkpoints_req	Number of scheduled checkpoints that have been performed and the number of requested checkpoints that have been performed.
Temporary Bytes	postgresql_temp_bytes	Total amount of data written to temporary files by queries in this database.