search

sasha-alias / sqltabs

Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift, Google Firebase (Firestore)
https://www.sqltabs.com
GNU General Public License v3.0
803 stars 57 forks source link

Explain and Explain Analyze shortcuts #59

Closed yazun closed 7 years ago

yazun commented 8 years ago

It would be nice to have shortcuts to run explain (explain analyze) on a selection.

yazun commented 8 years ago

Also sharing directly plans via explain.depesz.com would be nice.

sasha-alias commented 8 years ago

Honestly I have never had issues with typing EXPLAIN :) Also there is a concept that you see in output the result of what you have in editor. Thus when you share output it's clear what is the input. So separate shortcut for explain doesn't play nicely with overall concept. I will keep it for a while and think about it.

Regarding explain.depesz.com I rather think about integration with PEV

sasha-alias commented 7 years ago

finally it won't be neither depesz nor PEV but smth home-brewed #93 this will allow to share query plans as any other query result via sqltabs.com

sasha-alias commented 7 years ago

both query plan visualisation and sharing via https://share.sqltabs.com are implemented in v0.18.0 release. separate shortcuts for explain and explain analyze won't be implemented