get_database_bloat_overview
Analyze PostgreSQL database storage efficiency by identifying tables with high bloat ratios, calculating total bloat size per schema, and providing maintenance recommendations to optimize performance.
Instructions
[Tool Purpose]: Provide database-wide bloat overview and summary statistics
[Exact Functionality]:
Summarize bloat statistics across all schemas
Identify schemas and tables with highest bloat ratios
Calculate total estimated bloat size per schema
Show aggregate dead tuple counts and maintenance status
[Required Use Cases]:
When user requests "database bloat overview", "bloat summary", etc.
When getting high-level view of database storage efficiency
When planning database maintenance activities
When investigating overall database performance issues
[Strictly Prohibited Use Cases]:
Requests for automatic maintenance operations
Requests for bloat cleanup or removal
Requests for schema or database restructuring
Args: database_name: Target database name (uses default database from POSTGRES_DB env var if omitted) limit: Maximum number of schemas to show (1-50, default: 10)
Returns: Database-wide bloat summary by schema with totals and recommendations
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | ||
| limit | No |