pg_aios 是一个 系统目录 视图，列出了所有当前正在使用的异步 I/O 句柄。
pg_aios 在 PostgreSQL 18 中添加。
用法
默认情况下，pg_aios 只能由超级用户或具有 pg_read_all_stats 角色的权限的角色读取。
按 PostgreSQL 版本定义
pg_aios (PostgreSQL 19)
View "pg_catalog.pg_aios"
Column | Type | Collation | Nullable | Default
-----------------+----------+-----------+----------+---------
pid | integer | | |
io_id | integer | | |
io_generation | bigint | | |
state | text | | |
operation | text | | |
off | bigint | | |
length | bigint | | |
target | text | | |
handle_data_len | smallint | | |
raw_result | integer | | |
result | text | | |
target_desc | text | | |
f_sync | boolean | | |
f_localmem | boolean | | |
f_buffered | boolean | | |
文档： pg_aios
pg_aios (PostgreSQL 18)
View "pg_catalog.pg_aios"
Column | Type | Collation | Nullable | Default
-----------------+----------+-----------+----------+---------
pid | integer | | |
io_id | integer | | |
io_generation | bigint | | |
state | text | | |
operation | text | | |
off | bigint | | |
length | bigint | | |
target | text | | |
handle_data_len | smallint | | |
raw_result | integer | | |
result | text | | |
target_desc | text | | |
f_sync | boolean | | |
f_localmem | boolean | | |
f_buffered | boolean | | |
文档： pg_aios
变更历史
- PostgreSQL 18
- 添加 (提交 60f566b4)
参考资料
- PostgreSQL 文档: pg_aios