get_database_bloat_overview
Summarize PostgreSQL bloat across all schemas, identify tables with the highest bloat ratios and aggregate dead tuples, and review storage efficiency to plan database maintenance.
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
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": "get_database_bloat_overview"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of schemas to show (1-50, default: 10) | |
| database_name | No | Target database name (uses default database from POSTGRES_DB env var if omitted) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |