-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
QO 2022-09-05, QO 2022-09-19, QO 2022-10-03
Analyse error distributions for ABT nodes representing storage engine (WT) operations:
- Index Seek
- Seek
- Scan
And some non-disk operations, e.g. filter.
1. Run an experiment with about 40 queries for every run
2. Calculate observational statistics of execution time parameter: median, mean, standard deviation, correlation with number of processed rows
3. Check the hypothesis that the distribution of execution time values is close to normal distribution using Kolmogorov-Smirnov test (scipy.stats.kstest). One way is to calculate z-scores= (value - media)/stddev and compare with standard distribution.
4. Create a table with results.