handle_diagnose_query_performance
Analyzes Redshift query performance by fetching execution plan, metrics, and alerts, generating structured reports with identified issues and optimization recommendations.
Instructions
Analyzes a specific query's execution performance.
Fetches query text, execution plan, metrics, alerts, compilation info,
skew details, and optionally historical run data. Uses a formatting
utility to synthesize this into a structured report with potential issues
and recommendations.
Args:
ctx: The MCP context object.
query_id: The numeric ID of the Redshift query to analyze.
compare_historical: Fetch performance data for previous runs of the
same query text. Defaults to True.
Returns:
A dictionary conforming to DiagnoseQueryPerformanceResult structure:
- On success: Contains detailed performance breakdown, issues, recommendations.
- On query not found: Raises QueryNotFound exception.
- On other errors: Raises DataApiError or similar for FastMCP to handle.
Raises:
DataApiError: If a critical error occurs during script execution or parsing.
QueryNotFound: If the specified query_id cannot be found in key tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| compare_historical | No | ||
| query_id | Yes |
Input Schema (JSON Schema)
{
"properties": {
"compare_historical": {
"default": true,
"title": "Compare Historical",
"type": "boolean"
},
"query_id": {
"title": "Query Id",
"type": "integer"
}
},
"required": [
"query_id"
],
"title": "handle_diagnose_query_performanceArguments",
"type": "object"
}