PostgreSQL's Explain Analyze Made Readable

This is one of my go-to sites for optimizing Postgres queries. While all the information is available in the text output there's something nice about the site highlighting the rows scanned for the bad parts of the queries in a dark red ;)

My only nits - it's kind of annoying to have to click a checkbox to make sure my analysis is not public and to keep the window open so I can delete it after I'm done.

Re: PostgreSQL's Explain Analyze Made Readable

#8

Post by _asummers » Thu, Feb 21, 2019, 1:06 PM UTC

In the "possibly unknown Postgres tools" category, I'm also a huge fan of PG Hero [0]. Gives you a nice sortable UI to look at running queries, see what the longest ones are, the most frequently called, etc. This is all just reading from pg_stats and such but the UI is very nice.

[0] https://github.com/ankane/pghero

Re: PostgreSQL's Explain Analyze Made Readable

#9

Post by ryanmcm » Thu, Feb 21, 2019, 1:07 PM UTC

I've enjoyed using pev[1]. It's based on this tool but lays out the plan graphically.

[1] http://tatiyants.com/pev/#/plans/plan_1550754076978

Re: PostgreSQL's Explain Analyze Made Readable

#10

Post by arkh » Thu, Feb 21, 2019, 1:20 PM UTC

Inspired from it you also have pev if you prefer something more visual : http://tatiyants.com/postgres-query-plan-visualization/