get_vacuum_analyze_stats
Retrieve VACUUM and ANALYZE execution history, statistics, and table activity data to monitor PostgreSQL database maintenance status and performance.
Instructions
[Tool Purpose]: Analyze VACUUM and ANALYZE execution history and statistics per table
[Exact Functionality]:
Retrieve last VACUUM/ANALYZE execution time for each table
Provide Auto VACUUM/ANALYZE execution count statistics
Analyze table activity with tuple insert/update/delete statistics
[Required Use Cases]:
When user requests "VACUUM status", "ANALYZE history", "table statistics", etc.
When database maintenance status overview is needed
When performance issues or statistics update status verification is required
[Strictly Prohibited Use Cases]:
Requests for VACUUM or ANALYZE execution
Requests for Auto VACUUM configuration changes
Requests for forced statistics update
Args: database_name: Database name to analyze (uses default database if omitted)
Returns: Schema name, table name, last VACUUM time, last ANALYZE time, and execution count statistics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No |