Re: [GENERAL] Graphical representation of query plans

2009-09-23 Thread Emi Lu
pgadmin does it pretty nicely: http://pgadmin.org/images/screenshots/pgadmin3_macosx.png As shown in the mackintosh version, it is a very nice and helpful feature! I have pgadmin 1.2.0 for PostgreSQL 8.0.15 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2. I did not see this "explain" in

Re: [GENERAL] Graphical representation of query plans

2009-09-22 Thread Guillaume Lelarge
Le mardi 22 septembre 2009 à 22:48:57, Emi Lu a écrit : > Grzegorz Jaśkiewicz wrote: > > pgadmin does it pretty nicely: > > http://pgadmin.org/images/screenshots/pgadmin3_macosx.png > > As shown in the mackintosh version, it is a very nice and helpful feature! > > > I have pgadmin 1.2.0 for Post

Re: [GENERAL] Graphical representation of query plans

2009-09-22 Thread Raymond O'Donnell
On 22/09/2009 21:48, Emi Lu wrote: > Grzegorz Jaśkiewicz wrote: >> pgadmin does it pretty nicely: >> http://pgadmin.org/images/screenshots/pgadmin3_macosx.png > > > As shown in the mackintosh version, it is a very nice and helpful feature! > > > I have pgadmin 1.2.0 for PostgreSQL 8.0.15 on i68

Re: [GENERAL] Graphical representation of query plans

2009-09-22 Thread Emi Lu
Grzegorz Jaśkiewicz wrote: pgadmin does it pretty nicely: http://pgadmin.org/images/screenshots/pgadmin3_macosx.png As shown in the mackintosh version, it is a very nice and helpful feature! I have pgadmin 1.2.0 for PostgreSQL 8.0.15 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2.

Re: [GENERAL] Graphical representation of query plans

2009-06-23 Thread Viktor Rosenfeld
Much better than explain-analyze.info Many thanks! Am 23.06.2009 um 11:25 schrieb Dragan Sahpaski: Viktor Rosenfeld wrote: Thank you, this does indeed look very nice. I would still be interested in alternatives, though. Specifically, I want to be able to quickly see the cost of query subp

Re: [GENERAL] Graphical representation of query plans

2009-06-23 Thread Dragan Sahpaski
Viktor Rosenfeld wrote: Thank you, this does indeed look very nice. I would still be interested in alternatives, though. Specifically, I want to be able to quickly see the cost of query subplans á la http://explain-analyze.info. A tool that outputs a dot file or something which I can furthe

Re: [GENERAL] Graphical representation of query plans

2009-06-23 Thread Viktor Rosenfeld
Thank you, this does indeed look very nice. I would still be interested in alternatives, though. Specifically, I want to be able to quickly see the cost of query subplans á la http://explain-analyze.inf o. A tool that outputs a dot file or something which I can further edit would also work

Re: [GENERAL] Graphical representation of query plans

2009-06-22 Thread Grzegorz Jaśkiewicz
pgadmin does it pretty nicely: http://pgadmin.org/images/screenshots/pgadmin3_macosx.png -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Graphical representation of query plans

2009-06-22 Thread Viktor Rosenfeld
Hi everybody, is there a (stand-alone, command line) tool that converts the output of EXPLAIN ANALYZE into a tree-like representation of the plan? Cheers, Viktor -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.