mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.45k stars 292 forks source link

Postgres EXPLAIN ANALYZE result view as text #1044

Open hansinator opened 1 year ago

hansinator commented 1 year ago

Is your feature request related to a problem? Please describe. When using Postgres EXPLAIN ANALYZE queries the results are shown in the standard result view like table data and are thus hard to read because they lack the indentation which is required to understand the query plan nesting. It is a bit like Python without indents.

Describe the solution you'd like I would like the results of EXPLAIN ANALYZE to be shown in a standard text editor. A bonus would be if the language mode of that text editor tab could be set to pg-plan to make use of the postgres-plan syntax highlighting extension.

Describe alternatives you've considered I have considered exporting the results as CSV format which comes close but adds characters that are not desired in the output.

Additional context Syntax-highlighted text view (left) vs result view (right) image