EFCore.Visualizer

Entity Framework Core Query Plan Visualizer

View Entity Framework Core query plan directly inside Visual Studio.

Introduction

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.

Visual Studio Toolbox - EFCore.Visualizer Extension for Visual Studio

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 (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.

SQL Server:

PostgreSQL:

MySQL:

SQLite:

Oracle:

The query plan includes Actual IO stats, Outline data, Projections, and Predicates.

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, html-query-plan and Treeflex to display query plans.