Help Center/ Relational Database Service/ Best Practices/ RDS for PostgreSQL/ Using PoWA/ Performance Metrics/ Instance Performance Metrics
Updated on 2024-09-06 GMT+08:00
View PDF
Share

Instance Performance Metrics

General Overview

Figure 1 General Overview metrics
Table 1 Query runtime per second (all databases) field description

Field

Description

Queries per sec

Number of queries executed per second

Runtime per sec

Total duration of queries executed per second

Avg runtime

Average query duration
Table 2 Block access in Bps field description

Field

Description

Total hit

Amount of data found in shared buffers

Total read

Amount of data found in OS cache or read from disk

Background Writer

Figure 2 Background Writer metrics
Table 3 Checkpointer scheduling field description

Field

Description

of requested checkpoints

Number of requested checkpoints that have been performed

of scheduled checkpoints

Number of scheduled checkpoints that have been performed
Table 4 Checkpointer activity field description

Field

Description

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
Table 5 Background writer field description

Field

Description

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
Table 6 Backends field description

Field

Description

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

Database Objects

Figure 3 Database Objects metrics
Table 7 Access pattern field description

Field

Description

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
Table 8 DML activity field description

Field

Description

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
Table 9 Vacuum activity field description

Field

Description

# Vacuum

Number of vacuums per second

# Autovacuum

Number of autovacuums per second

# Analyze

Number of analyses per second

# Autoanalyze

Number of autoanalyses per second

Details for all databases

Figure 4 Details for all databases metrics
Table 10

Field

Description

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
Parent Topic: Performance Metrics