Postgres performance monitoring metrics:
Take informed troubleshooting decisions by keeping track of critical Postgres metrics including:
Idle user count
The total number of users/back ends connected to the database that are currently idle.
Active user count
The total number of users/back ends connected to the database that are currently in active state. Along with the idle user count metric, this metric will allow us to get the whole picture about the different server users.
Database conflict count
The total number of queries canceled due to conflicts with data recovery ocurring across all databases in the Postgres server.
Database cache usage ratio
The usage rate of cache is calculated using the formula SUM (blks_hit) / SUM (blks_read).
Total number of transactions that have been rolled back across all databases.
Total number of transactions that have been committed across all databases.
Total number of buffers written directly by a back end.
Total number of buffers written during checkpoints.
Total number of scheduled checkpoints that have been performed.