The Regressed queries report page shows queries with regressed performance over time. Query Store analyzes database workload and extracts the 25 most regressed queries according to the chosen metrics. You can choose between the following metrics: CPU time, Duration, Logical reads, Logical writes, Physical reads, Memory consumption, CLR time, DOP, and Row Count. You can also decide whether you want to see total numbers or maybe average, max, min, or standard deviation of the value chosen in the first step. The following screenshot shows regressed queries in a moderate database in a chart format:

The chart format allows you to focus on the most regressed queries. As you can see, there are three panes on the page. In the first pane, you can see up to 25 of the most regressed queries. The pane on the right side shows execution plans over time for the query chosen in the left pane. Finally, the bottom pane shows a graphical representation of the plan chosen in the second pane.

In the top-right corner in the left pane, you can find an option which allows you to choose between the chart and grid format of regressed queries. The same regressed queries but in a grid format are shown in the following screenshot:

Compared to the other display mode, only the left pane is different. It contains textual information such as query text, the procedure name, and numerical values for many metrics with significantly more information than chart view.

In the top-right corner in the right pane, you can configure time intervals for query executions. In the previous figure, the time interval is set to a custom one (22.10.–03.12.).