Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

SHOW FEEDBACK REOPTIMIZATION STATUS

Syntax

SQL

SHOW FEEDBACK REOPTIMIZATION STATUS;

Output

Statistic	Description
Node Id	The unique ID of a given node.
Queries Being Reoptimized	The number of queries currently in the reoptimization process.
Normal Queries Running	The number of queries that have not been re-optimized that are currently running.
Reoptimized Queries Running	The number of queries that have been re-optimized that are currently running.
Queries Marked for Reoptimization in Plancache	The number of queries that are marked for reoptimization in the plancache.
Reoptimized Queries in Plancache	The number of query plans that are the result of reoptimization in the plancache.
Reoptimization Converged Queries in Plancache	The number of reoptimization queries that have converged in the plancache. Converged indicates that the query cannot be re-optimized further using the current execution statistics.
FR Query Auto Marking CPU Threshold (MS)	The execution time threshold, in milliseconds, below which a query will not be marked for feedback reoptimization when `optimizer_feedback_reoptimization_auto_marking` is set to `AUTO`.
FR Query Auto Marking Misestimation Tolerance Ratio	The misestimation tolerance ratio above which a query will be marked for feedback reoptimization when `optimizer_feedback_reoptimization_auto_marking` is set to `AUTO`.
FR Query Auto Marking Misestimation Count Threshold	The misestimation tolerance count threshold above which a query will be marked for feedback reoptimization when `optimizer_feedback_reoptimization_auto_marking` is set to `AUTO`.
FR Auto Marking Condition Skipped Run Count	The number of runs that met mis-estimation criteria for feedback reoptimization, but which have been skipped (not marked for feedback reoptimization) from because of variable settings.
FR Auto Marking Condition UnSatisfied Run Count	The number of runs that were not marked for feedback reoptimization because they did not satisfy the mis-estimation conditions.
FR Auto Marked Query Count	The number of queries in the plancache that have been automatically marked for feedback reoptimization.
FR Auto Marked Unique Query Count	The number of unique queries in the plancache that have been automatically marked for feedback reoptimization.
Total queries reoptimized since startup	The total number of queries feedback re-optimized since startup.
Total unique queries reoptimized since startup	The total number of unique queries feedback re-optimized since startup.
Total explicitly reoptimized queries since startup	The total number of queries explicitly re-optimized since startup.
Total unique queries explicitly reoptimized since startup	The total number of unique queries explicitly re-optimized since startup.
Total FR plans ran since startup	The total number of feedback re-optimized query plans that have been run since startup.
Total FR plan execution failures	The total number of feedback re-optimized query plans that have failed during execution since startup.
Total FR plan commit skips	The total number of feedback re-optimized query plans that have run, but have skipped commit since startup.
Total FR plan commit failures	The total number of feedback re-optimized query plans that have run, but have failed to commit since startup.
Total FR plan commits	The total number of feedback re-optimized query plans that have run and committed since startup.
Total unique FR plan commits	The total number of unique feedback re-optimized query plans that have run and committed since startup.

Example

SQL

SHOW FEEDBACK REOPTIMIZATION STATUS;

+-----------------------------------------------------------+-------+
| Stat                                                      | Value |
+-----------------------------------------------------------+-------+
| Node Id                                                   |     1 |
| Queries Being Reoptimized                                 |     0 |
| Normal Queries Running                                    |     0 |
| Reoptimized Queries Running                               |     0 |
| Queries Marked For Reoptimization in Plancache            |     0 |
| Reoptimized Queries in Plancache                          |     0 |
| Reoptimization Converged Queries in Plancache             |     0 |
| FR Query Auto Marking CPU Threshold (MS)                  |   500 |
| FR Query Auto Marking Misestimation Tolerance Ratio       |   100 |
| FR Query Auto Marking Misestimation Count Threshold       |     1 |
| FR Auto Marking Condition Skipped Run Count               |     0 |
| FR Auto Marking Condition UnSatisfied Run Count           |    21 |
| FR Auto Marked Query Count                                |     0 |
| FR Auto Marked Unique Query Count                         |     0 |
| Total queries reoptimized since startup                   |     0 |
| Total unique queries reoptimized since startup            |     0 |
| Total explicitly reoptimized queries since startup        |     0 |
| Total unique queries explicitly reoptimized since startup |     0 |
| Total FR plans ran since startup                          |     0 |
| Total FR plan execution failures                          |     0 |
| Total FR plan commit skips                                |     0 |
| Total FR plan commit failures                             |     0 |
| Total FR plan commits                                     |     0 |
| Total unique FR plan commits                              |     0 |
+-----------------------------------------------------------+-------+