Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres EXPLAIN ANALYZE result view as text #1044

Open
hansinator opened this issue Nov 23, 2022 · 0 comments
Open

Postgres EXPLAIN ANALYZE result view as text #1044

hansinator opened this issue Nov 23, 2022 · 0 comments
Labels
feature request New issue opened using "Feature request" template

Comments

@hansinator
Copy link

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

@hansinator hansinator added the feature request New issue opened using "Feature request" template label Nov 23, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New issue opened using "Feature request" template
Projects
None yet
Development

No branches or pull requests

1 participant