Re:PostgreSQL's Explain Analyze Made Readable
by _asummers on Thursday February 21, 2019 @08:06AM
(#19216561)
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