Methods
analyzeQuery
- analyzeQuery(sql, executionTime, rowCount): QueryAnalysis
Parameters
- sql: string
- executionTime: number
- rowCount: number
Returns QueryAnalysis
getPerformanceMetrics
- getPerformanceMetrics(): PerformanceMetrics
Returns PerformanceMetrics
getN1DetectionReport
- getN1DetectionReport(): N1Detection[]
Returns N1Detection[]
getOptimizationRecommendations
- getOptimizationRecommendations(): {
critical: N1Detection[];
high: N1Detection[];
medium: N1Detection[];
suggestions: string[];
} Returns {
critical: N1Detection[];
high: N1Detection[];
medium: N1Detection[];
suggestions: string[];
}
critical: N1Detection[]
high: N1Detection[]
medium: N1Detection[]
suggestions: string[]
clearHistory
- clearHistory(): void
Returns void
Analyze query for N+1 patterns and performance issues