get_async_io_status
Monitor PostgreSQL async I/O subsystem status: view active operations, I/O method, concurrency, and file handle usage. Falls back to configuration info on versions before 18.
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
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "get_async_io_status"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | Database name (uses default if omitted) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |