PostgreSQL instance and host machine metrics

Instance Metrics

The time range of these sparkline graphs matches the selection window on the main graph

Transactions committed / sec

Shows the number of successful (committed) transactions per second.

Transactions rolled back / sec

Shows the number of aborted (rolled back) transactions per second.

Query overflow to temp data bytes / sec

Shows the volume of data being written to temporary storage to support query execution.

Number of connections

The total number of user connections to a Postgres Instance at a given time.

Block write time

The time in ms/s which queries have spent waiting on I/O to write blocks of data.

Block read time

The time in ms/s which queries have spent waiting on I/O to read blocks of data. 

Deadlocks / sec

The number of occurrences of two or more transactions being unable to proceed because they are each waiting on a resource on which the other has already acquired a lock.

Cache hit ratio

The ratio of data reads which were served from PostgreSQL's memory cache (a hit) vs having to request data from the host Operating System.

Transactions committed / rollback

Shows the ratio of the number of successful (committed) transactions to the number of aborted (rolled back) transactions at a given point in time



Host machine metrics

Network utilization

The percentage of total bandwidth usage

Avg CPU queue length

The number of threads in the processor queue waiting to be executed

Memory pages / sec

The rate at which pages are read from or written to disk to resolve page faults.


Disk Usage

For each logical disk on the host

Space used

Amount of space used (dark) and remaining (light), with amount free and total size in text.

Avg. read time

The average time in milliseconds of a read operation from the logical disk.

Avg. write time

The average time in milliseconds of a write operation to the logical disk.

Transfers / sec

How many read and write requests are being completed per second on the logical disk.




Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?