{"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":"5a4eea8bf2f7d3b35edfdcddde20bd6b9c90c1d8604ed972e837b1ca2997d49d","derived_content_hash":"d45451b2f1ad66c82312e47e195dbb6401963f8b0f5061e8501fa573cb7708de","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":"catalog-bilingual-repair:6fbfac51d8d415eca4b4e18f218c6f5cdea3b9b018504444803c44e6a4aab166","summary":"The pg_aios view lists all Asynchronous I/O handles that are currently in-use.","summary_zh":"pg_aios 视图列出当前正在使用的全部异步 I/O 句柄。I/O 句柄用于引用正在准备、执行或处于完成过程中的 I/O 操作。pg_aios 为每个 I/O 句柄提供一行。"}},"Definition":{"Collection":"catalog","Key":"pg_aios","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_aios","SourceRevision":"catalog-bilingual-repair:6fbfac51d8d415eca4b4e18f218c6f5cdea3b9b018504444803c44e6a4aab166","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of the server process that is issuing this I/O.","description_zh":"发起该 I/O 的服务器进程 ID。","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"I/O 句柄的标识符。I/O 完成后（或者在 I/O 启动前释放句柄时），句柄会被复用。每次复用时，pg_aios.io_generation 都会递增。","documented":true,"documented_name":"io_id","hidden":false,"name":"io_id","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Generation of the I/O handle.","description_zh":"I/O 句柄的代次。","documented":true,"documented_name":"io_generation","hidden":false,"name":"io_generation","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"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":"I/O 句柄的状态：\n\nHANDED_OUT，已被代码引用但尚未使用 DEFINED，执行所需的信息已知 STAGED，已就绪，可执行 SUBMITTED，已提交执行 COMPLETED_IO，已完成，但结果尚未处理 COMPLETED_SHARED，共享完成处理已完成 COMPLETED_LOCAL，后端本地完成处理已完成\n\n","documented":true,"documented_name":"state","hidden":false,"name":"state","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"使用 I/O 句柄执行的操作：\n\ninvalid，尚未知晓 readv，向量化读取 writev，向量化写入\n\n","documented":true,"documented_name":"operation","hidden":false,"name":"operation","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Offset of the I/O operation.","description_zh":"I/O 操作的偏移量。","documented":true,"documented_name":"off","hidden":false,"name":"off","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Length of the I/O operation.","description_zh":"I/O 操作的长度。","documented":true,"documented_name":"length","hidden":false,"name":"length","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"What kind of object is the I/O targeting:\n\nsmgr, I/O on relations","description_zh":"I/O 的目标对象类型：\n\nsmgr，关系上的 I/O\n\n","documented":true,"documented_name":"target","hidden":false,"name":"target","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"与 I/O 操作关联的数据长度。对于指向或来自 shared_buffers 和 temp_buffers 的 I/O，该值表示 I/O 正在操作的缓冲区个数。","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,"zh_from":"same-version-manual"},{"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":"I/O 操作的底层结果；如果操作尚未完成，则为 NULL。","documented":true,"documented_name":"raw_result","hidden":false,"name":"raw_result","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"I/O 操作的高层结果：\n\nUNKNOWN 表示操作结果尚未知晓。 OK 表示 I/O 已成功完成。 PARTIAL 表示 I/O 完成时没有出错，但未处理全部数据。通常调用方需要在单独的 I/O 中重试并完成剩余工作。 WARNING 表示 I/O 完成时没有出错，但执行 I/O 时触发了警告。例如，在启用 zero_damaged_pages 时遇到损坏的缓冲区。 ERROR 表示 I/O 因错误而失败。\n\n","documented":true,"documented_name":"result","hidden":false,"name":"result","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Description of what the I/O operation is targeting.","description_zh":"I/O 操作目标的描述。","documented":true,"documented_name":"target_desc","hidden":false,"name":"target_desc","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Flag indicating whether the I/O is executed synchronously.","description_zh":"标记该 I/O 是否同步执行。","documented":true,"documented_name":"f_sync","hidden":false,"name":"f_sync","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Flag indicating whether the I/O references process local memory.","description_zh":"标记该 I/O 是否引用进程本地内存。","documented":true,"documented_name":"f_localmem","hidden":false,"name":"f_localmem","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Flag indicating whether the I/O is buffered I/O.","description_zh":"标记该 I/O 是否为缓冲 I/O。","documented":true,"documented_name":"f_buffered","hidden":false,"name":"f_buffered","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"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":"pg_aios 视图列出当前正在使用的全部异步 I/O 句柄。I/O 句柄用于引用正在准备、执行或处于完成过程中的 I/O 操作。pg_aios 为每个 I/O 句柄提供一行。\n\n该视图主要对 PostgreSQL 开发者有用，但在调优 PostgreSQL 时也可能有帮助。","description_zh_html":"\u003cp\u003epg_aios 视图列出当前正在使用的全部异步 I/O 句柄。I/O 句柄用于引用正在准备、执行或处于完成过程中的 I/O 操作。pg_aios 为每个 I/O 句柄提供一行。\u003c/p\u003e\n\u003cp\u003e该视图主要对 PostgreSQL 开发者有用，但在调优 PostgreSQL 时也可能有帮助。\u003c/p\u003e","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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-aios.html","sha256":"2e0ea7b1c4bc0a564a3984e3bc76c6d42ed349d2fa8fa0db79a941c748a2be2c","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:8aee55a862794c52c55af2fece19bd0baeff9a6e8ada218541682699221a12a2","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.6.5","file":"view-pg-aios.html","lang":"en","sha256":"06663b8b5fc3da9ab02154d058d90c5f8b15cb17cb88169106844ae77dc8560a","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-aios.html","sha256":"2e0ea7b1c4bc0a564a3984e3bc76c6d42ed349d2fa8fa0db79a941c748a2be2c","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:8aee55a862794c52c55af2fece19bd0baeff9a6e8ada218541682699221a12a2","version":"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":"center","Version":"18","Locale":"en","Title":"pg_aios","Summary":"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.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:6fbfac51d8d415eca4b4e18f218c6f5cdea3b9b018504444803c44e6a4aab166","ContentHash":"61873bb75a11a9b3546b47073df4009067de192e55068ebcd3783439a660889d","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of the server process that is issuing this I/O.","description_zh":"发起该 I/O 的服务器进程 ID。","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"I/O 句柄的标识符。I/O 完成后（或者在 I/O 启动前释放句柄时），句柄会被复用。每次复用时，pg_aios.io_generation 都会递增。","documented":true,"documented_name":"io_id","hidden":false,"name":"io_id","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Generation of the I/O handle.","description_zh":"I/O 句柄的代次。","documented":true,"documented_name":"io_generation","hidden":false,"name":"io_generation","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"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":"I/O 句柄的状态：\n\nHANDED_OUT，已被代码引用但尚未使用 DEFINED，执行所需的信息已知 STAGED，已就绪，可执行 SUBMITTED，已提交执行 COMPLETED_IO，已完成，但结果尚未处理 COMPLETED_SHARED，共享完成处理已完成 COMPLETED_LOCAL，后端本地完成处理已完成\n\n","documented":true,"documented_name":"state","hidden":false,"name":"state","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"使用 I/O 句柄执行的操作：\n\ninvalid，尚未知晓 readv，向量化读取 writev，向量化写入\n\n","documented":true,"documented_name":"operation","hidden":false,"name":"operation","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Offset of the I/O operation.","description_zh":"I/O 操作的偏移量。","documented":true,"documented_name":"off","hidden":false,"name":"off","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Length of the I/O operation.","description_zh":"I/O 操作的长度。","documented":true,"documented_name":"length","hidden":false,"name":"length","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"What kind of object is the I/O targeting:\n\nsmgr, I/O on relations","description_zh":"I/O 的目标对象类型：\n\nsmgr，关系上的 I/O\n\n","documented":true,"documented_name":"target","hidden":false,"name":"target","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"与 I/O 操作关联的数据长度。对于指向或来自 shared_buffers 和 temp_buffers 的 I/O，该值表示 I/O 正在操作的缓冲区个数。","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,"zh_from":"same-version-manual"},{"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":"I/O 操作的底层结果；如果操作尚未完成，则为 NULL。","documented":true,"documented_name":"raw_result","hidden":false,"name":"raw_result","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"I/O 操作的高层结果：\n\nUNKNOWN 表示操作结果尚未知晓。 OK 表示 I/O 已成功完成。 PARTIAL 表示 I/O 完成时没有出错，但未处理全部数据。通常调用方需要在单独的 I/O 中重试并完成剩余工作。 WARNING 表示 I/O 完成时没有出错，但执行 I/O 时触发了警告。例如，在启用 zero_damaged_pages 时遇到损坏的缓冲区。 ERROR 表示 I/O 因错误而失败。\n\n","documented":true,"documented_name":"result","hidden":false,"name":"result","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Description of what the I/O operation is targeting.","description_zh":"I/O 操作目标的描述。","documented":true,"documented_name":"target_desc","hidden":false,"name":"target_desc","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Flag indicating whether the I/O is executed synchronously.","description_zh":"标记该 I/O 是否同步执行。","documented":true,"documented_name":"f_sync","hidden":false,"name":"f_sync","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Flag indicating whether the I/O references process local memory.","description_zh":"标记该 I/O 是否引用进程本地内存。","documented":true,"documented_name":"f_localmem","hidden":false,"name":"f_localmem","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Flag indicating whether the I/O is buffered I/O.","description_zh":"标记该 I/O 是否为缓冲 I/O。","documented":true,"documented_name":"f_buffered","hidden":false,"name":"f_buffered","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"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."}},"RequestedLocale":"en","Fallback":false,"Versions":["18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}