Horton

Re: Need a mentor, and a project.

Gurjeet Singh <singh.gurjeet@gmail.com>

View thread View on postgr.es
From: Gurjeet Singh <singh.gurjeet@gmail.com>
To: decibel <decibel@decibel.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <bruce@momjian.us>, Ashish <abindra@u.washington.edu>, Josh Berkus <josh@agliodbs.com>, Joshua Tolley <eggyknap@gmail.com>, Albe Laurenz <laurenz.albe@wien.gv.at>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2009-12-16T08:14:41Z
Lists: pgsql-hackers 
2009/12/16 decibel <decibel@decibel.org>

> On Dec 11, 2009, at 8:44 PM, Tom Lane wrote:
> > Bruce Momjian <bruce@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[.singh]@EnterpriseDB.com

singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Twitter: singh_gurjeet
Skype: singh_gurjeet

Mail sent from my BlackLaptop device