4 ms·

Could the workflow done so that you just copy-paste output from a PSQL shell to an online tool?

bflesch 7y ago
Yes, some tools such as the query analyzer by depesz [1] work by copy-pasting the EXPALIN ANALYZE output into your browser. But IMHO the overall friction is still too large for such a central use case as query optimization done by a database admin. The PostgreSQL team has been innovating and improving steadily, so I am confident these kind of workflows will be heavily optimized within the next couple of years. [1] https://explain.depesz.com/ https://explain.depesz.com/
- rc_mob 7y ago
  Mighty god odin bless you for that link. Thank u so much
  - takeda 7y ago
    that tool is a must if you plan improve, depesz (who is here on HN) also has good blog about postgres, he describes new upcoming features. He also wrote a blog series about understanding explain plans: https://www.depesz.com/tag/unexplainable/ https://www.depesz.com/tag/unexplainable/ his explain tool + that information is really good starting point when trying to optimize queries.
ken 7y ago
Had this been implemented as a web service, half of the crowd would be asking for it to be an open-source program, so they could run it locally, for speed and flexibility and security. It was implemented as an open-source program, so half of the crowd are asking for it to be a web service for usability and convenience and aesthetics. What I'm seeing is we've got two big platforms (web, CLI) and they both have some distinct advantages and some distinct disadvantages, and it's not easy for either one to cross the chasm and compete with the other one directly. We desperately need a new platform which combines what we like about both of these, and discards what we don't. Until then, we're just going to keep implementing all end-user functionality twice, because by historical accident developers do most of their work in a DEC VT100 emulator, and end-users won't tolerate that.
- Xylakant 7y ago
  > It was implemented as an open-source program, so half of the crowd are asking for it to be a web service for usability and convenience and aesthetics I’ll prefer that any time of day. At least, this way someone can easily turn it into a web service. It generates HTML afaics.
  - londons_explore 7y ago
    A good number of github projects I find say "Install with npm install foo, or try it out online [here]" The online version can host the exact same code from git master. For many projects, no hosting is even required, because the whole thing can run in a codepen-like playground.
- mgartner 7y ago
  I built it as a CLI because of the reasons you mention, but also because I find that workflow most convenient for me and I didn’t want to need an internet connection.
aeyes 7y ago
This is the best tool I know, works pasting only the JSON output: http://tatiyants.com/postgres-query-plan-visualization/ http://tatiyants.com/postgres-query-plan-visualization/ The information density the rendering gives me is way better than the flamegraph.
- daamien 7y ago
  See PEV2 : https://github.com/dalibo/pev2 https://github.com/dalibo/pev2

Yes, some tools such as the query analyzer by depesz [1] work by copy-pasting the EXPALIN ANALYZE output into your browser. But IMHO the overall friction is still too large for such a central use case as query optimization done by a database admin. The PostgreSQL team has been innovating and improving steadily, so I am confident these kind of workflows will be heavily optimized within the next couple of years. [1] https://explain.depesz.com/ https://explain.depesz.com/

rc_mob 7y ago
Mighty god odin bless you for that link. Thank u so much
- takeda 7y ago
  that tool is a must if you plan improve, depesz (who is here on HN) also has good blog about postgres, he describes new upcoming features. He also wrote a blog series about understanding explain plans: https://www.depesz.com/tag/unexplainable/ https://www.depesz.com/tag/unexplainable/ his explain tool + that information is really good starting point when trying to optimize queries.

ken 7y ago

Had this been implemented as a web service, half of the crowd would be asking for it to be an open-source program, so they could run it locally, for speed and flexibility and security. It was implemented as an open-source program, so half of the crowd are asking for it to be a web service for usability and convenience and aesthetics. What I'm seeing is we've got two big platforms (web, CLI) and they both have some distinct advantages and some distinct disadvantages, and it's not easy for either one to cross the chasm and compete with the other one directly. We desperately need a new platform which combines what we like about both of these, and discards what we don't. Until then, we're just going to keep implementing all end-user functionality twice, because by historical accident developers do most of their work in a DEC VT100 emulator, and end-users won't tolerate that.

Xylakant 7y ago
> It was implemented as an open-source program, so half of the crowd are asking for it to be a web service for usability and convenience and aesthetics I’ll prefer that any time of day. At least, this way someone can easily turn it into a web service. It generates HTML afaics.
- londons_explore 7y ago
  A good number of github projects I find say "Install with npm install foo, or try it out online [here]" The online version can host the exact same code from git master. For many projects, no hosting is even required, because the whole thing can run in a codepen-like playground.
mgartner 7y ago
I built it as a CLI because of the reasons you mention, but also because I find that workflow most convenient for me and I didn’t want to need an internet connection.

aeyes 7y ago

This is the best tool I know, works pasting only the JSON output: http://tatiyants.com/postgres-query-plan-visualization/ http://tatiyants.com/postgres-query-plan-visualization/ The information density the rendering gives me is way better than the flamegraph.

daamien 7y ago
See PEV2 : https://github.com/dalibo/pev2 https://github.com/dalibo/pev2