At 00:49 21/07/01 +1000, Martijn van Oosterhout wrote:
>- What it does:
>Adds a new EXPLAIN ANALYZE statement which displays the plan tree, just like
>EXPLAIN, but also executes the query and collects statistics on what
>actually happened. The current statistics collected are:
>
>Time till first tuple is returned
>Time till all tuples are returned
>Total number of tuples returned
>Number of times Rescan is called
>
This is a great idea; it's a good first step in getting some stats on how
accurate the optimizer settings are, as well as how good the assumptions
are. But you probably need to collect information about IOs & buffer hits
as well. Perhaps you should look at Jan's stats collection patches and see
if you can piggyback on them somehow?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/