News for hackers. Stuff that matters.

A comment on Show HN: pg_flame – flamegraph visualizations of PostgreSQL query plans. Parent comment

Re:Show HN: pg_flame – flamegraph visualizations of PostgreS... by bflesch on Sunday October 27, 2019 @04:38PM (#21372226)
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/

[ Parent | on HN ]
Re:Show HN: pg_flame – flamegraph visualizations of PostgreS... by rc_mob on Sunday October 27, 2019 @08:47PM (#21373470)
Mighty god odin bless you for that link. Thank u so much
[ Parent | on HN ]
Re:Show HN: pg_flame – flamegraph visualizations of PostgreS... by takeda on Sunday October 27, 2019 @11:28PM (#21374019)
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/ his explain tool + that information is really good starting point when trying to optimize queries.

[ Parent | on HN ]