pg_flame
Dev tools
query plan visualizer
SHOW HN2019
321points
42comments
#90of 2,195 in 2019
Top 5%of 2019 by points
How HN took it
MixedNo clear lean
4 positive, 4 neutral or asking, 2 mixed, 3 critical, out of 13 comments about the project. Thread score +0.17.
Design: 1 for, 3 againstDocs: 1 for, 0 againstIdea: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful tool for PostgreSQL query optimization
From 3 comments
I love this tool! But generally speaking, the user experience of the PostgreSQL admin workflow could be improved so much. The psql client binary should include visualizations…
bflesch on HNWow, i'm struggling with a sql query in psql just right now, this seems to be just what i was looking for! Thank you so much!
nerder92 on HNAwesome job. This is really useful.
ranadeep on HN
Pointer to alternative visualizers and tools
From 3 comments
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…
bflesch on HNThis is the best tool I know, works pasting only the JSON output: http://tatiyants.com/postgres-query-plan-visualization/ The information density the rendering gives me is way…
aeyes on HNSee PEV2 : https://github.com/dalibo/pev2
daamien on HN
Objections
Workflow requires exporting JSON and moving it to another machine, too much friction
From 3 comments
I love this tool! But generally speaking, the user experience of the PostgreSQL admin workflow could be improved so much. The psql client binary should include visualizations…
bflesch on HNCould the workflow done so that you just copy-paste output from a PSQL shell to an online tool?
miohtama on HNYes, 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…
bflesch on HN
Tool may not handle complex queries with CTEs and loops correctly
From 1 comment
A tool like would be a wonderful addition to the PostgreSQL ecosystem! That being said, this tool won't work well for anything but trivial queries. PostgreSQL query plans have…
felixge on HN
Requests
Simplify workflow, e.g. paste psql output directly or integrate into psql
From 2 comments
I love this tool! But generally speaking, the user experience of the PostgreSQL admin workflow could be improved so much. The psql client binary should include visualizations…
bflesch on HNCould the workflow done so that you just copy-paste output from a PSQL shell to an online tool?
miohtama on HN
Offer a web version or browser-based option
From 3 comments
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…
ken on HN> 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…
Xylakant on HNA 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…
londons_explore on HN
Questions
Does it handle CTE InitPlan steps correctly
From 2 comments
A tool like would be a wonderful addition to the PostgreSQL ecosystem! That being said, this tool won't work well for anything but trivial queries. PostgreSQL query plans have…
felixge on HNYa, I ran into problems with CTE InitPlan steps. However, I did do some extra work to have them display in the most correct way I could think of. I’ll add a CTE demo with and…
mgartner on HN
Alternatives named
depesz explain analyzer
From 2 comments
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…
bflesch on HNA tool like would be a wonderful addition to the PostgreSQL ecosystem! That being said, this tool won't work well for anything but trivial queries. PostgreSQL query plans have…
felixge on HN
Taniyants postgres query plan visualization
From 1 comment
This is the best tool I know, works pasting only the JSON output: http://tatiyants.com/postgres-query-plan-visualization/ The information density the rendering gives me is way…
aeyes on HN
PEV2
From 1 comment
See PEV2 : https://github.com/dalibo/pev2
daamien on HN
MySQL SHOW PROFILE
From 1 comment
MySQL (regular and NDB Cluster versions) has "show profile" built-in. It's not graphical, but has similar details. Love it!…
redis_mlc on HN