Re: PATCH: Graphincal explain integrated in sql editor

From: Sanket Mehta <sanket(dot)mehta(at)enterprisedb(dot)com>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: Graphincal explain integrated in sql editor
Date: 2016-05-09 15:19:53
Message-ID: CA+yw=mN2yFzh68D7FoZDKbxKdkaXjuKP+swyt3kA2QbiLK_c6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi,

PFA revised patch according to Ashesh's comments.
Please find my response inline.

I am currently adding minimap feature in graphical explain.
I will send a new patch for the same.

Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Apr 25, 2016 at 4:36 PM, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com
> wrote:

> Hi Sanket,
>
> Please find the review comments.
> - Please add the missing 'explain.css'.
>
Done

> - The application should be smart enough to handle conflict in options.
> i.e.
> Buffer is not a valid options without EXPLAIN ANALYZE.
>
Done

> - A statement having EXPLAIN keywords with different format should at
> least render the output in the data-grid.
> i.e. EXPLAIN (FORMAT xml) SELECT * FROM xyz;
>
Done

> - Please use the keywords used in the EXPLAIN statement in capital.
>
Done

> - Explain should not work with empty string.
>
Done

> - Font size in the tooltip is very small.
>
Done

>
>
- Smoothing the zoom functionality.
>
Minimap will be added and zoom functionality will be removed. So it is
ignored.

- Arrow marker is hardly visible.
>
Done.

>
>
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
> <http://www.enterprisedb.com>
>
>
> *http://www.linkedin.com/in/asheshvashi*
> <http://www.linkedin.com/in/asheshvashi>
>
> On Mon, Apr 25, 2016 at 3:06 PM, Sanket Mehta <
> sanket(dot)mehta(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> This patch includes the patch sent earlier for stand alone graphical
>> explain.
>>
>> And also "horizontal lines are not proper" bug is fixed in the same which
>> was reported by Dave in previous patch.
>>
>> Regards,
>> Sanket Mehta
>> Sr Software engineer
>> Enterprisedb
>>
>> On Thu, Apr 21, 2016 at 8:38 PM, Sanket Mehta <
>> sanket(dot)mehta(at)enterprisedb(dot)com> wrote:
>>
>>> Hi Team,
>>>
>>> PFA the first patch for graphical explain integrated in sql editor.
>>>
>>> Below are the few things which are different from previous patch which
>>> was sent for stand alone graphical explain.
>>>
>>> - Now user can select Explain/Explain Analyze with four optional
>>> properties (Verbose, costs, timing and buffers)
>>>
>>> - Initially graph will be scale (according to only its width not
>>> height) to fit to screen so no blank space will be there in case of very
>>> large graph.
>>>
>>> - Along with zoom in/out button, "zoom to original" button is also
>>> provided, by clicking on which graph will be scale to its original size
>>> (not same as initial one which is according to screen size).
>>>
>>> Please do review this patch and let me know in case you have any
>>> comments.
>>>
>>>
>>> Regards,
>>> Sanket Mehta
>>> Sr Software engineer
>>> Enterprisedb
>>>
>>
>>
>

Attachment Content-Type Size
integrated_graphical_explainV4.patch text/x-patch 484.3 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Sanket Mehta 2016-05-09 18:26:37 Re: PATCH: Graphincal explain integrated in sql editor
Previous Message Sanket Mehta 2016-05-09 13:31:14 PATCH: minor typo in fts dictionary node