Skip to content

Giorgi/EFCore.Visualizer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

60 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

EFCore.Visualizer

Entity Framework Core Query Plan Visualizer

View Entity Framework Core query plan directly inside Visual Studio.

Visual Studio Marketplace Version Visual Studio Marketplace Downloads Visual Studio Marketplace Rating

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, and Oracle.

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 (Here we show the actual query plan which means it forces query execution ):

VariableVisualizer

Click on 'Query Plan Visualizer' and the query plan will be displayed for your query.

SQL Server:

Sql Server Plan

Sql Server Plan

PostgreSQL:

PostgreSQL Plan

PostgreSQL Plan

Oracle:

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

Oracle Plan Oracle Plan

Known Issues:

Credits

This extension uses pev2 and html-query-plan to display query plans.