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

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

If you haven't already checkout pgadmin-3, I mostly live in the cli but if I need to do something complex or write a large query I often jump into pgadmin as it's display and proper editor are excellent!.

Prefer it to MySQL Workbench even which I liked.

[ Parent | on HN ]

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 ]