Stefan Keller <sfkeller@xxxxxxxxx> writes: > I'd like to know from the query planner which query plan alternatives > have been generated and rejected. Is this possible? No, not really. People have occasionally hacked the planner to print rejected paths before they're discarded, but there's no convenient way to do anything except send the data to the postmaster log, which isn't all that convenient. A bigger problem is that people who are asking for this typically imagine that the planner generates complete plans before rejecting them; which it does not. Path alternatives are rejected whenever possible before moving up to the next join level, so that what we have rejected is actually just a plan fragment in most cases. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
