{"Entry":{"collection":"catalog","key":"pg_aios","name":"pg_aios","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"17","order":false,"removed":[],"status":"added","to":"18","types":[]}],"column_count":15,"content_hash":"5631604c4ccf65938469b87a77636ef483a6d58099bfa60a212a26e290d034ee","first_version":"18","imported_at":"2026-09-30T00:40:55.296831+08:00","kind":"view","last_version":"20","name":"pg_aios","position":1,"present_in":["18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:8aee55a862794c52c55af2fece19bd0baeff9a6e8ada218541682699221a12a2","summary":"The pg_aios view lists all Asynchronous I/O handles that are currently in-use.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_aios","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_aios","SourceRevision":"english-manuals:8aee55a862794c52c55af2fece19bd0baeff9a6e8ada218541682699221a12a2","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of the server process that is issuing this I/O.","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":2,"description":"Identifier of the I/O handle. Handles are reused once the I/O completed (or if the handle is released before I/O is started). On reuse pg_aios.io_generation is incremented.","description_zh":"","documented":true,"documented_name":"io_id","hidden":false,"name":"io_id","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":3,"description":"Generation of the I/O handle.","description_zh":"","documented":true,"documented_name":"io_generation","hidden":false,"name":"io_generation","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"State of the I/O handle:\n\nHANDED_OUT, referenced by code but not yet used DEFINED, information necessary for execution is known STAGED, ready for execution SUBMITTED, submitted for execution COMPLETED_IO, finished, but result has not yet been processed COMPLETED_SHARED, shared completion processing completed COMPLETED_LOCAL, backend local completion processing completed","description_zh":"","documented":true,"documented_name":"state","hidden":false,"name":"state","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":5,"description":"Operation performed using the I/O handle:\n\ninvalid, not yet known readv, a vectored read writev, a vectored write","description_zh":"","documented":true,"documented_name":"operation","hidden":false,"name":"operation","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":6,"description":"Offset of the I/O operation.","description_zh":"","documented":true,"documented_name":"off","hidden":false,"name":"off","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Length of the I/O operation.","description_zh":"","documented":true,"documented_name":"length","hidden":false,"name":"length","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"What kind of object is the I/O targeting:\n\nsmgr, I/O on relations","description_zh":"","documented":true,"documented_name":"target","hidden":false,"name":"target","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":9,"description":"Length of the data associated with the I/O operation. For I/O to/from shared_buffers and temp_buffers, this indicates the number of buffers the I/O is operating on.","description_zh":"","documented":true,"documented_name":"handle_data_len","hidden":false,"name":"handle_data_len","not_null":false,"references":"","type":"int2","type_modifier":-1,"type_oid":21},{"array_dimensions":0,"attnum":10,"description":"Low-level result of the I/O operation, or NULL if the operation has not yet completed.","description_zh":"","documented":true,"documented_name":"raw_result","hidden":false,"name":"raw_result","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":11,"description":"High-level result of the I/O operation:\n\nUNKNOWN means that the result of the operation is not yet known. OK means the I/O completed successfully. PARTIAL means that the I/O completed without error, but did not process all data. Commonly callers will need to retry and perform the remainder of the work in a separate I/O. WARNING means that the I/O completed without error, but that execution of the IO triggered a warning. E.g. when encountering a corrupted buffer with zero_damaged_pages enabled. ERROR means the I/O failed with an error.","description_zh":"","documented":true,"documented_name":"result","hidden":false,"name":"result","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":12,"description":"Description of what the I/O operation is targeting.","description_zh":"","documented":true,"documented_name":"target_desc","hidden":false,"name":"target_desc","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":13,"description":"Flag indicating whether the I/O is executed synchronously.","description_zh":"","documented":true,"documented_name":"f_sync","hidden":false,"name":"f_sync","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":14,"description":"Flag indicating whether the I/O references process local memory.","description_zh":"","documented":true,"documented_name":"f_localmem","hidden":false,"name":"f_localmem","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":15,"description":"Flag indicating whether the I/O is buffered I/O.","description_zh":"","documented":true,"documented_name":"f_buffered","hidden":false,"name":"f_buffered","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16}],"description":"The pg_aios view lists all Asynchronous I/O handles that are currently in-use. An I/O handle is used to reference an I/O operation that is being prepared, executed or is in the process of completing. pg_aios contains one row for each I/O handle.\n\nThis view is mainly useful for developers of PostgreSQL, but may also be useful when tuning PostgreSQL.","description_zh":"","doc":{"anchor":"id-1.10.5.6.5","file":"view-pg-aios.html","lang":"en","sha256":"06663b8b5fc3da9ab02154d058d90c5f8b15cb17cb88169106844ae77dc8560a","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","io_id","io_generation","state","operation","off","length","target","handle_data_len","raw_result","result","target_desc","f_sync","f_localmem","f_buffered"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.6.5","file":"view-pg-aios.html","lang":"en","sha256":"06663b8b5fc3da9ab02154d058d90c5f8b15cb17cb88169106844ae77dc8560a","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","io_id","io_generation","state","operation","off","length","target","handle_data_len","raw_result","result","target_desc","f_sync","f_localmem","f_buffered"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_aios","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_aios","Summary":"pg_aios 视图列出当前正在使用的全部异步 I/O句柄。I/O 句柄用于引用正在准备、执行或处于完成过程中的 I/O 操作。pg_aios 为每个 I/O 句柄提供一行。\n\n该视图主要对 PostgreSQL 开发者有用，但在调优 PostgreSQL 时也可能有帮助。","BodyHTML":"\u003cp\u003epg_aios 视图列出当前正在使用的全部异步 I/O句柄。I/O 句柄用于引用正在准备、执行或处于完成过程中的 I/O 操作。pg_aios 为每个 I/O 句柄提供一行。\n\n该视图主要对 PostgreSQL 开发者有用，但在调优 PostgreSQL 时也可能有帮助。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"0c594d628714fdec2a885c8550633f278140d764cbf4e2d4d983bb7cd73d8b0b","Payload":{"columns":[{"description_zh":"发起该 I/O 的服务器进程 ID。","name":"pid","type":"integer","zh_from":"doc"},{"description_zh":"I/O 句柄的标识符。I/O 完成后（或者在 I/O 启动前释放句柄时），句柄会被复用。每次复用时，pg_aios.io_generation 都会递增。","name":"io_id","type":"integer","zh_from":"doc"},{"description_zh":"I/O 句柄的代次。","name":"io_generation","type":"bigint","zh_from":"doc"},{"description_zh":"I/O 句柄的状态：","name":"state","type":"text","zh_from":"doc"},{"description_zh":"使用 I/O 句柄执行的操作：","name":"operation","type":"text","zh_from":"doc"},{"description_zh":"I/O 操作的偏移量。","name":"off","type":"bigint","zh_from":"doc"},{"description_zh":"I/O 操作的长度。","name":"length","type":"bigint","zh_from":"doc"},{"description_zh":"I/O 的目标对象类型：","name":"target","type":"text","zh_from":"doc"},{"description_zh":"与 I/O 操作关联的数据长度。对于指向或来自shared_buffers和temp_buffers的 I/O，该值表示 I/O 正在操作的缓冲区个数。","name":"handle_data_len","type":"smallint","zh_from":"doc"},{"description_zh":"I/O 操作的底层结果；如果操作尚未完成，则为 NULL。","name":"raw_result","type":"integer","zh_from":"doc"},{"description_zh":"I/O 操作的高层结果：","name":"result","type":"text","zh_from":"doc"},{"description_zh":"I/O 操作目标的描述。","name":"target_desc","type":"text","zh_from":"doc"},{"description_zh":"标记该 I/O 是否同步执行。","name":"f_sync","type":"boolean","zh_from":"doc"},{"description_zh":"标记该 I/O 是否引用进程本地内存。","name":"f_localmem","type":"boolean","zh_from":"doc"},{"description_zh":"标记该 I/O 是否为缓冲 I/O。","name":"f_buffered","type":"boolean","zh_from":"doc"}],"description_zh":"pg_aios 视图列出当前正在使用的全部异步 I/O句柄。I/O 句柄用于引用正在准备、执行或处于完成过程中的 I/O 操作。pg_aios 为每个 I/O 句柄提供一行。\n\n该视图主要对 PostgreSQL 开发者有用，但在调优 PostgreSQL 时也可能有帮助。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}