Automatic query performance regression management

A computing system, comprising:

• memory;
• one or more hardware processors coupled to the memory;
• and
• one or more computer readable storage media storing instructions that, when loaded into the memory, cause the one or more hardware processors to perform operations comprising:
• detecting performance regression of executing a query using a current query plan;
• responsive to detecting the performance regression, automatically searching for one or more candidate solutions for resolving the performance regression;
• selecting, from the one or more candidate solutions identified responsive to detecting the performance regression, an effective solution that resolves the performance regression, wherein the selecting comprises automatically evaluating performance of executing the query using one or more alternative query plans generated by the one or more candidate solutions;
• and
• storing the effective solution for future execution of the query, wherein the effective solution is configured to generate an updated query plan selected from the one or more alternative query plans, wherein the updated query plan has better performance than the current query plan for executing the query,
• wherein detecting the performance regression comprises comparing one or more performance metrics of executing the query using the current query plan with corresponding performance metrics stored in an execution history,
• wherein the one or more performance metrics comprise query execution time, wherein the performance regression is detected if the query execution time of executing the query using the current query plan is M times greater than an average of N most recent query execution times stored in the execution history, wherein M is predefined and greater than 1, and N is a predefined positive integer.

One or more non-transitory computer-readable media having encoded thereon computer-executable instructions causing one or more processors to perform a method comprising:

• detecting performance regression of executing a query using a current query plan;
• responsive to detecting the performance regression, automatically searching for one or more candidate solutions for resolving the performance regression;
• selecting, from the one or more candidate solutions identified responsive to detecting the performance regression, an effective solution that resolves the performance regression, wherein the selecting comprises automatically evaluating performance of executing the query using one or more alternative query plans generated by the one or more candidate solutions;
• and
• storing the effective solution for future execution of the query, wherein the effective solution is configured to generate an updated query plan selected from the one or more alternative query plans, wherein the updated query plan has better performance than the current query plan for executing the query,
• wherein detecting the performance regression comprises comparing one or more performance metrics of executing the query using the current query plan with corresponding performance metrics stored in an execution history,
• wherein the one or more performance metrics comprise query execution time, wherein the performance regression is detected if the query execution time of executing the query using the current query plan is M times greater than an average of N most recent query execution times stored in the execution history, wherein M is predefined and greater than 1, and N is a predefined positive integer.