更新时间:2022-04-29 GMT+08:00
分享

实例级性能指标

General Overview

图1 General Overview性能指标
表1 Query runtime per second (all databases)字段解释

字段

中文解释

英文解释

Queries per sec

每秒执行查询的次数。

Number of time the query has been executed, per second

Runtime per sec

每秒执行的查询的总持续时间。

Total duration of queries executed, per second

Avg runtime

平均查询时长。

Average query duration

表2 Block access in Bps字段解释

字段

中文解释

英文解释

Total hit

在共享缓冲区中找到的数据量。

Amount of data found in shared buffers

Total read

在操作系统缓存中找到或从磁盘读取的数据量。

Amount of data found in OS cache or read from disk

Background Writer

图2 Background Writer性能指标
表3 Checkpointer scheduling字段解释

字段

中文解释

英文解释

of requested checkpoints

已执行的请求检查点数。

Number of requested checkpoints that have been performed

of scheduled checkpoints

已执行的预定检查点数。

Number of scheduled checkpoints that have been performed

表4 Checkpointer activity字段解释

字段

中文解释

英文解释

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

表5 Background writer字段解释

字段

中文解释

英文解释

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

表6 Backends字段解释

字段

中文解释

英文解释

Buffers backend fsync

后端必须执行自己的 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

图3 Database Objects性能指标
表7 Access pattern字段解释

字段

中文解释

英文解释

Index scans ratio

索引扫描/序列扫描的比率。

Ratio of index scan / seq scan

Index scans

每秒索引扫描次数。

Number of index scan per second

Sequential scans

每秒顺序扫描次数。

Number of sequential scan per second

表8 DML activity字段解释

字段

中文解释

英文解释

Tuples inserted

每秒插入的行数。

Number of tuples inserted per second

Tuples updated

每秒更新的行数。

Number of tuples updated per second

Tuples HOT updated

每秒更新(HOT)。

Number of tuples HOT updated per second

Tuples deleted

每秒删除的行数。

Number of tuples deleted per second

表9 Vacuum activity字段解释

字段

中文解释

英文解释

# Vacuum

每秒手动清理的次数。

Number of vacuum per second

# Autovacuum

每秒自动清理的次数。

Number of autovacuum per second

# Analyze

每秒手动分析的次数。

Number of analyze per second

# Autoanalyze

每秒自动分析的次数。

Number of autoanalyze per second

Details for all databases

图4 Details for all databases性能指标
表10

字段

注释

Database

数据库名称。

#Calls

执行SQL总数。

Runtime

执行SQL总耗时。

Avg runtime

执行SQL平均耗时。

Blocks read

磁盘读取的页面数。

Blocks hit

共享缓冲区命中的页面数。

Blocks dirtied

脏页数。

Blocks written

磁盘写页面数。

Temp Blocks written

磁盘写临时页面数。

I/O time

I/O等待时间。

分享:

    相关文档

    相关产品

close