Need to share an execution plan, like on forums or on Stack Overflow, and you wanna get their advice as quickly as possible? Paste the XML into PasteThePlan.com and you get a link that you can share to anyone with your plan's details.
The user interface is now cleaner, with separate tabs for query plan, query text, AI suggestions, raw XML, and your recent plans:
PasteThePlan has a new AI Suggestions tab, and it's been really fun to watch the query plans come in and the advice go out. Here are some examples: Date "tables" - when I looked at the query, I glossed over the real problem. I thought arc_Calendar was a real date table, but AI figured out…
At PasteThePlan.com, you can paste execution plans into your browser, then send a link to someone else to get query advice. It's useful for online forums, Stack Exchange, and the like.
After you paste the plan, you've got a new AI Suggestions tab. It sends your query plan (and my custom prompt) up to ChatGPT 5.3, and in 30 seconds or less, you get a second opinion on ways to make it go faster:
We have this PasteThePlan where you can copy/paste the contents of execution plans, and then share the links around the web. You've pasted 16,621 plans so far, and I'm always amused to see them continuing to trickle in every day without us actively promoting that tool. It just works, doing its thing quietly. Back in…
I just updated PasteThePlan, and the change you'll notice first is that we're using the latest version of Justin Pealing's html-query-plan. It adds missing index hints, yellow bangs for warnings like implicit conversions and no join predicate, and more. Check out this example plan:
Plus variable line widths for different amounts of data:
We're back at it again. We took a bit of time out of our busy schedule to put in a few enhancements into PasteThePlan.com. Here's some of the highlights: Updated to the latest version of HTML Query Plan. In order to create a graphical query plan we use Justin Pealing's awesome HTML Query Plan. Recently,…
If you couldn't tell, we're big fans of open source software. We like it so much that we recently released our First Responder Kit, including sp_Blitz, under the MIT license. So when we were building Paste The Plan, our free tool to share SQL Server execution plans, there was no question that we were going to use a bunch of open source software. Here's the rundown of which open source tools we used and why we chose it.
If you've ever heard the Away From the Keyboard, a podcast that I co-host with Cecil Phillip, you'll quickly discover that I love hearing stories about how products are created. Now I get to tell you the story of how Paste The Plan became real and the architecture around it. In a world... Here at Brent Ozar…
Since the dawn of man, people have struggled with sharing execution plans with each other for performance tuning. Now, it's easy. First, get yourself a plan: Get the estimated execution plan by hitting control-L or clicking Query, Display Estimated Plan. Right-click on the graphical plan, and click View XML. Copy all of that. Or even…
