Skip to main content

analyze_query_pattern

Function analyze_query_pattern 

Source
pub fn analyze_query_pattern(
    query_type: &str,
    execution_count: u64,
    execution_times_ms: &[f64],
    rows_examined: &[f64],
    rows_returned: &[f64],
) -> QueryPatternAnalysis
Expand description

Analyze query execution pattern

§Arguments

  • query_type - Type of query (SELECT, INSERT, UPDATE, DELETE)
  • execution_count - Number of times query executed
  • execution_times_ms - Slice of execution times in milliseconds
  • rows_examined - Slice of rows examined per execution
  • rows_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,
    &times,
    &examined,
    &returned
);
assert_eq!(analysis.query_type, "SELECT");
assert_eq!(analysis.execution_count, 5);