get_async_io_status
Monitor asynchronous I/O subsystem status and configuration in PostgreSQL 18+ to investigate I/O performance and concurrency.
Instructions
[Tool Purpose]: Monitor asynchronous I/O subsystem status (PostgreSQL 18+)
[Exact Functionality]:
Show active async I/O operations from pg_aios view
Display I/O method configuration and concurrency settings
Report async I/O file handle usage
Falls back to I/O configuration info on PG < 18
[Required Use Cases]:
When user requests "async I/O status", "AIO monitoring", "I/O subsystem"
When investigating I/O performance and concurrency
When checking async I/O configuration
[Strictly Prohibited Use Cases]:
Requests for I/O configuration changes
Requests for storage modifications
Args: database_name: Database name (uses default if omitted)
Returns: Async I/O subsystem status and configuration, or version notice on older PG
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |