Re: Add ALL_CANDIDATES option to EXPLAIN - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add ALL_CANDIDATES option to EXPLAIN
Date
Msg-id 1747080.1722015612@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add ALL_CANDIDATES option to EXPLAIN  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Add ALL_CANDIDATES option to EXPLAIN
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I've thought about trying to figure out some way of identifying and
> printing out plans that are "interestingly different" from the chosen
> plan, with the costs they would have had, but I haven't been able to
> come up with a good algorithm.

I wonder how far you'd get by just printing the surviving paths
(that is, something like Anthonin's patch, but without lobotomizing
add_path).  The survivors would have to dominate the cheapest-total
path along one of the other metrics add_path considers, which
seems like a rough approximation of "interestingly different".

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andreas Karlsson
Date:
Subject: Re: tiny step toward threading: reduce dependence on setlocale()
Next
From: Masahiko Sawada
Date:
Subject: Re: xid_wraparound tests intermittent failure.