Thread: Re: pgadmin 4 on windows - no Graphical explain?
On Thu, Aug 24, 2017 at 11:40 AM, alain bourgeois <a.bourgeois@zetescards.be> wrote:
Hi,
using pgadmin 4 (1.6) query tool on windows, type "select * from eidtemp2 order by softref, cardid"
Explain options: enable all but verbose.
then click explain (or explain analyze)
I get a question mark with some stats and in output I get a JSON to parse.
according to http://www.postgresonline.com/journal/archives/27-Reading- PgAdmin-Graphical-Explain- Plans.html, pgadmin3 gave a readable text + graphic.
No more possible using pgadmin 4?
Works fine for me (see attached). Any errors in the log file in %APPDATA%\pgadmin?
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment
I don't get the same:
Any plugin to install?
Regards,
Alain Bourgeois
Software Engineer
Tel: +32 (0)2 333 49 20
Mobile: +32 (0)496 51 85 75
skype: abozetes
ZETES PASS, division of ZETES SA/NV
Disclaimer : This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you receive this message in error, please contact the sender and delete the material from any computer.
From: Dave Page <dpage@pgadmin.org>
To: alain bourgeois <a.bourgeois@zetescards.be>
Cc: pgadmin-support@lists.postgresql.org
Date: 24-08-17 14:13
Subject: Re: pgadmin 4 on windows - no Graphical explain?
On Thu, Aug 24, 2017 at 11:40 AM, alain bourgeois <a.bourgeois@zetescards.be> wrote:
Hi,
using pgadmin 4 (1.6) query tool on windows, type "select * from eidtemp2 order by softref, cardid"
Explain options: enable all but verbose.
then click explain (or explain analyze)
I get a question mark with some stats and in output I get a JSON to parse.
according to http://www.postgresonline.com/journal/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html, pgadmin3 gave a readable text + graphic.
No more possible using pgadmin 4?
Works fine for me (see attached). Any errors in the log file in %APPDATA%\pgadmin?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company[attachment "Screen Shot 2017-08-24 at 13.11.13.png" deleted by alain bourgeois/CEC]
Any plugin to install?
Regards,
Alain Bourgeois
Software Engineer
Tel: +32 (0)2 333 49 20
Mobile: +32 (0)496 51 85 75
skype: abozetes
ZETES PASS, division of ZETES SA/NV
Disclaimer : This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you receive this message in error, please contact the sender and delete the material from any computer.
From: Dave Page <dpage@pgadmin.org>
To: alain bourgeois <a.bourgeois@zetescards.be>
Cc: pgadmin-support@lists.postgresql.org
Date: 24-08-17 14:13
Subject: Re: pgadmin 4 on windows - no Graphical explain?
On Thu, Aug 24, 2017 at 11:40 AM, alain bourgeois <a.bourgeois@zetescards.be> wrote:
Hi,
using pgadmin 4 (1.6) query tool on windows, type "select * from eidtemp2 order by softref, cardid"
Explain options: enable all but verbose.
then click explain (or explain analyze)
I get a question mark with some stats and in output I get a JSON to parse.
according to http://www.postgresonline.com/journal/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html, pgadmin3 gave a readable text + graphic.
No more possible using pgadmin 4?
Works fine for me (see attached). Any errors in the log file in %APPDATA%\pgadmin?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company[attachment "Screen Shot 2017-08-24 at 13.11.13.png" deleted by alain bourgeois/CEC]