3 ms·
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 st
by 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 agoMighty god odin bless you for that link. Thank u so much
- takeda 7y agothat 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.