SYSTEM CATALOGS / SYSTEM VIEWS
pg_aios
Read PG 18 manual ↗The pg_aios view lists all Asynchronous I/O handles that are currently in-use.
- Kind
- System views
- Columns in this snapshot
- 15
- Definition source
- English manual
Columns 15
| Column | Type | Description / reference |
|---|---|---|
pid | int4 | Process ID of the server process that is issuing this I/O. |
io_id | int4 | 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. |
io_generation | int8 | Generation of the I/O handle. |
state | text | State of the I/O handle: |
operation | text | Operation performed using the I/O handle: |
off | int8 | Offset of the I/O operation. |
length | int8 | Length of the I/O operation. |
target | text | What kind of object is the I/O targeting: |
handle_data_len | int2 | 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. |
raw_result | int4 | Low-level result of the I/O operation, or NULL if the operation has not yet completed. |
result | text | High-level result of the I/O operation: |
target_desc | text | Description of what the I/O operation is targeting. |
f_sync | bool | Flag indicating whether the I/O is executed synchronously. |
f_localmem | bool | Flag indicating whether the I/O references process local memory. |
f_buffered | bool | Flag indicating whether the I/O is buffered I/O. |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
io_id | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
io_generation | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
state | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
operation | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
off | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
length | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
target | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
handle_data_len | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
raw_result | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
result | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
target_desc | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
f_sync | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
f_localmem | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
f_buffered | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
Version history 1
- PG 17 → 18added
Definition snapshot: english-manuals:208eb53559cc84458ac2e6cd4e1… · English manual source