3 ms·

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 lon

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 https://github.com/ankane/pghero

GordonS 8y ago
Hah, I just discovered this one independently after submitting this URL!
aboutruby 8y ago
On Heroku there is pg-extras: https://github.com/heroku/heroku-pg-extras https://github.com/heroku/heroku-pg-extras