Database Performance Metrics

Queries per sec

Number of queries executed per second

Runtime per sec

Total duration of queries executed per second

Avg runtime

Average query duration

Total shared buffers hit

Amount of data found in shared buffers

Total shared buffers miss

Amount of data found in OS cache or read from disk

Index scans ratio

Ratio of index scans to sequential scans

Index scans

Number of index scans per second

Sequential scans

Number of sequential scans per second

Tuples inserted

Number of tuples inserted per second

Tuples updated

Number of tuples updated per second

Tuples HOT updated

Number of heap-only tuples (HOT) updated per second

Tuples deleted

Number of tuples deleted per second

# Vacuum

Number of vacuums per second

# Autovacuum

Number of autovacuums per second

# Analyze

Number of analyses per second

# Autoanalyze

Number of autoanalyses per second

Query

SQL statement to be executed

(Execution) #

Number of times that the SQL statement is executed

(Execution) Time

Total execution time of the SQL statement

(Execution) Avg time

Average time for executing the SQL statement

(I/O Time) Read

Read I/O wait time

(I/O Time) Write

Write I/O wait time

(Blocks) Read

Number of disk read pages

(Blocks) Hit

Number of hit pages in the shared buffer

(Blocks) Dirtied

Number of dirty pages

(Blocks) Written

Number of disk write pages

(Temp blocks) Read

Number of disk temporary read pages

(Temp blocks) Write

Number of disk temporary write pages