Michael Loftis <[EMAIL PROTECTED]> writes: > IE I'd like to have the information come back as say a notice or maybe > as extra information for an EXPLAIN for my purposes, but unless there is > interest, consensus on how it should be done, and a TODO item made of > it, I won't be making a patch of that, no reason to clutter the backend > with stuff that hopefully won't be needed for long :)
I think it'd be useful to have, actually, as long as we're not talking about much code bloat. I tend to try to find a way to see what I want with EXPLAIN, because using OPTIMIZER_DEBUG is such a pain. But it's often difficult to force the plan I'm interested in to rise to the top. A nicer user interface for looking at the rejected alternatives would seem like a step forward to me, whether or not ordinary users have any need for it... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html