Thread: pgAdmin IV
This is in all versions of pgAdmin IV.
When generating an explain plan for a query, the data output only returns “[“. In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I have to keep my mouse on the picture to read it, very inconvenient.
Same query in pgAdmin III
Thanks,
Michelle Schwan
Database Architect
Phone: (519) 888 7111 ext 3241
Website: |
This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.
Attachment
This is in all versions of pgAdmin IV.
When generating an explain plan for a query, the data output only returns “[“. In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I have to keep my mouse on the picture to read it, very inconvenient.
Same query in pgAdmin III
Thanks,
Michelle Schwan
Database Architect
Phone: (519) 888 7111 ext 3241
Website:
This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.
Attachment
Aditya,
That is not very intuitive! Why can’t the information be displayed? All of the other database tools for other databases allow this.
Thanks,
Michelle
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Tuesday, June 04, 2019 10:50 AM
To: Michelle Schwan <mschwan@opentext.com>
Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: [EXTERNAL] - Re: pgAdmin IV
You need to double click on the "[" cell. It is a json data.
Thanks,
Aditya Toshniwal
On Tue, Jun 4, 2019, 20:10 Michelle Schwan <mschwan@opentext.com> wrote:
This is in all versions of pgAdmin IV.
When generating an explain plan for a query, the data output only returns “[“. In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I have to keep my mouse on the picture to read it, very inconvenient.
Same query in pgAdmin III
Thanks,
Michelle Schwan
Database Architect
Phone: (519) 888 7111 ext 3241
Website:
This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.
Aditya,
That is not very intuitive! Why can’t the information be displayed? All of the other database tools for other databases allow this.
Thanks,
Michelle
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Tuesday, June 04, 2019 10:50 AM
To: Michelle Schwan <mschwan@opentext.com>
Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: [EXTERNAL] - Re: pgAdmin IV
You need to double click on the "[" cell. It is a json data.
Thanks,
Aditya Toshniwal
On Tue, Jun 4, 2019, 20:10 Michelle Schwan <mschwan@opentext.com> wrote:
This is in all versions of pgAdmin IV.
When generating an explain plan for a query, the data output only returns “[“. In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I have to keep my mouse on the picture to read it, very inconvenient.
Same query in pgAdmin III
Thanks,
Michelle Schwan
Database Architect
Phone: (519) 888 7111 ext 3241
Website:
This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.
Hi Michelle,On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan <mschwan@opentext.com> wrote:Aditya,
That is not very intuitive! Why can’t the information be displayed? All of the other database tools for other databases allow this.
This can be done if we split the JSON data and show it in multiple rows. Kindly raise a feature request here- https://redmine.postgresql.org/projects/pgadmin4/issues/new
Thanks,
Michelle
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Tuesday, June 04, 2019 10:50 AM
To: Michelle Schwan <mschwan@opentext.com>
Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: [EXTERNAL] - Re: pgAdmin IV
You need to double click on the "[" cell. It is a json data.
Thanks,
Aditya Toshniwal
On Tue, Jun 4, 2019, 20:10 Michelle Schwan <mschwan@opentext.com> wrote:
This is in all versions of pgAdmin IV.
When generating an explain plan for a query, the data output only returns “[“. In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I have to keep my mouse on the picture to read it, very inconvenient.
Same query in pgAdmin III
Thanks,
Michelle Schwan
Database Architect
Phone: (519) 888 7111 ext 3241
Website:
This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.
--Thanks and Regards,Aditya ToshniwalSoftware Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"
Look after your data, and your database will look after you. -- Simon Riggs
Sheldon E. Strauch
Data Architect, Data Services
O 312-676-1556
M 224-723-3878
Enova International, Inc.
This transmission is confidential and may be privileged or proprietary. If you are not the intended recipient, you are not authorized to use the information in this transmission in any way. Please inform the sender immediately if you have received this transmission in error and permanently delete and destroy the original and any copies of the information.
We use JSON output when you use the EXPLAIN *button*, because we need to parse the output to render it in the graphical viewer. Whilst it's true pgAdmin 3 parsed the output from the non-JSON EXPLAIN, it was complex code that wasn't reliable or future-proof.
On Wed, Jun 5, 2019 at 12:27 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:Hi Michelle,On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan <mschwan@opentext.com> wrote:Aditya,
That is not very intuitive! Why can’t the information be displayed? All of the other database tools for other databases allow this.
This can be done if we split the JSON data and show it in multiple rows. Kindly raise a feature request here- https://redmine.postgresql.org/projects/pgadmin4/issues/new
Thanks,
Michelle
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Tuesday, June 04, 2019 10:50 AM
To: Michelle Schwan <mschwan@opentext.com>
Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: [EXTERNAL] - Re: pgAdmin IV
You need to double click on the "[" cell. It is a json data.
Thanks,
Aditya Toshniwal
On Tue, Jun 4, 2019, 20:10 Michelle Schwan <mschwan@opentext.com> wrote:
This is in all versions of pgAdmin IV.
When generating an explain plan for a query, the data output only returns “[“. In pgAdmin III, there was a detailed output.
It is easier to read the detailed data output than the explain pictures – I have to keep my mouse on the picture to read it, very inconvenient.
Same query in pgAdmin III
Thanks,
Michelle Schwan
Database Architect
Phone: (519) 888 7111 ext 3241
Website:
This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.
--Thanks and Regards,Aditya ToshniwalSoftware Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"--Look after your data, and your database will look after you. -- Simon Riggs
Sheldon E. Strauch
Data Architect, Data Services
O 312-676-1556
M 224-723-3878Enova International, Inc.
This transmission is confidential and may be privileged or proprietary. If you are not the intended recipient, you are not authorized to use the information in this transmission in any way. Please inform the sender immediately if you have received this transmission in error and permanently delete and destroy the original and any copies of the information.
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company