Re: Proposed Query Planner TODO items - Mailing list pgsql-hackers

From markw@osdl.org
Subject Re: Proposed Query Planner TODO items
Date
Msg-id 200402091748.i19HmwE31410@mail.osdl.org
Whole thread Raw
In response to Proposed Query Planner TODO items  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Proposed Query Planner TODO items  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On  9 Feb, Tom Lane wrote:
> markw@osdl.org writes:
>> I'll see what I can do about the "explain" and "explain analyze"
>> results.  I remember in the past that someone said it would be most
>> interesting to execute the latter while the test while running, as
>> opposed to before or after a test.  Should I do that here too?
> 
> If possible, but I'd settle for a standalone result, so long as it's
> executed against the correct database contents (including pg_statistic
> settings).

Ok, I've found that the kit does capture "explain" results and I've
added a "Query Plans" links under the query time charts on each of the
pages.  Um, but I did notice a couple of problems.  It looks liks one of
the 22 queries is missing and they're not labeled.  I'll see about
getting that fixed.

Mark


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-hackers-win32] Sync vs. fsync during checkpoint
Next
From: Tom Lane
Date:
Subject: Re: Proposed Query Planner TODO items