Operation progress
pg_progressShow live progress for PostgreSQL long-running operations from pg_stat_progress views—VACUUM, ANALYZE, index builds, backups, COPY, and REPACK—so you can tell if a job is stuck or just slow.
Instructions
Show long operations that are running now with their progress: VACUUM, ANALYZE, CLUSTER/VACUUM FULL, CREATE INDEX / REINDEX, base backups, COPY and REPACK, from the pg_stat_progress_* views that exist on this server version.
Each operation lists the process, user, table, phase, how long it has run, percent done when it can be computed and the raw counters. When nothing is running it says so. Use it to answer "is it stuck or just slow?" for index builds and vacuums.
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": "pg_progress"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | No |