View Entity Framework Core query plan directly inside Visual Studio.
With the 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, PostgreSQL, SQLite, MySQL and Oracle.
Important
The visualizer requires Visual Studio Version 17.9.0 (Released on February 13th, 2024) or newer and supports EF Core 7 or newer.
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 (Here we show the actual query plan which means it forces query execution ):
Click on 'Query Plan Visualizer' and the query plan will be displayed for your query.
The query plan includes Actual IO stats, Outline data, Projections, and Predicates.
- 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.
This extension uses pev2, html-query-plan and Treeflex to display query plans.