pub fn analyze_query_pattern(
query_type: &str,
execution_count: u64,
execution_times_ms: &[f64],
rows_examined: &[f64],
rows_returned: &[f64],
) -> QueryPatternAnalysisExpand description
Analyze query execution pattern
§Arguments
query_type- Type of query (SELECT, INSERT, UPDATE, DELETE)execution_count- Number of times query executedexecution_times_ms- Slice of execution times in millisecondsrows_examined- Slice of rows examined per executionrows_returned- Slice of rows returned per execution
§Returns
Query pattern analysis with optimization recommendations
§Examples
use celers_broker_sql::utilities::analyze_query_pattern;
let times = vec![10.0, 15.0, 12.0, 20.0, 11.0];
let examined = vec![1000.0, 1200.0, 1100.0, 1500.0, 1000.0];
let returned = vec![10.0, 12.0, 11.0, 15.0, 10.0];
let analysis = analyze_query_pattern(
"SELECT",
5,
×,
&examined,
&returned
);
assert_eq!(analysis.query_type, "SELECT");
assert_eq!(analysis.execution_count, 5);