pgsql: Small improvements to OPTIMIZER_DEBUG code.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Small improvements to OPTIMIZER_DEBUG code.
Date: 2016-04-30 18:08:06
Message-ID: E1awZJG-0005Vw-KU@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Small improvements to OPTIMIZER_DEBUG code.

Now that Paths have their own rows field, print that rather than
the parent relation's rowcount.

Show the relid sets associated with Paths using table names rather
than numbers; since this code is able to print simple Var references
using table names, it seems a bit silly that print_relids can't.

Print the cheapest_parameterized_paths list for a RelOptInfo, and
include information about a parameterized path's required_outer rels.

Noted while trying to use this feature to debug Alexander Kirkouski's
recent bug report.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/2a2435e6995133c9d872ef9cb51432f0b678b978

Modified Files
--------------
src/backend/optimizer/path/allpaths.c | 29 +++++++++++++++++++++++------
1 file changed, 23 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-04-30 19:06:31 pgsql: Update contrib/unaccent documentation about its unaccent.rules f
Previous Message Tom Lane 2016-04-30 16:29:26 pgsql: Fix planner crash from pfree'ing a partial path that a GatherPat