Advisor Insights
Check Frequency
Daily
Default Configuration
Detects queries whose execution plans from the last seven days contain a supported Query Advisor insight and creates an issue with severity "info". Currently detected problems are inefficient nested loops, wrong indexes due to ORDER BY, inefficient index use, late join filters with OR, or disk spills due to low work_mem. Ignores plans without a supported insight, and resolves automatically once the query's recent plans no longer show one.
Guidance
Impact
A tuning opportunity means the query is running less efficiently than it could, using more CPU and I/O and taking longer than necessary. Each insight comes with a concrete suggestion (such as a query rewrite or a configuration change) that you can validate in a Workbook before applying it.
You can learn about Query Advisor and the supported insight types in the Query Advisor documentation.
This check is enabled by default.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →