Instance 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 hit

Amount of data found in shared buffers

Total read

Amount of data found in OS cache or read from disk

of requested checkpoints

Number of requested checkpoints that have been performed

of scheduled checkpoints

Number of scheduled checkpoints that have been performed

Buffers alloc

Number of buffers allocated

Sync time

Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds

Write time

Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds

Maxwritten clean

Number of times the background writer stopped a cleaning scan because it had written too many buffers

Buffers clean

Number of buffers written by the background writer

Buffers backend fsync

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)

Buffers backend

Number of buffers written directly by a backend

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

Database

Database name

#Calls

Total number of executed SQL statements

Runtime

Total runtime of the SQL statement

Avg runtime

Average runtime of the SQL statement

Blocks read

Number of pages read from the disk

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 written

Number of disk temporary write pages

I/O time

I/O wait time