Re: graph representation of data structures in optimizer

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Adriano Lange <adriano(at)c3sl(dot)ufpr(dot)br>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: graph representation of data structures in optimizer
Date: 2009-02-18 17:21:30
Message-ID: 603c8f070902180921x2c64996dne234fc196ea098de@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Feb 18, 2009 at 10:22 AM, Adriano Lange <adriano(at)c3sl(dot)ufpr(dot)br> wrote:
> Hi,
>
> I'm interested in data representation and debug of optimizer routines. Thus,
> I've changed the debug functions of allpaths.c to make a graphviz-like
> output of RelOptInfo structure.
>
> Any idea about this?
> Is there some project or improvement like this?

That is pretty cool.

It would help a lot to label the baserels with their names.

You might also want to move the RestrictInfo out of line so that it's
easier to see where the inner and outer joinpath arrows are going.

It would be really sweet if there were some compact way to see the pathkeys.

...Robert

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2009-02-18 17:33:38 Re: The science of optimization in practical terms?
Previous Message Bruce Momjian 2009-02-18 17:15:41 Re: pg_migrator progress