get_running_vacuum_operations
Monitor active VACUUM, ANALYZE, and REINDEX operations in PostgreSQL databases to track progress, identify blocking processes, and troubleshoot maintenance performance issues.
Instructions
[Tool Purpose]: Monitor currently running VACUUM and ANALYZE operations in real-time
[Exact Functionality]:
Show all currently active VACUUM, ANALYZE, and REINDEX operations
Display operation progress, elapsed time, and process details
Identify blocking or long-running maintenance operations
Provide process IDs for operation tracking
[Required Use Cases]:
When user requests "running VACUUM", "active maintenance", "current VACUUM status", etc.
When troubleshooting slow or stuck VACUUM operations
When monitoring maintenance operation progress
When identifying maintenance operations that may be affecting performance
[Strictly Prohibited Use Cases]:
Requests for terminating or controlling VACUUM processes
Requests for starting new VACUUM operations
Requests for changing VACUUM parameters or configuration
Args: database_name: Target database name (shows operations in all databases if omitted)
Returns: Real-time status of running VACUUM/ANALYZE operations with timing and progress information
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No |