Planner/optimizer tool

From: Tom Raney <twraney(at)comcast(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Planner/optimizer tool
Date: 2008-03-27 05:26:11
Message-ID: 47EB2FF3.4050406@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm scoping a project to display the choices and plans the
planner/optimizer considers while PostgreSQL develops a plan. It would
be primarily a teaching tool but may be of use to users curious about
the inner workings of the planner.

This is in contrast with EXPLAIN, which provides information about the
*final* plan selected by the planner. This tool would show details
about the access methods available at each step and the associated
access costs, for example.

There is a TODO item: "Allow EXPLAIN output to be more easily processed
by scripts, perhaps XML" which could be a good first step for this
project.

Is anyone working on a related project?

-Tom Raney

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2008-03-27 07:33:41 Re: [DOCS] pg_total_relation_size() and CHECKPOINT
Previous Message Tom Lane 2008-03-27 04:13:42 Re: [DOCS] pg_total_relation_size() and CHECKPOINT