Awesome
Entity Framework Core Query Plan Visualizer
View Entity Framework Core query plan directly inside Visual Studio.
Introduction
With Entity Framework Core query plan debugger visualizer, you can view the query plan of your queries directly inside Visual Studio. Currently, the visualizer supports SQL Server and PostgreSQL.
[!IMPORTANT] The visualizer requires Visual Studio Version 17.9.0 (Released on February 13th) or newer and supports EF Core 7 or newer.
Usage
After installing the extension from the marketplace, a new debugger visualizer will be added to Visual Studio. When debugging, hover over your queries and there will be an option to view the query plan:
Click on 'Query Plan Visualizer' and the query plan will be displayed for your query.
SQL Server:
PostgreSQL:
Known Issues:
- If query plan extraction takes more than 5 seconds, you will get Evaluation timed out error
- If your project uses Application Insights, you might get Cannot evaluate expression since the function evaluation requires all threads to run. when viewing query plan. Workaround - disable Application Insights when running your project with a debugger attached.
Credits
This extension uses pev2 and html-query-plan to display query plans.