“Fashion Is Hard. PostgreSQL Is Easy” [video]

Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by knodi123 on Thursday June 18, 2015 @10:36AM (#9738733)

I've recently made the switch to postgres, and then I found pgadmin3, and I'm really feeling some pain.

For instance, the "explain query" visualization is great, and very helpful, but there's no way I can find to zoom out, at all. And that window doesn't support mouse scrolling. And there's no way to export the visualization somewhere else. So when I'm trying to figure out why a very, very large query is running slowly, it's agony to use pgadmin3.

Do you know any good postgres query analysis tools?

[ Parent | on HN ]

Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by bmdavi3 on Thursday June 18, 2015 @11:27AM (#9739158)

It's not graphical, but pasting the explain analyze output into http://explain.depesz.com/ helps me see where postgres is spending most of its time.

[ Parent | on HN ]

Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by knodi123 on Thursday June 18, 2015 @06:06PM (#9741910)

That's a bit of a help, thanks!

[ Parent | on HN ]