Get AIO status
get_aio_statusDetermines if PostgreSQL 19's async-I/O subsystem is usable, returning available status or guidance for older versions.
Instructions
Report whether PG 19's async-I/O subsystem is usable. On PG < 19 returns available=false with a diagnostic pointing the agent at the existing read_pg_stat_io / run_maintenance tools. Never raises — driver-level errors during the version or settings probe also surface as available=false. Returns an object with available (bool), server_version_num (int), server_version, io_method ('sync' / 'worker' / 'io_uring' / null), io_min_workers, io_max_workers, and detail (a guidance string).
Example: get_aio_status()
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| detail | Yes | ||
| available | Yes | ||
| io_method | Yes | ||
| io_max_workers | Yes | ||
| io_min_workers | Yes | ||
| server_version | Yes | ||
| server_version_num | Yes |