2009/12/16 decibel <deci...@decibel.org> > On Dec 11, 2009, at 8:44 PM, Tom Lane wrote: > > Bruce Momjian <br...@momjian.us> writes: > >> Ashish wrote: > >>> I am thinking about starting with the following TODO item: > >>> --> Have EXPLAIN ANALYZE issue NOTICE messages when the estimated > >>> and actual row counts differ by a specified percentage. > > > >> I even have a sample patch you can use as a start, attached. > > > > IMO the hard part of the TODO item is to design a useful user interface > > for highlighting specific EXPLAIN entries (and NOTICE messages probably > > ain't it either). Getting the numbers is trivial. > > What about prefixing explain output with line numbers? NOTICEs (or whatever > mechanism) could then reference the line numbers. > > +1
-- Lets call it Postgres EnterpriseDB http://www.enterprisedb.com gurjeet[.sin...@enterprisedb.com singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com Twitter: singh_gurjeet Skype: singh_gurjeet Mail sent from my BlackLaptop device
