[FEATURE]

[frodr1k]

Which component(s) does this affect?

• Desktop App
• CLI Tool
• SSMS Extension
• Plan Analysis Rules
• Documentation

Problem Statement

I like the querystore option a lot. But there are som stuff I'd like to improve when it comes to filtering:

I'd like to be able to exclude plans with certain keywords (for instance If I know I have a lot of fully OK transactions I'm totally good with I want to ignore them based on keywords like tables or command.

I love the idea of filtering on hours. But I also want to filter on between hours. Like 2-4 hours back in time only

Proposed Solution

Implement a filter ability for

• keywords
• plans-numbers
• time of executions
• between certain hours.

Use Case

Easier to narrow down information and remove background noise from "legit" operations.

Alternatives Considered

I dont really see any alternative here. I need to query the QS directly then.

[erikdarlingdata]

Thanks for opening this! We've shipped the first round of Query Store filtering in the upcoming release:

• Search by identifier: Query ID, Plan ID, Query Hash, Plan Hash, Module Name — all work as server-side filters on Fetch (Desktop, CLI, and MCP)
• Module names are schema-qualified (dbo.MyProc) with wildcard support (dbo.%Order%)
• Column-level filtering on all columns (including the new identifier columns) for post-fetch refinement
• Database picker on the Query Store tab so you can switch databases without reopening

For the remaining items in your request, I want to make sure I understand what you're looking for before building the wrong thing:

1. Keyword filtering — When you say "exclude plans with certain keywords," are you looking to filter out queries that contain specific table names or command text? Like a text exclusion filter (e.g., "hide everything that mentions dbo.AuditLog")? Or something else?

2. Time filtering — You mention "filter on between hours" and "time of executions." Could you clarify with an example? Are you looking for:

   • A time window like "only show queries that ran between 2 and 4 hours ago" (skip the most recent 2 hours)?
   • A time-of-day filter like "only show queries that ran between 9:00 AM and 5:00 PM"?
   • Something else entirely?

Examples of what you'd type or select in the UI would be really helpful so we can nail the UX.

Also — are you planning to contribute any of this yourself, or would you like us to build it out?

[frodr1k]

I gonna try the features you added. But I have to come back on that when I can view the plans again.

Keyword filtering is as you say describe it. I want to hide specific queries/plans which contains certain keywords, such as you mention a certain table or more likely all spamming from other management tools.

Time of Day or Window is perfectly fine either. Could also be a combination of time of day and X hours back. Time of day is great if you want to narrow it down very much.

My VSCode+GitHub-Claude-FU would maybe not pass QA but... you never know what I can whip up ;)