Обсуждение: Graphical explain
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
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
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
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
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
-----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
-----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