MIchael Christofides views a plan:
When you’ve got a slow Postgres query, EXPLAIN and its parameters are incredibly useful for working out why.
However, the information returned can be difficult and time-consuming to interpret, especially for more complex queries. Over the years, people have built quite a few tools for visualizing Postgres query plans. As one of those people, I’m
a littleincredibly biased, but as a fan of many of the others, I hope to do them justice.
Read on for the options. I think the SQL Server world is a bit spoiled with Solarwinds Plan Explorer (even if the product hasn’t really changed since Solarwinds bought Sentry One), but some of these options look very solid.