History of statement performance


The following example shows a portion of the performance history section of an elapsed time exception report: 

Example
                                                                Statement
   Elapsed time               Average History level              Type       Calls  Selects
+==================+ ==========================================  ======    ======  =======
|>                 |        0.000021 MONTHLY   2009-06           SELECT      4000     4000
|>>>>>>            |        1.853088 MONTHLY   2009-10           SELECT     25892    25892
|>>>>>>            |        1.783560 WEEKLY    2009-10-11        SELECT      1581     1581
|>>>>>>            |        2.011105 WEEKLY    2009-10-18        SELECT     10466    10466
|>>>>>>            |        1.741576 WEEKLY    2009-10-25        SELECT     13845    13845
|>>>>>             |        1.349979 WEEKLY    2009-11-01        SELECT      6394     6394
|>>>>>             |        1.349979 MONTHLY   2009-11           SELECT      6394     6394
|>>>>>>            |        2.009972 MONTHLY   2009-12           SELECT       214      214
|>>                |        0.304685 WEEKLY    2009-12-13        SELECT      5548     5548
|>>                |        0.351906 WEEKLY    2009-12-20        SELECT      2817     2817
|>>>>>>            |        2.009972 WEEKLY    2009-12-27        SELECT       214      214
|>>>>>>>>>>>>>>>>>>|        6.893685 XCPT:01-20-00.59.38.988630  SELECT         1        1
+==================+

This section contains following topic:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*