Inspired from it you also have pev if you prefer something more visual : http://tatiyants.com/postgres-query-plan-visualization/
[deleted]
PostgreSQL's Explain Analyze Made Readable
31–40 of 62 posts
Re: PostgreSQL's Explain Analyze Made Readable
#32If this tool is useful to you, it's highly recommend reading the author's blog as well. It's a great resource for learning about postgres.
Re: PostgreSQL's Explain Analyze Made Readable
#33If this tool is useful to you, it's highly recommend reading the author's blog as well. It's a great resource for learning about postgres.
Indeed, a great resouce! I really liked how he explained and benchmarked an implementation for foreign keys to partitioned data (sadly not available natively yet) in this multi-part series from last year: https://www.depesz.com/2018/10/02/foreign-key-to-partitioned...
Re: PostgreSQL's Explain Analyze Made Readable
#34There's not much I miss from the days of SQL Server 2000 but a robust, fast official client is one.
In my opinion isqlw is the gold standard, and it had something like this built right in.
Re: PostgreSQL's Explain Analyze Made Readable
#35Earlier quoted context omitted.
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.
If you still would like a little bit of GUI take a look at https://dbeaver.io/
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.
Re: PostgreSQL's Explain Analyze Made Readable
#36My favorite tool for this kind of analysis was pgAdmin3, which had a very nice diagramming output for EXPLAIN ANALYZE which you can see here [0]. Hovering over the various images in the diagram would display their time, rows, and which statement caused them. There is also this excellent post which shows how to break down an EXPLAIN and reason about the performance [1]. [0] http://www.postgresonline.com/images/journal…
pgAdmin4 has the same diagramming system. Unfortunately it wasn't up to par for quite a while and is only slowly getting better.
Re: PostgreSQL's Explain Analyze Made Readable
#37My favorite tool for this kind of analysis was pgAdmin3, which had a very nice diagramming output for EXPLAIN ANALYZE which you can see here [0]. Hovering over the various images in the diagram would display their time, rows, and which statement caused them. There is also this excellent post which shows how to break down an EXPLAIN and reason about the performance [1]. [0] http://www.postgresonline.com/images/journal…
pgAdmin4 has the same diagramming system. Unfortunately it wasn't up to par for quite a while and is only slowly getting better.
Good to know it is improving, as I was disappointed with pgAdmin4 for some time.
Re: PostgreSQL's Explain Analyze Made Readable
#38Anybody know of a tool that will do something like this for AWS Redshift? Redshift is based on an old version of PostgreSQL.
Re: PostgreSQL's Explain Analyze Made Readable
#39My favorite tool for this kind of analysis was pgAdmin3, which had a very nice diagramming output for EXPLAIN ANALYZE which you can see here [0]. Hovering over the various images in the diagram would display their time, rows, and which statement caused them. There is also this excellent post which shows how to break down an EXPLAIN and reason about the performance [1]. [0] http://www.postgresonline.com/images/journal…
Agreed. Also I like that it's so quick (at least for a regular EXPLAIN) - I would very often hit F7 to see the query plan visualization, even for just a split second, before pressing F5 to run the query. If I see the table-scan icon appear somewhere when I'm not expecting it to, it's a big hint I've done something dumb.
Re: PostgreSQL's Explain Analyze Made Readable
#40Off topic, sorry, but it makes me happy to see a Perl-based tool in the top 5 on Hackernews :-)