Re: [EXTERNAL] - Re: pgAdmin IV

2019-06-05 Thread Dave Page 
I've rejected that I'm afraid, with the note:

=
Bug 2880 refers to what happens if you execute "EXPLAIN SELECT..." as the
query, and that still works fine.

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.
=

In short, if you want to see multi-line, indented text plans, prepend
"EXPLAIN " to the query and run it. If you use the EXPLAIN button, the
returned data is in JSON format and is intended for graphical rendering.

On Wed, Jun 5, 2019 at 3:32 PM Strauch, Sheldon  wrote:

> Issue #4327  created.
>
> On Wed, Jun 5, 2019 at 12:27 AM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Michelle,
>>
>> On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan 
>> 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 
>>> *Sent:* Tuesday, June 04, 2019 10:50 AM
>>> *To:* Michelle Schwan 
>>> *Cc:* 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  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
>>>
>>> msch...@opentext.com
>>>
>>> Phone: (519) 888 7111 ext 3241
>>>
>>> Website:
>>>
>>> www.opentext.com
>>> 
>>>
>>>
>>>
>>> [image:
>>> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
>>> 
>>>
>>> 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 Toshniwal
>> Software 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.*
>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [EXTERNAL] - Re: pgAdmin IV

2019-06-05 Thread Strauch, Sheldon 
Issue #4327  created.

On Wed, Jun 5, 2019 at 12:27 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Michelle,
>
> On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan 
> 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 
>> *Sent:* Tuesday, June 04, 2019 10:50 AM
>> *To:* Michelle Schwan 
>> *Cc:* 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  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
>>
>> msch...@opentext.com
>>
>> Phone: (519) 888 7111 ext 3241
>>
>> Website:
>>
>> www.opentext.com
>> 
>>
>>
>>
>> [image:
>> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
>> 
>>
>> 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 Toshniwal
> Software 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.*

Re: [EXTERNAL] - Re: pgAdmin IV

2019-06-04 Thread Aditya Toshniwal 
Hi Michelle,

On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan 
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 
> *Sent:* Tuesday, June 04, 2019 10:50 AM
> *To:* Michelle Schwan 
> *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  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
>
> msch...@opentext.com
>
> Phone: (519) 888 7111 ext 3241
>
> Website:
>
> www.opentext.com
>
>
>
> [image:
> http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]
> 
>
> 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 Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

RE: [EXTERNAL] - Re: pgAdmin IV

2019-06-04 Thread Michelle Schwan 
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 
Sent: Tuesday, June 04, 2019 10:50 AM
To: Michelle Schwan 
Cc: 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 
mailto:msch...@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.
[cid:image003.png@01D51AC1.4F95B800]

Same query in pgAdmin III
[cid:image002.png@01D51AC1.D939C5B0]

Thanks,
Michelle Schwan
Database Architect
msch...@opentext.com
Phone: (519) 888 7111 ext 3241
Website:
www.opentext.com

[http://mimage.opentext.com/alt_content/binary/images/emailsupport-logo-opentext.gif]

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.