QueryOptimizationSuggestion AI schema

[shaykeren]

QueryOptimizationSuggestionRequest:

{
   "apiKey": "",
   "query": "",
   "ormFramework": "",  //[optional, can be null or empty]  possible options: Hibernate,
   "instrumentationLibrary": ""
}

QueryOptimizationSuggestionResponse

Compare with: https://claude.site/artifacts/e7e2c630-9b57-4645-ae13-7dc65422a079

{
   "recommendations": [
   {
     "title": "Consolidate window operations and implement data pre-aggregation strategy",
     "priority: "Critical",
     "description": "Multiple Window Functions with Shared Partition Key. Three window functions (SUM, FIRST_VALUE, MIN) sharing the same partition key (bin_number) indicate inefficient repeated data access patterns. The 13.3x performance degradation strongly suggests this as the primary bottleneck.",
     "actionItems: ["Create a staging table that pre-calculates SUM(bin_value) and MIN(created_at) per bin_number", "Implement an efficient UPSERT mechanism to maintain latest bin_metadata","Set up intelligent refresh cycles based on data update patterns", "Add monitoring for staging table refresh performance "],
      "modifiedCode": "[optional if we can show the modified query]",
      "sources": []
   }]
}

related to backend : https://github.com/digma-ai/digma-collector-backend/issues/2785