Thread: Graphical explain

Graphical explain

From
"A.j. Langereis"
Date:
Dear all,
 
Would it be possible to have to different symbols for index scans and sequence scans? Just like there is a different symbol for bitmap scans.. (although this is not a very clear one: a question mark). These clues are very important for performance boosting and having different symbols would benefit this really!
 
Futhermore I would like to ask if it is possible that the hints (the yellow messages with the details of each step) start with a mouse-over-event instead of an on-click-event. This saves a lot of clicking ;-)
 
Your sincerely,
 
Aarjan Langereis

Re: Graphical explain

From
Andreas Pflug
Date:
A.j. Langereis wrote:
> Dear all,
>  
> Would it be possible to have to different symbols for index scans and 
> sequence scans? Just like there is a different symbol for bitmap scans.. 

Generally speaking yes; would you provide images?

Currently, bitmap scans aren't recognized, and thus shown as unknown 
(question mark).

Ideally, we'd need these images:

- Seq Scan
- Index Scan
- Bitmap Index Scan
- Bitmap Heap Scan
- Tid Scan

Regards,
Andreas


Re: Graphical explain

From
Dave Page
Date:
Hi Niko,


On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:

> A.j. Langereis wrote:
>> Dear all,
>>  
>> Would it be possible to have to different symbols for index scans and
>> sequence scans? Just like there is a different symbol for bitmap scans..
> 
> Generally speaking yes; would you provide images?
> 
> Currently, bitmap scans aren't recognized, and thus shown as unknown
> (question mark).
> 
> Ideally, we'd need these images:
> 
> - Seq Scan
> - Index Scan
> - Bitmap Index Scan
> - Bitmap Heap Scan
> - Tid Scan

Would you be able to find some time to design some icons for this please?

Also, if you can find another few minutes; Andreas replaced the delete icon
on the main toolbar with one of his own because there was some confusion
over the X symbol you had used. If you can redo that one with a waste paper
bin or similar that would be great - Andreas' one just looks subtly
different to the rest of yours and stands out as a result :-(

Regards, Dave 




Re: Graphical explain

From
Andreas Pflug
Date:
Dave Page wrote:

>Hi Niko,
>
>
>On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:
>
>  
>
>>A.j. Langereis wrote:
>>    
>>
>>>Dear all,
>>> 
>>>Would it be possible to have to different symbols for index scans and
>>>sequence scans? Just like there is a different symbol for bitmap scans..
>>>      
>>>
>>Generally speaking yes; would you provide images?
>>
>>Currently, bitmap scans aren't recognized, and thus shown as unknown
>>(question mark).
>>
>>Ideally, we'd need these images:
>>
>>- Seq Scan
>>- Index Scan
>>- Bitmap Index Scan
>>- Bitmap Heap Scan
>>- Tid Scan
>>    
>>
>
>Would you be able to find some time to design some icons for this please?
>
>Also, if you can find another few minutes; Andreas replaced the delete icon
>on the main toolbar with one of his own because there was some confusion
>over the X symbol you had used. If you can redo that one with a waste paper
>bin or similar that would be great - Andreas' one just looks subtly
>different to the rest of yours and stands out as a result :-(
>  
>

Ah ok so my images are not good enough for you.... sniff....

Regards,
Andreas



Re: Graphical explain

From
"Ennixo"
Date:
I'll find the time to do this, no problem.

Regards,
Niko.

-----Message d'origine-----
De : Dave Page [mailto:dpage@vale-housing.co.uk]
Envoyé : dimanche 27 novembre 2005 21:01
À : Ennixo
Cc : pgadmin-support@postgresql.org; A.j. Langereis; Andreas Pflug
Objet : Re: [pgadmin-support] Graphical explain

Hi Niko,


On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:

> A.j. Langereis wrote:
>> Dear all,
>>
>> Would it be possible to have to different symbols for index scans and
>> sequence scans? Just like there is a different symbol for bitmap scans..
>
> Generally speaking yes; would you provide images?
>
> Currently, bitmap scans aren't recognized, and thus shown as unknown
> (question mark).
>
> Ideally, we'd need these images:
>
> - Seq Scan
> - Index Scan
> - Bitmap Index Scan
> - Bitmap Heap Scan
> - Tid Scan

Would you be able to find some time to design some icons for this please?

Also, if you can find another few minutes; Andreas replaced the delete icon
on the main toolbar with one of his own because there was some confusion
over the X symbol you had used. If you can redo that one with a waste paper
bin or similar that would be great - Andreas' one just looks subtly
different to the rest of yours and stands out as a result :-(

Regards, Dave






Re: Graphical explain

From
"Dave Page"
Date:

-----Original Message-----
From: "Andreas Pflug"<pgadmin@pse-consulting.de>
Sent: 27/11/05 21:50:42
To: "Dave Page"<dpage@vale-housing.co.uk>
Cc: "Ennixo"<ennixo@free.fr>, "pgadmin-support@postgresql.org"<pgadmin-support@postgresql.org>, "A.j.
Langereis"<a.j.langereis@inter.nl.net>
Subject: Re: [pgadmin-support] Graphical explain

> Ah ok so my images are not good enough for you.... sniff....

Aww, don't cry. They're nice n' all, just not quite as shiny...

/D

-----Unmodified Original Message-----
Dave Page wrote:

>Hi Niko,
>
>
>On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:
>
>
>
>>A.j. Langereis wrote:
>>
>>
>>>Dear all,
>>>
>>>Would it be possible to have to different symbols for index scans and
>>>sequence scans? Just like there is a different symbol for bitmap scans..
>>>
>>>
>>Generally speaking yes; would you provide images?
>>
>>Currently, bitmap scans aren't recognized, and thus shown as unknown
>>(question mark).
>>
>>Ideally, we'd need these images:
>>
>>- Seq Scan
>>- Index Scan
>>- Bitmap Index Scan
>>- Bitmap Heap Scan
>>- Tid Scan
>>
>>
>
>Would you be able to find some time to design some icons for this please?
>
>Also, if you can find another few minutes; Andreas replaced the delete icon
>on the main toolbar with one of his own because there was some confusion
>over the X symbol you had used. If you can redo that one with a waste paper
>bin or similar that would be great - Andreas' one just looks subtly
>different to the rest of yours and stands out as a result :-(
>
>

Ah ok so my images are not good enough for you.... sniff....

Regards,
Andreas



Re: Graphical explain

From
"Dave Page"
Date:

-----Original Message-----
From: "Ennixo"<ennixo@free.fr>
Sent: 27/11/05 22:30:07
To: "'Dave Page'"<dpage@vale-housing.co.uk>
Cc: "pgadmin-support@postgresql.org"<pgadmin-support@postgresql.org>, "'A.j. Langereis'"<a.j.langereis@inter.nl.net>,
"'AndreasPflug'"<pgadmin@pse-consulting.de> 
Subject: RE: [pgadmin-support] Graphical explain

> I'll find the time to do this, no problem.

Thanks. Definitely need to buy you a beer sometime...

/D

-----Unmodified Original Message-----
I'll find the time to do this, no problem.

Regards,
Niko.

-----Message d'origine-----
De : Dave Page [mailto:dpage@vale-housing.co.uk]
Envoyé : dimanche 27 novembre 2005 21:01
À : Ennixo
Cc : pgadmin-support@postgresql.org; A.j. Langereis; Andreas Pflug
Objet : Re: [pgadmin-support] Graphical explain

Hi Niko,


On 27/11/05 7:06 pm, "Andreas Pflug" <pgadmin@pse-consulting.de> wrote:

> A.j. Langereis wrote:
>> Dear all,
>>
>> Would it be possible to have to different symbols for index scans and
>> sequence scans? Just like there is a different symbol for bitmap scans..
>
> Generally speaking yes; would you provide images?
>
> Currently, bitmap scans aren't recognized, and thus shown as unknown
> (question mark).
>
> Ideally, we'd need these images:
>
> - Seq Scan
> - Index Scan
> - Bitmap Index Scan
> - Bitmap Heap Scan
> - Tid Scan

Would you be able to find some time to design some icons for this please?

Also, if you can find another few minutes; Andreas replaced the delete icon
on the main toolbar with one of his own because there was some confusion
over the X symbol you had used. If you can redo that one with a waste paper
bin or similar that would be great - Andreas' one just looks subtly
different to the rest of yours and stands out as a result :-(

Regards, Dave