partition_analysis
List all partitioned tables across schemas or analyze specific table's partitions for details, size, activity, indexes, and maintenance needs.
Instructions
Partition analysis - list all partitioned tables or analyze specific table.
LEVEL: Schema ↔ Table (multi-level tool)
table=None (default): Lists all partitioned tables across ALL schemas
table='orders': Requires schema - detailed partition analysis for that table
USE FOR: partitions, partition analysis, partition details, partition size, inheritance, "which tables are partitioned?", partition skew detection, empty partition identification. DO NOT USE FOR: non-partitioned table maintenance (use maintenance_analysis), schema structure (use get_schema), index health (use maintenance_analysis).
INCLUDE OPTIONS (only when table is specified):
'all': Everything (default)
'details': Partition details - boundaries, row counts, dead rows
'size': Size distribution - partition sizes, percentages, skew detection
'activity': Partition activity - inserts, updates per partition
'indexes': Partition indexes
'maintenance': Empty partitions, maintenance candidates, default partitions
Examples: partition_analysis() - List all partitioned tables across all schemas partition_analysis(table='events', schema='logs') - Detailed analysis of events table partition_analysis(table='orders', schema='shipment', include='size') - Size distribution
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | Partitioned table name (omit to list all partitioned tables) | |
| schema | No | Schema name. REQUIRED when table is specified. Use get_schema() to list available schemas. | |
| include | No | What to include: 'all', 'details', 'size', 'activity', 'indexes', 'maintenance' | all |
| format | No | Output format: 'json' or 'markdown' | json |
| url | No | Database URL for auto-connection |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |