ch_disk_usage
Analyze disk usage by table and partition, providing per-table breakdown, TTL information, and recommendations for optimization.
Instructions
Analyze disk usage by table and partition with recommendations.
Returns:
Total disk usage for the database
Per-table breakdown (rows, size, parts, percentage)
Per-partition breakdown (top 20 by size)
TTL information
Recommendations (excessive parts, missing TTL on large tables)
Args: database: Database to analyze (default: cdc_pipeline)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | cdc_pipeline |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |