Announcing More Improvements to PasteThePlan.com
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:
We noticed that a lot of people were pasting in estimated execution plans, which frankly doesn’t get you very good advice from either humans or AI. We added a warning suggesting that you paste the actual plan instead.
Note the “Delete Plan” button at the top right – that’s new too. I’d been getting more and more emails from people who realized that pasting their query plans into a web site meant that their query plans were, uh, on a web site, and I got tired of manually deleting those behind the scenes.
On the AI Suggestions tab, there’s a new feedback form so that after you try the AI’s advice, you can tell me how it did. I get notifications about the feedback, and I review it on a regular basis to help tune the prompt I send to the AI.
Finally, there’s a new “Get a Second Opinion” button at the bottom. The default first opinion is a fast, cheap call to gpt-5.4-nano that should return within 30 seconds. The second opinion calls gpt-5.4, a slower model that produces more in-depth results, but takes longer to do it (up to 3 minutes.)
I hope this helps you get more help, faster, whether that help is from your fellow humans by sharing your query plan’s link to forums and friends, or whether it’s instant free AI advice.
4 Comments. Leave new
In regards to sp_blitz* procs such as sp_blitzwho. In SS2019 when drilling on on query plan am I seeing actual or estimated plans? Even with “@GetLiveQueryPlan=1” I only see “live query plans” captured half of the time whereas the “query plan” column always has plan data captured and is drillable. A good plug for some of your wisdom and this URL: https://www.brentozar.com/archive/2017/10/get-live-query-plans-sp_blitzwho/. And even a chance to mention… in Fundamentals class… or my Mastering class we cover…
sp_BlitzWho is for currently running queries that haven’t finished yet. You don’t want to use those for performance analysis, nor do you want to use them in PasteThePlan.
For plan performance analysis, use sp_BlitzCache.
To get a query’s actual plan, you can run it in SSMS with Actual Plan turned on, or you can turn on the database-scoped option LAST_QUERY_PLAN_STATS. That does come with performance risks, though.
We talk about these choices in my free class, How I Use the First Responder Kit. Cheers!
Great stuff. I’ve been using PasteThePlan for a couple of weeks and it has helped me alot.
Thanks this is a great resource.
I’ve been using AI to discuss my crappy SQL so this enables focused advice on my SQL and makes suggestions both on the SQL and indexes.
I use this resource several times a day when I’m working on SQL.
Thanks again!