search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 899 forks source link

Explain Button Runs Query and Doesn't Return Execution Plan for Synapse DB #15158

Open matayp opened 3 years ago

matayp commented 3 years ago

Issue Type: Bug

Really simple issue....when pressing the explain button on any query (connected to an azure syanpse DB SQLDW) the query executes and returns data but never returns the execution plan. I have also tried the command palette option for the actual plan and this also just runs the query and doesn't return an execution plan.

Azure Data Studio version: azuredatastudio 1.27.0 (765c7064d46253d88393e0e1ff78874b6fe8fa64, 2021-03-16T21:24:59.168Z) OS version: Windows_NT x64 10.0.18363

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i5-8250U CPU @ 1.60GHz (8 x 1800)| |GPU Status|2d_canvas: enabled
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
oop_rasterization: disabled_off
opengl: enabled_on
protected_video_decode: enabled
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled| |Load (avg)|undefined| |Memory (System)|7.75GB (1.35GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (11) Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 admin-tool-ext-win|Mic|0.0.2 agent|Mic|0.48.0 dacpac|Mic|1.8.0 import|Mic|1.3.0 profiler|Mic|0.11.0 query-history|Mic|0.1.0 schema-compare|Mic|1.9.1 sql-database-projects|Mic|0.7.1 azdata-sanddance|msr|3.1.0 vscodeintellicode|Vis|1.2.1
alanrenmsft commented 3 years ago

Just chatted with our PM @yualan , turns out DW doesn't support query plan. assigning to PM team to follow up with the DW folks.

lexisstv commented 2 years ago

It's not synapse problem. On same server explain plan in SSMS works. Also plan in XML returns with command:

EXPLAIN
SELECT ...

But this plan not shown in editor (single grid cell)

kmatt commented 2 years ago

This is still an issue with v1.35.0.

SSMS 18 and Solarwinds Plan Explorer are able to render a graphical explain plan.

Also note that SSMS is able to render .sqlplan files exported from the Synapse web UI.

Version: 1.35.0 (user setup) Commit: e9c8eb8564f537726b36b5f15c7f35e62f229284 Date: 2022-02-23T17:36:02.883Z VS Code: 1.59.0 Electron: 13.5.0 Chrome: 91.0.4472.164 Node.js: 14.16.0 V8: 9.1.269.39-electron.0 OS: Windows_NT x64 10.0.19044

dem108 commented 1 year ago

I have the same symptom and my version is 1.44.1 (user setup).