Hello,
Firstly, my thanks for creating SquirrelSQL! Our environment is very
heterogenous, so it's nice to have a single tool that can work with all of
the different types of databases we have.
I'm currently using SquirrelSQL to connect to a number of PostgreSQL
databases. With the Oracle driver, when viewing the plan you see it in a
nice tree form with columns for each aspect of a step.
However, with PostgreSQL, you just see text output that's difficult to
read for a plan that has more than a few joins. Fortunately, it seems like
the EXPLAIN command in PostgreSQL supports multiple formats including XML,
JSON, and YAML which should be easier to parse and then display in a
logical manner.
So, is this a feature request that you would be willing to work on? I'd
certainly be happy to test and give feedback. If not, would you be able to
at least point me to the correct place in the code? I'm not a great Java
programmer, but would be willing to give it a shot if you'd agree to
review and commit it when done.
Thanks,
--Joe
|