SHOW FEEDBACK REOPTIMIZATION STATUS
On this page
Note
This feature is an opt-in preview.
Opt-in previews allow you to evaluate and provide feedback on new and upcoming features prior to their general availability.
Displays system-wide Feedback Reoptimization (FR) information.
Syntax
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. |
|
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 |
|
FR Query Auto Marking Misestimation Tolerance Ratio |
The misestimation tolerance ratio above which a query will be marked for feedback reoptimization when |
|
FR Query Auto Marking Misestimation Count Threshold |
The misestimation tolerance count threshold above which a query will be marked for feedback reoptimization when |
|
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
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 |
+-----------------------------------------------------------+-------+Last modified: June 13, 2025