Re:PostgreSQL's Explain Analyze Made Readable
by kennydude on Thursday February 21, 2019 @09:22AM
(#19217021)
pgAdmin has a really good EXPLAIN visualisation tool built-in which makes it into a neat little diagram
[ Parent
| on HN ]
Re:PostgreSQL's Explain Analyze Made Readable
by dijit on Thursday February 21, 2019 @09:24AM
(#19217040)
pgAdmin by itself is a _really_ horrible program to use otherwise though.
I do wish that it was as polished as the database core itself seems to be.
Re:PostgreSQL's Explain Analyze Made Readable
by kennydude on Thursday February 21, 2019 @09:34AM
(#19217095)
pgAdmin 3 feels much more polished than version 4 :/
Re:PostgreSQL's Explain Analyze Made Readable
by sbuttgereit on Thursday February 21, 2019 @10:55AM
(#19217666)
Yep... the one very good thing that I got out of pgAdmin was that it finally convinced me to get psql under my fingers so I wouldn't have to use pgAdmin.
Re:PostgreSQL's Explain Analyze Made Readable
by ganomi on Thursday February 21, 2019 @11:02AM
(#19217715)
If you still would like a little bit of GUI take a look at https://dbeaver.io/
Re:PostgreSQL's Explain Analyze Made Readable
by cpburns2009 on Thursday February 21, 2019 @12:45PM
(#19218807)
The three things that I still miss from pgAdmin 3 while using DBeaver are:
1. The server status window (when it used to work).
2. The visual explain query view.
3. The statistics tab. Though, DBeaver now has a simplified one for tables.