# SHOW FEEDBACK REOPTIMIZATION STATUS Displays system-wide Feedback Reoptimization (FR) information. ## 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](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/reoptimize.md)since startup. | | Total unique queries explicitly reoptimized since startup | The total number of unique queries[explicitly re-optimized](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/reoptimize.md)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; ``` ```output +-----------------------------------------------------------+-------+ | 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 | +-----------------------------------------------------------+-------+ ``` *** Modified at: October 1, 2025 Source: [/cloud/reference/sql-reference/show-commands/show-feedback-reoptimization-status/](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-feedback-reoptimization-status/) (An index of the documentation is available at /llms.txt)