SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 07:15 PM
| ||||
| ||||
 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      |
|
04-17-2008, 07:15 PM
| |||
| |||
| Re: Graphical explain 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
|
04-17-2008, 07:15 PM
| |||
| |||
| Re: 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
|
04-17-2008, 07:15 PM
| |||
| |||
| Re: Graphical explain 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
|
04-17-2008, 07:16 PM
| ||||
| ||||
| Re: Graphical explain 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
