pg_stat_io

字段

PostgreSQL 18 的 20 个字段，按定义顺序排列。说明默认用本站手册的译文，没有译文的按英文原文显示。

本版移除的字段

• op_bytes bigint 每个 I/O 读取、写入或扩展单位的字节数。 关系数据的读取、写入和扩展以block_size为单位进行，该值 来自构建时参数BLCKSZ，默认值为8192。

取值来自 PostgreSQL 17 的快照。

演化历史

相邻两个大版本之间的差异，新的在前。版本号链到该版的字段表。

1. PostgreSQL 19 ← 18 仅描述更新

   1 处描述更新

   • read_time Time spent waiting for read operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero) Time spent waiting for read operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero). This may include time spent waiting for a read started by another backend. In that case reads may still be zero.

2. PostgreSQL 18 ← 17 结构变更

   +read_bytes+write_bytes+extend_bytes −op_bytes 关系说明更新

   9 处描述更新

   • extend_time Time spent in extend operations in milliseconds (if track_io_timing is enabled, otherwise zero) Time spent waiting for extend operations in milliseconds. (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
   • extends Number of relation extend operations, each of the size specified in op_bytes. Number of relation extend operations.
   • fsync_time Time spent in fsync operations in milliseconds (if track_io_timing is enabled, otherwise zero) Time spent waiting for fsync operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
   • read_time Time spent in read operations in milliseconds (if track_io_timing is enabled, otherwise zero) Time spent waiting for read operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
   • reads Number of read operations, each of the size specified in op_bytes. Number of read operations.
   • write_time Time spent in write operations in milliseconds (if track_io_timing is enabled, otherwise zero) Time spent waiting for write operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
   • writeback_time Time spent in writeback operations in milliseconds (if track_io_timing is enabled, otherwise zero). This includes the time spent queueing write-out requests and, potentially, the time spent to write out the dirty data. Time spent waiting for writeback operations in milliseconds (if track_io_timing is enabled, otherwise zero). This includes the time spent queueing write-out requests and, potentially, the time spent to write out the dirty data.
   • writebacks Number of units of size op_bytes which the process requested the kernel write out to permanent storage. Number of units of size BLCKSZ (typically 8kB) which the process requested the kernel write out to permanent storage.
   • writes Number of write operations, each of the size specified in op_bytes. Number of write operations.

3. PostgreSQL 16 ← 15 新增此关系

   共 18 个字段

字段矩阵

每个字段在 5 个收录版本里的存在情况；方格指向该版的字段表。「有变」指类型、可空、隐式或数组维数与上一版不同。

存在 有变 已移除 不存在

同类关系