From: | markw(at)osdl(dot)org |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Cc: | josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org, jenny(at)osdl(dot)org |
Subject: | Re: Proposed Query Planner TODO items |
Date: | 2004-02-09 17:48:39 |
Message-ID: | 200402091748.i19HmwE31410@mail.osdl.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 9 Feb, Tom Lane wrote:
> markw(at)osdl(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2004-02-09 18:42:08 | Re: Proposed Query Planner TODO items |
Previous Message | Tom Lane | 2004-02-09 17:33:00 | Re: Proposed Query Planner TODO items |